DP-201: Designing an Azure Data Solution - Free download from ExamHUB

You need to design the vehicle images storage solution.

What should you recommend?

Azure Media Services
Azure Premium Storage account
Azure Redis Cache
Azure Cosmos DB

Correct 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-storage-for-azure-virtual-machine-workloads/

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-storage-for-azure-virtual-machine-workloads/

You need to design a sharding strategy for the Planning Assistance database.

What should you recommend?

a list mapping shard map on the binary representation of the License Plate column
a range mapping shard map on the binary representation of the speed column
a list mapping shard map on the location column
a range mapping shard map on the time column

Correct 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

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

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.

Correct answer: To display the answer, ProfExam Simulator is required.

Explanation:

Box 1: EventualTraffic 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 plateThis 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

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

You need to recommend an Azure SQL Database pricing tier for Planning Assistance.

Which pricing tier should you recommend?

Business critical Azure SQL Database single database
General purpose Azure SQL Database Managed Instance
Business critical Azure SQL Database Managed Instance
General purpose Azure SQL Database single database

Correct 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.

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.

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.

Correct answer: To display the answer, ProfExam Simulator is required.

Explanation:

Box 1: NoData used for Planning Assistance must be stored in a sharded Azure SQL Database. Box 2: YesBox 3: YesPlanning Assistance database will include reports tracking the travel of a single vehicle

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

You need to recommend a solution for storing the image tagging data.

What should you recommend?

Azure File Storage
Azure Cosmos DB
Azure Blob Storage
Azure SQL Database
Azure Synapse Analytics

Correct 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 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

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

You need to design the solution for analyzing customer data.

What should you recommend?

Azure Databricks
Azure Data Lake Storage
Azure Synapse Analytics
Azure Cognitive Services
Azure Batch

Correct 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-workspace-portal

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-workspace-portal

You need to recommend a solution for storing customer data.

What should you recommend?

Azure Synapse Analytics
Azure Stream Analytics
Azure Databricks
Azure SQL Database

Correct 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-notebook-workloads-on-azure-databricks/

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-notebook-workloads-on-azure-databricks/

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.

Correct answer: To display the answer, ProfExam Simulator is required.

Explanation:

Images: Azure Data Lake StorageScenario: Image data must be stored in a single data store at minimum cost.Customer data: Azure Blob StorageScenario: 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

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

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.

Which type of disk should you recommend?

Standard SSD Managed Disk
Premium SSD Managed Disk
Ultra SSD Managed Disk

Correct 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

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.