Microsoft DP900 Exam Dumps|QAs Page -35

Last updated on July 14th, 2024 at 12:00 am

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 171-175

Q171. You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
-> Minimize maintenance effort.
-> Support the Database Mail and Service Broker features.
What should you include in the solution?

  1. Azure SQL Database single database
  2. an Azure SQL Database elastic pool
  3. Azure SQL Managed instance
  4. SQL Server on Azure virtual machines
Correct Answer

3. Azure SQL Managed instance

Q172. You have an Azure subscription.
You need to implement approval-based, time-bound role activation.
What should you use?

  1. access reviews in Azure AD
  2. Azure AD Privileged Identity Management (PIM)
  3. Azure AD Identity Protection
  4. Conditional access in Azure AD
Correct Answer

2. Azure AD Privileged Identity Management (PIM)

A company is creating a canvas app to manage weekly status reports from users about projects.
Status reports must be created weekly. Users can enter project tasks with descriptions. Users can also add escalation requests for tasks that are late or at risk.
When a status report is submitted with an escalation request, the app must automatically send a text message to the submitter’s manager. A reminder must be sent at 8 PM on Sunday to everyone who has not yet submitted a status report for the previous week.
You need to identify the appropriate components to use in the solution.
What should you use? To answer, drag the appropriate implementation mechanisms to the correct requirements. Each implementation mechanism may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

dp900_question 173
Correct Answer
dp900_answer 173


Q174. You have the following two tables of customer data.

dp900_question 174-1
dp900_question 174-2

Which type of data do the tables contain?

  1. structured
  2. non-relational
  3. semi-structured
  4. unstructured
Correct Answer

4. unstructured

Q175. What is a function of a modern data warehouse?

  1. supports batch processing only
  2. supports real-time and batch processing
  3. provides built-in or native online analytical processing
  4. stores raw data only
Correct Answer

3. provides built-in or native online analytical processing


Scroll to Top