Microsoft DP-201 Exam Questions

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.
A company is developing a solution to manage inventory data for a group of automotive repair shops. The
solution will use Azure SQL Data Warehouse as the data store.
Shops will upload data every 10 days.
Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must
be removed.
You need to ensure that upload processes and data corruption checks do not impact reporting and analytics
processes that use the data warehouse.
Proposed solution: Configure database-level auditing in Azure SQL Data Warehouse and set retention to 10
days.
Does the solution meet the goal?

A company plans to use Azure SQL Database to support a line of business applications. The application will
manage sensitive employee data.
The solution must meet the following requirements:
Encryption must be performed by the application.
Only the client application must have access keys for encrypting and decrypting data.
Data must never appear as plain text in the database.
The strongest possible encryption method must be used.
Searching must be possible on selected data.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You are evaluating data storage solutions to support a new application.
You need to recommend a data storage solution that represents data by using nodes and relationships in
graph structures.
Which data storage solution should you recommend?

You are designing an Azure Databricks interactive cluster. The cluster will be used infrequently and will be
configured for auto-termination.
You need to ensure that the cluster configuration is retained indefinitely after the cluster is terminated. The
solution must minimize costs.
What should you do?

You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the
MongoDB API.
During testing, you discover that the migration takes longer than expected.
You need to recommend a solution that will reduce the amount of time it takes to migrate the data.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete
solution.
NOTE: Each correct selection is worth one point.