Instant Access Microsoft.DP-201.v2022-04-23.q215 Actual Practice Test Engine for Free (Page 23)

Question 106

You are designing an Azure SQL Data Warehouse for a financial services company. Azure Active Directory will be used to authenticate the users.
You need to ensure that the following security requirements are met:
* Department managers must be able to create new database.
* The IT department must assign users to databases.
* Permissions granted must be minimized.
Which role memberships should you recommend? To answer, drag the appropriate roles to the correct groups. Each role 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.

Question 107

You need to design the unauthorized data usage detection system. What Azure service should you include in the design?

A.Azure Databricks
B.Azure SQL Data Warehouse
C.Azure Analysis Services
D.Azure Data Factory

Question 108

You are designing a big data storage solution. The solution must meet the following requirements:
* Provide unlimited account sizes.
* Support a hierarchical file system.
* Be optimized for parallel analytics workloads.
Which storage solution should you use?

A.Azure Data Lake Storage Gen2
B.Azure Blob storage
C.Apache HBase in Azure HDInsight
D.Azure Cosmos DB

Question 109

Which Azure data storage solution should you recommend for each application? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 110

What should you recommend as a batch processing solution for Health Interface?

A.Azure CycleCloud
B.Azure Stream Analytics
C.Azure Data Factory
D.Azure Databricks

Correct Answer: B

Explanation
Scenario: ADatum identifies the following requirements for the Health Interface application:
Support a more scalable batch processing solution in Azure.
Reduce the amount of time it takes to add data from new hospitals to Health Interface.
Data Factory integrates with the Azure Cosmos DB bulk executor library to provide the best performance when you write to Azure Cosmos DB.
References:
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-cosmos-db
Topic 5, Data Engineer for Trey Research
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 106

Question 107

Question 108

Question 109

Question 110

Download PDF File