Free Microsoft DP-201 Practice Test & Real Exam Questions

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You plan to store delimited text files in an Azure Data Lake Storage account that will be organized into department folders.
You need to configure data access so that users see only the files in their respective department folder.
Solution: From the storage account, you disable a hierarchical namespace, and you use access control lists (ACLs).
Does this meet the goal?

You need to recommend a security solution that meets the requirements of Health Review.
What should you include in the recommendation?

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution.
You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region.
What should you recommend?

You have data on the 75,000 employees of your company. The data contains the properties shown in the following table.

You need to store the employee data in an Azure Cosmos DB container. Most queries on the data will filter by the Current Department and the Employee Surname properties.
Which partition key and item ID should you use for the container? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to recommend the appropriate storage and processing solution?
What should you recommend?

You are planning a big data solution in Azure.
You need to recommend a technology that meets the following requirements:
Be optimized for batch processing.
Support autoscaling.
Support per-cluster scaling.
Which technology should you recommend?

A company purchases IoT devices to monitor manufacturing machinery. The company uses an IoT appliance to communicate with the IoT devices.
The company must be able to monitor the devices in real-time.
You need to design the solution.
What should you recommend?

You are designing an Azure Cosmos DB database that will contain news articles.
The articles will have the following properties: Category, Created Datetime, Publish Datetime, Author, Headline, Body Text, and Publish Status. Multiple articles will be published in each category daily, but no two stories in a category will be published simultaneously.
Headlines may be updated over time. Publish Status will have the following values: draft, published, updated, and removed. Most articles will remain in the published or updated status. Publish Datetime will be populated only when Publish Status is set to published.
You will serve the latest articles to websites for users to consume.
You need to recommend a partition key for the database container. The solution must ensure that the articles are served to the websites as quickly as possible.
Which partition key should you recommend?

You are designing a streaming solution that must meet the following requirements:
Accept input data from an Azure IoT hub.
Write aggregated data to Azure Cosmos DB.
Calculate minimum, maximum, and average sensor readings every five minutes.
Define calculations by using a SQL query.
Deploy to multiple environments by using Azure Resource Manager templates.
What should you include in the solution?

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?

You are designing an Azure data factory that will copy data from Azure Blob storage to a data warehouse in Azure Synapse Analytics.
You need to recommend an authentication mechanism that meet the following requirements:
Identities must be validated by using Azure Active Directory (Azure AD).
Development and maintenance effort must be minimized.
Which authentication mechanism should you recommend for each service? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Which Azure service and feature should you recommend using to manage the transient data for Data Lake Storage? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.