Microsoft DP-201 Actual Tests : Designing an Azure Data Solution

From a free demo to 365 days of updates and a 60-day money back guarantee, Actual4test covers every step of your DP-201 preparation in 2026. 207 Microsoft Designing an Azure Data Solution practice questions are ready the moment you are.

Microsoft DP-201 Exam Overview:

Microsoft DP-201 Exam Syllabus Topics:

Everything You Want to Know About the Microsoft DP-201 Exam

Microsoft Designing an Azure Data Solution Sample Questions:

Question 1

You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table.

You do not expect that the logs will be accessed during the retention periods.
You need to recommend a solution for account1 that meets the following requirements:
Automatically deletes the logs at the end of each retention period
Minimizes storage costs
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 2

You are designing a solution that uses Azure Cosmos DB to store and serve data.
You need to design the Azure Cosmos DB storage to meet the following requirements:
Provide high availability.
Provide a recovery point objective (RPO) of less than 15 minutes.
Provide a recovery time objective (RTO) of less than two minutes.
Minimize data loss in the event of a disaster.
What should you include in the design? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database that has columns. The columns contain sensitive Personally Identifiable Information (PII) data.
You need to design a solution that tracks and stores all the queries executed against the PII dat a. You must be able to review the data in Azure Monitor, and the data must be available for at least 45 days.
Solution: You add classifications to the columns that contain sensitive data. You turn on Auditing and set the audit log destination to use Azure Blob storage.
Does this meet the goal?

A. No
B. Yes

Question 4

A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices.
The company must be able to monitor the devices in real-time.
You need to design the solution.
What should you recommend?

A. Azure Stream Analytics Edge application using Microsoft Visual Studio
B. Azure Analysis Services using Microsoft Visual Studio
C. Azure Data Factory instance using Azure Portal
D. Azure Data Factory instance using Microsoft Visual Studio

Question 5

You need to optimize storage for CONT_SQL3.
What should you recommend?

A. AlwaysOn
B. General
C. Data warehousing
D. Transactional processing

Solutions: