Microsoft
DP-201 Exam
Designing an Azure Data Solution
QUESTIONS & ANSWERS
(Demo Version)
Thank You For Downloading DP-201 Exam PDF Demo
Get Full DP-201 Exam PDF Here
https://qualitydumps.com/microsoft/dp-201-exam-dumps/
, Microsoft
DP-201 Exam
Designing an Azure Data Solution Exam
Questions & Answers
Demo
,Questions & Answers PDF Page 2
Version: 8.0
Case Study: 1
Trey Research Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next sections of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment, and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Background
Trey Research is a technology innovator. The company partners with regional transportation
department office to build solutions that improve traffic flow and safety.
The company is developing the following solutions: Regional transportation departments installed
traffic sensor systems on major highways across North America. Sensors record the following
information each time a vehicle passes in front of a sensor:
,Questions & Answers PDF Page 3
-Time -Location in latitude and longitude -Speed in kilometers per second (kmps) -License plate
number -Length of vehicle in meters
Sensors provide data by using the following structure: Traffic sensors will occasionally capture an
image of a vehicle for debugging purposes. You must optimize performance of saving/storing vehicle
images.
Traffic sensor data
-Sensors must have permission only to add items to the SensorData collection.
-Traffic data insertion rate must be maximized.
-Once every three months all traffic sensor data must be analyzed to look for data patterns that
indicate sensor malfunctions.
-Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData -The
impact of vehicle images on sensor data throughout must be minimized.
,Questions & Answers PDF Page 4
Backtrack
This solution reports on all data related to a specific vehicle license plate. The report must use data
from the SensorData collection. Users must be able to filter vehicle data in the following ways:
-vehicles on a specific road
-vehicles driving above the speed limit
Planning Assistance
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
Data from the Sensor Data collection will automatically be loaded into the Planning Assistance
database once a week by using Azure Data Factory. You must be able to manually trigger the data
load process.
Privacy and security policy
-Azure Active Directory must be used for all services where it is available.
-For privacy reasons, license plate number information must not be accessible in Planning Assistance.
-Unauthorized usage of the Planning Assistance data must be detected as quickly as possible.
-Unauthorized usage is determined by looking for an unusual pattern of usage.
-Data must only be stored for seven years.
Performance and availability
-The report for Backtrack must execute as quickly as possible. -The SLA for Planning Assistance is 70
percent, and multiday outages are permitted.
-All data must be replicated to multiple geographic regions to prevent data loss. -You must maximize
the performance of the Real Time Response system.
Financial requirements
Azure resource costs must be minimized where possible.
Question: 1
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.
References: https://azure.microsoft.com/es-es/blog/introducing-premium-storage-high-
,Questions & Answers PDF Page 5
performance-storagefor-azure-virtual-machine-workloads/
Question: 2
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.
References: https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
Question: 3
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.
,Questions & Answers PDF Page 6
Answer:
Explanation:
,Questions & Answers PDF Page 7
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.
References: https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels
Question: 4
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.
,Questions & Answers PDF Page 8
Question: 5
You need to design the runtime environment for the Real Time Response system. What should you
recommend?
A. General Purpose nodes without the Enterprise Security package
B. Memory Optimized Nodes without the Enterprise Security package
C. Memory Optimized nodes with the Enterprise Security package
D. General Purpose nodes with the Enterprise Security package
Answer: B
Question: 6
DRAG DROP
You need to ensure that performance requirements for Backtrack reports are met.
What should you recommend? To answer, drag the appropriate technologies to the correct locations.
Each technology may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
, Questions & Answers PDF Page 9
Box 1: Cosmos DB indexes The report for Backtrack must execute as quickly as possible. You can
override the default indexing policy on an Azure Cosmos container, this could be useful if you want to
tune the indexing precision to improve the query performance or to reduce the consumed storage.
Box 2: Cosmos DB TTL This solution reports on all data related to a specific vehicle license plate. The
report must use data from the SensorData collection. Users must be able to filter vehicle data in the
following ways:
Note: With Time to Live or TTL, Azure Cosmos DB provides the ability to delete items automatically
from a container after a certain time period. By default, you can set time to live at the container level
and override the value on a per-item basis. After you set the TTL at a container or at an item level,
Azure Cosmos DB will automatically remove these items after the time period, since the time they
were last modified.
Question: 7
HOTSPOT
You need to design the authentication and authorization methods for sensors. What should you
recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct
selection is worth one point.
DP-201 Exam
Designing an Azure Data Solution
QUESTIONS & ANSWERS
(Demo Version)
Thank You For Downloading DP-201 Exam PDF Demo
Get Full DP-201 Exam PDF Here
https://qualitydumps.com/microsoft/dp-201-exam-dumps/
, Microsoft
DP-201 Exam
Designing an Azure Data Solution Exam
Questions & Answers
Demo
,Questions & Answers PDF Page 2
Version: 8.0
Case Study: 1
Trey Research Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on
this exam. You must manage your time to ensure that you are able to complete all questions included
on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is
provided in the case study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each question is
independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next sections of the exam. After you begin a
new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane
to explore the content of the case study before you answer the questions. Clicking these buttons
displays information such as business requirements, existing environment, and problem statements.
If the case study has an All Information tab, note that the information displayed is identical to the
information displayed on the subsequent tabs. When you are ready to answer a question, click the
Question button to return to the question.
Background
Trey Research is a technology innovator. The company partners with regional transportation
department office to build solutions that improve traffic flow and safety.
The company is developing the following solutions: Regional transportation departments installed
traffic sensor systems on major highways across North America. Sensors record the following
information each time a vehicle passes in front of a sensor:
,Questions & Answers PDF Page 3
-Time -Location in latitude and longitude -Speed in kilometers per second (kmps) -License plate
number -Length of vehicle in meters
Sensors provide data by using the following structure: Traffic sensors will occasionally capture an
image of a vehicle for debugging purposes. You must optimize performance of saving/storing vehicle
images.
Traffic sensor data
-Sensors must have permission only to add items to the SensorData collection.
-Traffic data insertion rate must be maximized.
-Once every three months all traffic sensor data must be analyzed to look for data patterns that
indicate sensor malfunctions.
-Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData -The
impact of vehicle images on sensor data throughout must be minimized.
,Questions & Answers PDF Page 4
Backtrack
This solution reports on all data related to a specific vehicle license plate. The report must use data
from the SensorData collection. Users must be able to filter vehicle data in the following ways:
-vehicles on a specific road
-vehicles driving above the speed limit
Planning Assistance
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
Data from the Sensor Data collection will automatically be loaded into the Planning Assistance
database once a week by using Azure Data Factory. You must be able to manually trigger the data
load process.
Privacy and security policy
-Azure Active Directory must be used for all services where it is available.
-For privacy reasons, license plate number information must not be accessible in Planning Assistance.
-Unauthorized usage of the Planning Assistance data must be detected as quickly as possible.
-Unauthorized usage is determined by looking for an unusual pattern of usage.
-Data must only be stored for seven years.
Performance and availability
-The report for Backtrack must execute as quickly as possible. -The SLA for Planning Assistance is 70
percent, and multiday outages are permitted.
-All data must be replicated to multiple geographic regions to prevent data loss. -You must maximize
the performance of the Real Time Response system.
Financial requirements
Azure resource costs must be minimized where possible.
Question: 1
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.
References: https://azure.microsoft.com/es-es/blog/introducing-premium-storage-high-
,Questions & Answers PDF Page 5
performance-storagefor-azure-virtual-machine-workloads/
Question: 2
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.
References: https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
Question: 3
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.
,Questions & Answers PDF Page 6
Answer:
Explanation:
,Questions & Answers PDF Page 7
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.
References: https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels
Question: 4
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.
,Questions & Answers PDF Page 8
Question: 5
You need to design the runtime environment for the Real Time Response system. What should you
recommend?
A. General Purpose nodes without the Enterprise Security package
B. Memory Optimized Nodes without the Enterprise Security package
C. Memory Optimized nodes with the Enterprise Security package
D. General Purpose nodes with the Enterprise Security package
Answer: B
Question: 6
DRAG DROP
You need to ensure that performance requirements for Backtrack reports are met.
What should you recommend? To answer, drag the appropriate technologies to the correct locations.
Each technology may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
, Questions & Answers PDF Page 9
Box 1: Cosmos DB indexes The report for Backtrack must execute as quickly as possible. You can
override the default indexing policy on an Azure Cosmos container, this could be useful if you want to
tune the indexing precision to improve the query performance or to reduce the consumed storage.
Box 2: Cosmos DB TTL This solution reports on all data related to a specific vehicle license plate. The
report must use data from the SensorData collection. Users must be able to filter vehicle data in the
following ways:
Note: With Time to Live or TTL, Azure Cosmos DB provides the ability to delete items automatically
from a container after a certain time period. By default, you can set time to live at the container level
and override the value on a per-item basis. After you set the TTL at a container or at an item level,
Azure Cosmos DB will automatically remove these items after the time period, since the time they
were last modified.
Question: 7
HOTSPOT
You need to design the authentication and authorization methods for sensors. What should you
recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct
selection is worth one point.
