microsoft dp-201 online test

Question 1 Topic 1, Case Study 1Case Study Question View Case

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

Explanation:
Premium Storage stores data on the latest technology Solid State Drives (SSDs) whereas
Standard Storage stores data on Hard Disk Drives (HDDs). Premium Storage is designed for Azure Virtual Machine
workloads which require consistent high IO performance and low latency in order to host IO intensive workloads like OLTP,
Big Data, and Data Warehousing on platforms like SQL Server, MongoDB, Cassandra, and others. With Premium Storage,
more customers will be able to lift-and-shift demanding enterprise applications to the cloud.
Scenario: Traffic sensors will occasionally capture an image of a vehicle for debugging purposes.
You must optimize performance of saving/storing vehicle images.
The impact of vehicle images on sensor data throughout must be minimized.
Reference:
https://azure.microsoft.com/es-es/blog/introducing-premium-storage-high-performance-storagefor-azure-virtual-machine-
workloads/

Question 2 Topic 1, Case Study 1Case Study Question View Case

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

Explanation:
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
A shard typically contains items that fall within a specified range determined by one or more attributes of the data. These
attributes form the shard key (sometimes referred to as the partition key). The shard key should be static. It shouldn't be
based on data that might change.
Reference: https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding

Question 3 Topic 1, Case Study 1Case Study Question View Case

HOTSPOT
You need to design the SensorData collection.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: Eventual
Traffic data insertion rate must be maximized.
Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData
With Azure Cosmos DB, developers can choose from five well-defined consistency models on the consistency spectrum.
From strongest to more relaxed, the models include strong, bounded staleness, session, consistent prefix, and eventual
consistency.
Box 2: License plate
This solution reports on all data related to a specific vehicle license plate. The report must use data from the SensorData
collection.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels

Question 4 Topic 1, Case Study 1Case Study Question View Case

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

Explanation:
Azure resource costs must be minimized where possible.
Data used for Planning Assistance must be stored in a sharded Azure SQL Database. The SLA for Planning Assistance is
70 percent, and multiday outages are permitted.

Question 5 Topic 1, Case Study 1Case Study Question View Case

HOTSPOT
You need to design the Planning Assistance database.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: No
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
Box 2: Yes
Box 3: Yes
Planning Assistance database will include reports tracking the travel of a single vehicle Design Azure data storage solutions

Question 6 Topic 2, Case Study 2Case Study Question View Case

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 Synapse Analytics

Answer:

C

Explanation:
Image data must be stored in a single data store at minimum cost.
Note: Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive
amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as
text or binary data.
Blob storage is designed for:
Serving images or documents directly to a browser.

Storing files for distributed access.

Streaming video and audio.

Writing to log files.

Storing data for backup and restore, disaster recovery, and archiving.

Storing data for analysis by an on-premises or Azure-hosted service.

Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blobs-introduction

Question 7 Topic 2, Case Study 2Case Study Question View Case

You need to design the solution for analyzing customer data.
What should you recommend?

• A. Azure Databricks
• B. Azure Data Lake Storage
• C. Azure Synapse Analytics
• D. Azure Cognitive Services
• E. Azure Batch

Answer:

A

Explanation:
Customer data must be analyzed using managed Spark clusters. You create spark clusters through Azure Databricks.
Reference: https://docs.microsoft.com/en-us/azure/azure-databricks/quickstart-create-databricks-workspaceportal

Question 8 Topic 2, Case Study 2Case Study Question View Case

You need to recommend a solution for storing customer data.
What should you recommend?

• A. Azure Synapse Analytics
• B. Azure Stream Analytics
• C. Azure Databricks
• D. Azure SQL Database

Answer:

C

Explanation:
From the scenario:
Customer data must be analyzed using managed Spark clusters.
All cloud data must be encrypted at rest and in transit. The solution must support: parallel processing of customer data.
Reference: https://www.microsoft.com/developerblog/2019/01/18/running-parallel-apache-spark-notebookworkloads-on-
azure-databricks/

Question 9 Topic 2, Case Study 2Case Study Question View Case

HOTSPOT
You need to design storage for the solution.
Which storage services should you recommend? To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Images: Azure Data Lake Storage
Scenario: Image data must be stored in a single data store at minimum cost.
Customer data: Azure Blob Storage
Scenario: Customer data must be analyzed using managed Spark clusters.
Spark clusters in HDInsight are compatible with Azure Storage and Azure Data Lake Storage.
Azure Storage includes these data services: Azure Blob, Azure Files, Azure Queues, and Azure Tables.
Reference: https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-overview
Design Azure data storage solutions

Question 10 Topic 3, Case Study 3Case Study Question View Case

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.
Which type of disk should you recommend?

• A. Standard SSD Managed Disk
• B. Premium SSD Managed Disk
• C. Ultra SSD Managed Disk

Answer:

C

Explanation:
CONT_SQL3 requires an initial scale of 35000 IOPS.
Ultra SSD Managed Disk Offerings

The following table provides a comparison of ultra solid-state-drives (SSD) (preview), premium SSD, standard SSD, and
standard hard disk drives (HDD) for managed disks to help you decide what to use.

Reference: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disks-types