Studying for DP-201 Designing an Azure Data Solution Exam? Passquestion team uses professional knowledge and experience to provide Microsoft DP-201 Practice Test Questions for people ready to participate in Microsoft DP-201 exam. The accuracy rate of Microsoft DP-201 Practice Test Questions provided by Passquestion is very high and they can 100% guarantee you pass the DP-201 exam successfully in the first time.

Exam DP-201: Designing an Azure Data Solution

Candidates for the DP-201 exam are engineers who are responsible of designing and implementing data driven solutions using the full stack of Azure services. This post examines and provides a study guide for the exam, which is part of the Azure Data Engineer Associate certification.

Candidates for this exam must design data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage. 

Microsoft released two new Azure Data exams: Implementing an Azure Data Solution (DP-200) and Designing an Azure Data Solution (DP-201). If you pass both of these exams, you become a Microsoft Certified Azure Data Engineer Associate. 

Microsoft DP-201 Exam Skill Measured

Design Azure data storage solutions (40-45%)
Design data processing solutions (25-30%)
Design for data security and compliance (25-30%)

Download Microsoft DP-201 Practice Test Questions:

1.You need to design the vehicle images storage solution.
What should you recommend?
A. Azure Media Services
B. Azure Premium Storage account
C. Azure Redis Cache
D. Azure Cosmos DB
Answer: B

2.You need to design a sharding strategy for the Planning Assistance database.
What should you recommend?
A. a list mapping shard map on the binary representation of the License Plate column
B. a range mapping shard map on the binary representation of the speed column
C. a list mapping shard map on the location column
D. a range mapping shard map on the time column
Answer: A

3.You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?
A. Business critical Azure SQL Database single database
B. General purpose Azure SQL Database Managed Instance
C. Business critical Azure SQL Database Managed Instance
D. General purpose Azure SQL Database single database
Answer: B

4.You need to design the runtime environment for the Real Time Response system.
What should you recommend?
A. General Purpose nodes without the Enterprise Security package
B. Memory Optimized Nodes without the Enterprise Security package
C. Memory Optimized nodes with the Enterprise Security package
D. General Purpose nodes with the Enterprise Security package
Answer: B

5.You need to recommend a solution for storing the image tagging data.
What should you recommend?
A. Azure File Storage
B. Azure Cosmos DB
C. Azure Blob Storage
D. Azure SQL Database
E. Azure SQL Data Warehouse
Answer: C