Please note that the Microsoft DP-201 exam question model is constantly changing. It is difficult to pass the exam without the latest information. It is recommended to take the practical exam of Pass4itsure. If you like it, click https://www.pass4itsure.com/dp-201.html DP-201 pdf (practice test) Updated: Sep 02, 2020.
DP-201 pdf | DP-201 pdf dumps | DP-201 practice test |Microsoft DP-201 practice question | Microsoft DP-201 exam question
[2020] Microsoft DP-201 free certification exam material | topics
Topics
- Design Azure data storage solutions (40-45%)
- Design data processing solutions (25-30%)
- Design for data security and compliance (25-30%)
Official practice test for Designing an Azure Data Solution
Microsoft DP-201 free certification exam material: https://docs.microsoft.com/en-us/learn/certifications/exams/dp-201
Microsoft DP-201 practice test set of Pass4itsure
Go to Microsoft Azure Data Engineer Associate DP-201 exam practice test
QUESTION 1
HOTSPOT
You are designing a solution that will use Azure Table storage. The solution will log records in the following entity.
You are evaluating which partition key to use based on the following two scenarios:
1.
Scenario1: Minimize hotspots under heavy write workloads.
2.
Scenario2: Ensure that date lookups are as efficient as possible for read workloads.
Which partition key should you use for each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
QUESTION 2
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:
Correct Answer:
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 3
You are designing an audit strategy for an Azure SQL Database environment.
You need to recommend a solution to provide real-time notifications for potential security breaches. The solution must
minimize development effort.
Which destination should you include in the recommendation?
A. Azure Blob storage
B. Azure SQL Data Warehouse
C. Azure Event Hubs
D. Azure Log Analytics
Correct Answer: D
Auditing for Azure SQL Database and SQL Data Warehouse tracks database events and writes them to an audit log in
your Azure storage account, Log Analytics workspace or Event Hubs.
Alerts in Azure Monitor can identify important information in your Log Analytics repository. They are created by alert
rules that automatically run log searches at regular intervals, and if results of the log search match particular criteria,
then an
alert record is created and it can be configured to perform an automated response.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing https://docs.microsoft.com/enus/azure/azure-monitor/learn/tutorial-response
QUESTION 4
A company stores sensitive information about customers and employees in Azure SQL Database.
You need to ensure that the sensitive data remains encrypted in transit and at rest.
What should you recommend?
A. Transparent Data Encryption
B. Always Encrypted with secure enclaves
C. Azure Disk Encryption
D. SQL Server AlwaysOn
Correct Answer: B
Incorrect Answers:
A: Transparent Data Encryption (TDE) encrypts SQL Server, Azure SQL Database, and Azure SQL Data Warehouse
data files, known as encrypting data at rest. TDE does not provide encryption across communication channels.
References: https://cloudblogs.microsoft.com/sqlserver/2018/12/17/confidential-computing-using-always-encrypted-with-secure-enclaves-in-sql-server-2019-preview/
QUESTION 5
You are designing an Azure Data Factory pipeline for processing data. The pipeline will process data that is stored in
general-purpose standard Azure storage.
You need to ensure that the compute environment is created on-demand and removed when the process is completed.
Which type of activity should you recommend?
A. Databricks Python activity
B. Data Lake Analytics U-SQL activity
C. HDInsight Pig activity
D. Databricks Jar activity
Correct Answer: C
The HDInsight Pig activity in a Data Factory pipeline executes Pig queries on your own or on-demand HDInsight
cluster.
References: https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-hadoop-pig
QUESTION 6
A company plans to use Apache Spark Analytics to analyze intrusion detection data
You need to recommend a solution to monitor network and system activities for malicious activities and policy violations.
Reports must be produced in an electronic format and sent to management. The solution must minimize administrative
efforts.
What should you recommend?
A. Azure Data Factory
B. Azure Data Lake
C. Azure Databricks
D. Azure HDInsight
Correct Answer: D
With Azure HDInsight you can set up Azure Monitor alerts that will trigger when the value of a metric or the results of a
query meet certain conditions. You can condition on a query returning a record with a value that is greater than or less
than a certain threshold, or even on the number of results returned by a query. For example, you could create an alert to
send an email if a Spark job fails or if a Kafka disk usage becomes over 90 percent full.
References: https://azure.microsoft.com/en-us/blog/monitoring-on-azure-hdinsight-part-4-workload-metrics-and-logs/
QUESTION 7
You plan to use Azure SQL Database to support a line of business app.
You need to identify sensitive data that is stored in the database and monitor access to the data.
Which three actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Enable Data Discovery and Classification.
B. Implement Transparent Data Encryption (TDE).
C. Enable Auditing.
D. Run Vulnerability Assessment.
E. Use Advanced Threat Protection.
Correct Answer: CDE
QUESTION 8
HOTSPOT
You plan to create a real-time monitoring app that alerts users when a device travels more than 200 meters away from a
designated location.
You need to design an Azure Stream Analytics job to process the data for the planned app. The solution must minimize
the amount of code developed and the number of technologies used.
What should you include in the Stream Analytics job? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Input type: Stream
You can process real-time IoT data streams with Azure Stream Analytics.
Input source: Azure IoT Hub
In a real-world scenario, you could have hundreds of these sensors generating events as a stream. Ideally, a gateway
device would run code to push these events to Azure Event Hubs or Azure IoT Hubs.
Function: Geospatial
With built-in geospatial functions, you can use Azure Stream Analytics to build applications for scenarios such as fleet
management, ride sharing, connected cars, and asset tracking.
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-get-started-with-azure-stream-analytics-toprocess-data-from-iot-devices
https://docs.microsoft.com/en-us/azure/stream-analytics/geospatial-scenarios
QUESTION 9
You need to design the storage for the telemetry capture system. What storage solution should you use in the design?
A. Azure SQL Data Warehouse
B. Azure Databricks
C. Azure Cosmos DB
Correct Answer: C
QUESTION 10
You have an on-premises MySQL database that is 800 GB in size.
You need to migrate a MySQL database to Azure Database for MySQL. You must minimize service interruption to live
sites or applications that use the database.
What should you recommend?
A. Azure Database Migration Service
B. Dump and restore
C. Import and export
D. MySQL Workbench
Correct Answer: A
You can perform MySQL migrations to Azure Database for MySQL with minimal downtime by using the newly
introduced continuous sync capability for the Azure Database Migration Service (DMS). This functionality limits the
amount of downtime that is incurred by the application.
References: https://docs.microsoft.com/en-us/azure/mysql/howto-migrate-online
QUESTION 11
You need to design the image processing solution to meet the optimization requirements for image tag data.
What should you configure? To answer, drag the appropriate setting to the correct drop targets.
Each source 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.
Select and Place:
Tagging data must be uploaded to the cloud from the New York office location.
Tagging data must be replicated to regions that are geographically close to company office locations.
QUESTION 12
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.
Hot Area:
Correct Answer:
Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData
Sensors must have permission only to add items to the SensorData collection
Box 1: Resource Token
Resource tokens provide access to the application resources within a Cosmos DB database.
Enable clients to read, write, and delete resources in the Cosmos DB account according to the permissions they\\’ve
been granted.
Box 2: Cosmos DB user
You can use a resource token (by creating Cosmos DB users and permissions) when you want to provide access to
resources in your Cosmos DB account to a client that cannot be trusted with the master key.
References:
https://docs.microsoft.com/en-us/azure/cosmos-db/secure-access-to-data
QUESTION 13
HOTSPOT
You are designing an application that will store petabytes of medical imaging data
When the data is first created, the data will be accessed frequently during the first week. After one month, the data must
be accessible within 30 seconds, but files will be accessed infrequently. After one year, the data will be accessed
infrequently but must be accessible within five minutes.
You need to select a storage strategy for the data. The solution must minimize costs.
Which storage tier should you use for each time frame? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
First week: Hot
Hot – Optimized for storing data that is accessed frequently.
After one month: Cool
Cool – Optimized for storing data that is infrequently accessed and stored for at least 30 days.
After one year: Cool
Incorrect Answers:
Archive: Optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency
requirements (on the order of hours).
References:
https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers
Best online Microsoft DP-201 pdf free download
[100% free] Microsoft Azure DP-201 pdf download https://drive.google.com/file/d/1Wmtzv2Lup7x9-U9pCg2uebaEEo5NfZHz/view?usp=sharing [drive]
Pass4itsure Discount Code 2020
Up-To 12% Discount on DP-201 pdf. The latest discount code “2020PASS” is provided below.
What customers say about Pass4itsure
P.S.
DP-201 exam pdf dumps and DP-201 practice exam questions and answers can be used to prepare exam. Join now https://www.pass4itsure.com/dp-201.html Use them correctly and you will not fail. Good luck for your exam.(After completion, you may want to take a look at the other Microsoft Azure exam! :))