The Microsoft DP-201 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Designing an Azure Data Solution certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the Microsoft Designing an Azure Data Solution will help guide you through the study process for your certification.
DP-201 Microsoft Designing an Azure Data Solution Exam Summary
● Exam Name: Microsoft Designing an Azure Data Solution
● Exam Code: DP-201
● Exam Price: $165 (USD)
● Duration: 120 mins
● Number of Questions: 40-60
● Passing Score: 700 / 1000
● Books / Training: Course DP-201T01-A: Designing an Azure Data Solution
● Schedule Exam: Pearson VUE
● Sample Questions: Microsoft Designing an Azure Data Solution Sample Questions
● Recommended Practice: Microsoft DP-201 Certification Practice Exam
Exam Syllabus: DP-201 Microsoft Certified - Azure Data Engineer Associate
1. Design Azure Data Storage Solutions (40-45%)
● Recommend an Azure data storage solution based on requirements
- choose the correct data storage solution to meet the technical and business requirements
- choose the partition distribution type
● Design non-relational cloud data stores
- design data distribution and partitions
- design for scale (including multi-region, latency, and throughput)
- design a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage
- select the appropriate Cosmos DB API
- design a disaster recovery strategy
- design for high availability
● Design relational cloud data stores
- design data distribution and partitions
- design for scale (including latency and throughput)
- design a solution that uses Azure Synapse Analytics
- design a disaster recovery strategy
- design for high availability
2. Design Data Processing Solutions (25-30%)
● Design batch processing solutions
- design batch processing solutions that use Data Factory and Azure Databricks
- identify the optimal data ingestion method for a batch processing solution
- identify where processing should take place, such as at the source, at the destination, or in transit
● Design real-time processing solutions
- design for real-time processing by using Stream Analytics and Azure Databricks
- design and provision compute resources
3. Design for Data Security and Compliance (25-30%)
● Design security for source data access
- plan for secure endpoints (private/public)
- choose the appropriate authentication mechanism, such as access keys, shared access signatures (SAS), and Azure Active Directory (Azure AD)
● Design security for data policies and standards
- design data encryption for data at rest and in transit
- design for data auditing and data masking
- design for data privacy and data classification
- design a data retention policy
- plan an archiving strategy
- plan to purge data based on business requirements
Microsoft DP-201 Certification Sample Questions and Answers
To make you familiar with Microsoft Designing an Azure Data Solution (DP-201) certification exam structure, we have prepared this sample question set. We suggest you try ourSample Questions for Designing an Azure Data Solution DP-201 Certification to test your understanding of Microsoft DP-201 process with real Microsoft certification exam environment.
DP-201 Microsoft Designing an Azure Data Solution Sample Questions:-
01. You need to design the solution for the government planning department. Which services should you include in the design?
a) Azure Synapse Analytics and Elastic Queries
b) Azure SQL Database and Polybase
c) Azure Synapse Analytics and Polybase
d) Azure SQL Database and Elastic Queries
02. 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 Data Factory instance using Azure Portal
b) Azure Analysis Services using Microsoft Visual Studio
c) Azure Stream Analytics Edge application using Microsoft Visual Studio
d) Azure Data Factory instance using Microsoft Visual Studio
03. An in-house team is developing a new application. The design document specifies that data should be represented using nodes and relationships in graph structures. Individual data elements are relatively small.
You need to recommend an appropriate data storage solution. Which solution should you recommend?
a) Azure Storage Blobs
b) Cosmos DB
c) Azure Data Lake Store
d) HBase in HDInsight
04. Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?
a) Azure Data Lake Storage Gen2
b) Azure Cosmos DB
c) Azure SQL Database
d) Azure SQL Data Warehouse
05. You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Databricks and PolyBase in Azure Synapse Analytics.
You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the files can be queried quickly and that the data type information is retained.
What should you recommend?
a) Avro
b) CSV
c) Parquet
d) JSON
06. Reference Scenario: click here
A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages.
You need to recommend the redundancy type for the solution. What should you recommend?
a) Read-access geo-redundant storage
b) Locally-redundant storage
c) Geo-redundant storage
d) Zone-redundant storage
07. You are designing a big data streaming solution. You need to choose the most appropriate resource for different scenarios. Which Azure resource should you choose?
To answer, drag the appropriate resource to each scenario. A resource may be used once, more than once, or not at all.
a) SQL Data Warehouse
Stream Analytics
b) SQL Data Warehouse
Databricks
c) Stream Analytics
Data Lake
d) loT Hub
Data Factory
08. You are designing a real-time processing solution by using Stream Analytics. You want to count the number of weather reports that are received per time zone every minute. You need to choose the appropriate windowing function.
Which windowing function should you choose?
a) Session
b) Sliding
c) Hopping
d) Tumbling
09. You need to design the unauthorized data usage detection system. What Azure service should you include in the design?
a) Azure Analysis Services
b) Azure SQL Data Warehouse
c) Azure Databricks
d) Azure Data Factory
10. You need to design the storage for the visual monitoring system. Which storage solution should you recommend?
a) Azure Blob storage
b) Azure Table storage
c) Azure SQL database
d) Azure Media Services
Answers:-
Answer 1:- c
Answer 2:- c
Answer 3:- b
Answer 4:- a
Answer 5:- c
Answer 6:- c
Answer 7:- a
Answer 8:- d
Answer 9:- c
Answer 10:- a