Microsoft DP-200 and DP-201 Exams will be Retired on August 31, 2021
Jul 07,2021
Decide to earn Microsoft Certified: Azure Data Engineer Associate certification? The required DP-200 and DP-201 exams will be Retired on August 31, 2021, and the new replacement test is DP-203. Killtest provides the latest Microsoft certification DP-200, DP-201 and DP-203 exams questions, which are all valid and proved by many Microsoft Azure Data Engineer Associate certified candidates. All the related Microsoft DP-200, DP-201 and DP-203 exam information is helpful for you to study all the Microsoft Azure Data Engineer Associate topics.
Microsoft DP-200, DP-201, DP-203 Exam Information
Candidates for Microsoft DP-200 and DP-201 exams are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to implement data solutions that use Azure data services.
Candidates for Microsoft DP-203 exam must must have solid knowledge of data processing languages, such as SQL, Python, or Scala, and they need to understand parallel processing and data architecture patterns.
DP-200, DP-201 and DP-203 Microsoft Certification Exam Topics
List all the related Microsoft certification DP-200, DP-201 and DP-203 exam topics below.
Implementing an Azure Data Solution DP-200 exam measures your ability to accomplish the following technical tasks: implement data storage solutions; manage and develop data processing; and monitor and optimize data solutions.
Designing an Azure Data Solution DP-201 exam measures your ability to accomplish the following technical tasks: design Azure data storage solutions; design data processing solutions; and design for data security and compliance.
Data Engineering on Microsoft Azure DP-203 exam measures your ability to accomplish the following technical tasks: design and implement data storage; design and develop data processing; design and implement data security; and monitor and optimize data storage and data processing.
After August 31, 2021, you only need to take DP-203 exam to earn Microsoft Certified: Azure Data Engineer Associate certification. Share some Microsoft certification DP-200, DP-201 and DP-203 exams demo questions below.
DP-200 Implementing an Azure Data Solution
You need to process and query ingested Tier 9 data.Which two options should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Azure Notification Hub
B. Transact-SQL statements
C. Azure Cache for Redis
D. Apache Kafka statements
E. Azure Event Grid
F. Azure Stream Analytics
Answer: E,F
You are monitoring the Data Factory pipeline that runs from Cosmos DB to SQL Database for Race Central. You discover that the job takes 45 minutes to run. What should you do to improve the performance of the job?
A. Decrease parallelism for the copy activities.
B. Increase that data integration units.
C. Configure the copy activities to use staged copy.
D. Configure the copy activities to perform compression.
Answer: B
DP-201 Designing an Azure Data Solution
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
You need to recommend the appropriate storage and processing solution? What should you recommend?
A. Enable auto-shrink on the database.
B. Flush the blob cache using Windows PowerShell.
C. Enable Apache Spark RDD (RDD) caching.
D. Enable Databricks IO (DBIO) caching.
E. Configure the reading speed using Azure Data Studio.
Answer: C
DP-203 Data Engineering on Microsoft Azure
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?
A. a table that has an IDENTITY property
B. a system-versioned temporal table
C. a user-defined SEQUENCE object
D. a table that has a FOREIGN KEY constraint
Answer: A