Implementing an Azure Data Solution (DP-200) Cheat Sheet – Blog

Are you preparing to take the Implementing an Azure Data Solution exam (DP-200)? Do you need a quick revision guide? You have come to the right place. This cheat sheet provides all the necessary information and resources for the DP-200 exam in a useful way. To become a Microsoft Certified Azure Data Engineer Associate, you must pass both the DP-200 exam and the DP-201 exam. You will need to improve your data solutions knowledge by using Azure services such as Azure SQL Database and Azure Cosmos DB.
The Microsoft DP-200 exam will be retired on June 30, 2021. A new exam Data Engineering on Microsoft Azure Beta (DP-203) has been created.
Let’s start with the cheat sheet to understand the basics!
Exam: Implementing an Azure Data Solution (DP200)
The Implementing an Azure Data Solution exam (DP-200), is for those who wish to become Microsoft Azure Data Engineers and can interact with business stakeholders to understand and match data obligations in order to create data solutions that use Azure data services. There are some requirements for the DP-200 exam.
First, you must have at least one year of experience as a business intelligence professional, data professional, or data architect.
You should also demonstrate your ability and skills to present content using data platform technologies on Azure.
Microsoft also offers a learning path for the DP-200 exam. You can take the exam and test your knowledge in managing data storage solutions, developing data processing, optimizing data solutions, and monitoring them.
Cheat Sheet for Implementing an Azure Data Solution (DP-202)
It is essential that you have all the resources you need to revise effectively. Below are links and resources that will help you quickly understand the concepts and clear any doubts. Let’s get started.
Exam Objectives
This cheat will give you a quick overview of the things you already know. The exam objectives for DP-200 are the most important thing. This will help you to recall and refresh your knowledge about the DP-200 skills and topics. Reviewing the exam objectives will ensure that there is no confusion in your mind and you can concentrate on revisions. Below are the key topics for the Implementing an Azure Data Solutions (DP-200 exam). This includes:
*Updated on 24 November 2020 with some changes to the content of the DP-200 Exam. *
Implement Data Storage Solutions (40-45%).
1.1 Implement non-relational data stores
Implement a solution that uses Cosmos DB, Data Lake Storage Gen2, or Blob storage (Microsoft Documentation:Creating Azure Cosmos DB Account,Implementing Solution using Blob Storage,Implementing a solution using Data Lake Storage Gen2)
Implementing data distribution and partitions (Microsoft Documentation:Overview of Data Distribution with Azure Cosmos DB,Partitioning and horizontal scaling in Azure Cosmos DB)
Then, Implementing a consistency model in Cosmos DB (Microsoft Documentation:Choosing the right Consistency Level in Azure Cosmos DB)
Provision a non-relational datastore (Microsoft Documentation:Creating an Azure Cosmos account, database, container and Azure Portal Items)
Provide access to data to meet security requirements (Microsoft Documentation:Securing access to data in Azure Cosmos DB)
Lastly, implementing high availability, disaster recovery and global distribution (Microsoft documentation:Azure Cosmos DB worldwide distribution,Data restoring to Azure Cosmos DB).
1.2 Implement relational data stores
Accessibility