DP-201 exam

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

HOTSPOT 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. View AnswerAnswer: Explanation: Images: Azure Data Lake Storage Scenario: Image data must be stored in a single...

DRAG DROP You need to design the encryption strategy for the tagging data and customer data. What should you recommend? 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...

HOTSPOT You need to design the image processing and storage solutions. What should you recommend? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: References: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-hyperscale

HOTSPOT You need to design the data loading pipeline for Planning Assistance. 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...

DRAG DROP You discover that the highest chance of corruption or bad data occurs during nightly inventory loads. You need to ensure that you can quickly restore the data to its state before the nightly load and avoid missing any streaming data. Which three actions should you perform in sequence?...

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. View AnswerAnswer: Explanation: Sensor data must be stored in a Cosmos DB named treydata in a...

HOTSPOT You need to design network access to the SQL Server data. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: 8080 1433 is the default port, but we must change it...

You need to recommend the appropriate storage and processing solution? What should you recommend?A . Enable auto-shrink on the database.B . Flush the blob cache using Windows PowerShell.C . Enable Apache Spark RDD (RDD) caching.D . Enable Databricks IO (DBIO) caching.E . Configure the reading speed using Azure Data Studio.View...

DRAG DROP 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...