Free Access to Microsoft.DP-201.v2022-03-19.q119 with Valid Practice Test (Page 2)

Question 1

You need to recommend an Azure SQL Database service tier.
What should you recommend?

A.Business Critical
B.General Purpose
C.Premium
D.Standard
E.Basic

Question 2

A company installs IoT devices to monitor its fleet of delivery vehicles. Data from devices is collected from Azure Event Hub.
The data must be transmitted to Power BI for real-time data visualizations.
You need to recommend a solution.
What should you recommend?

A.Azure HDInsight with Spark Streaming
B.Apache Spark in Azure Databricks
C.Azure Stream Analytics
D.Azure HDInsight with Storm

Question 3

You need to recommend a solution to quickly identify all the columns in Health Review that contain sensitive health data.
What should you include in the recommendation?

A.classifications
B.data masking
C.SQL Server auditing
D.Azure tags

Correct Answer: A

Data Discovery & Classification introduces a set of advanced capabilities aimed at protecting data and not just the data warehouse itself. Classification/Labeling - Sensitivity classification labels tagged on the columns can be persisted in the data warehouse itself.
Reference:
https://azure.microsoft.com/sv-se/blog/announcing-public-preview-of-data-discovery-classification-for- microsoft-azure-sql-data-warehouse/ Design for data security and compliance Testlet 6 Overview You are a data engineer for Trey Research. The company is close to completing a joint project with the government to build smart highways infrastructure across North America. This involves the placement of sensors and cameras to measure traffic flow, car speed, and vehicle details.
You have been asked to design a cloud solution that will meet the business and technical requirements of the smart highway.
Solution components
Telemetry Capture
The telemetry capture system records each time a vehicle passes in front of a sensor. The sensors run on a custom embedded operating system and record the following telemetry data:
* Time
* Location in latitude and longitude
* Speed in kilometers per hour (kmph)
* Length of vehicle in meters
Visual Monitoring
The visual monitoring system is a network of approximately 1,000 cameras placed near highways that capture images of vehicle traffic every 2 seconds. The cameras record high resolution images. Each image is approximately 3 MB in size.
Requirements. Business
The company identifies the following business requirements:
* External vendors must be able to perform custom analysis of data using machine learning technologies.
* You must display a dashboard on the operations status page that displays the following metrics: telemetry, volume, and processing latency.
* Traffic data must be made available to the Government Planning Department for the purpose of modeling changes to the highway system. The traffic data will be used in conjunction with other data such as information about events such as sporting events, weather conditions, and population statistics. External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account.
* Information about vehicles that have been detected as going over the speed limit during the last 30 minutes must be available to law enforcement officers. Several law enforcement organizations may respond to speeding vehicles.
* The solution must allow for searches of vehicle images by license plate to support law enforcement investigations. Searches must be able to be performed using a query language and must support fuzzy searches to compensate for license plate detection errors.
Requirements. Security
The solution must meet the following security requirements:
* External vendors must not have direct access to sensor data or images.
* Images produced by the vehicle monitoring solution must be deleted after one month. You must minimize costs associated with deleting images from the data store.
* Unauthorized usage of data must be detected in real time. Unauthorized usage is determined by looking for unusual usage patterns.
* All changes to Azure resources used by the solution must be recorded and stored. Data must be provided to the security team for incident response purposes.
Requirements. Sensor data
You must write all telemetry data to the closest Azure region. The sensors used for the telemetry capture system have a small amount of memory available and so must write data as quickly as possible to avoid losing telemetry data.

Question 4

You are designing a real-time stream solution based on Azure Functions. The solution will process data uploaded to Azure Blob Storage.
The solution requirements are as follows:
* New blobs must be processed with a little delay as possible.
* Scaling must occur automatically.
* Costs must be minimized.
What should you recommend?

A.Deploy the Azure Function in an App Service plan and use a Blob trigger.
B.Deploy the Azure Function in a Consumption plan and use an Event Grid trigger.
C.Deploy the Azure Function in a Consumption plan and use a Blob trigger.
D.Deploy the Azure Function in an App Service plan and use an Event Grid trigger.

Question 5

You need to recommend an Azure Cosmos DB solution that meets the following requirements:
* All data that was NOT modified during the last 30 days must be purged automatically.
* The solution must NOT affect ongoing user requests.
What should you recommend using to purge the data?

A.an Azure Cosmos DB change feed queried by an Azure function
B.an Azure Cosmos DB stored procedure executed by an Azure logic app
C.Time To Live (TTL) setting in Azure Cosmos DB
D.an Azure Cosmos DB REST API Delete Document operation called by an Azure function

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File