最新的Microsoft Designing an Azure Data Solution - DP-201免費考試真題
You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?
Which pricing tier should you recommend?
正確答案: B
說明：（僅 Fast2test 成員可見）
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?
What should you include in the recommendation?
正確答案: B
說明：（僅 Fast2test 成員可見）
You are planning a streaming data solution that will use Azure Databricks. The solution will stream sales transaction data from an online store. The solution has the following specifications:
The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.
Line total sales amount and line total tax amount will be aggregated in Databricks.
Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.
You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.
What should you recommend?
The output data will contain items purchased, quantity, line total sales amount, and line total tax amount.
Line total sales amount and line total tax amount will be aggregated in Databricks.
Sales transactions will never be updated. Instead, new rows will be added to adjust a sale.
You need to recommend an output mode for the dataset that will be processed by using Structured Streaming. The solution must minimize duplicate data.
What should you recommend?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have an Azure subscription that contains an Azure virtual machine and an Azure Storage account. The virtual machine will access the storage account.
You are planning the security design for the storage account.
You need to ensure that only the virtual machine can access the storage account.
Which two actions should you include in the design? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You are planning the security design for the storage account.
You need to ensure that only the virtual machine can access the storage account.
Which two actions should you include in the design? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正確答案: B,D
說明：（僅 Fast2test 成員可見）
You need to design a telemetry data solution that supports the analysis of log files in real time.
Which two Azure services should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Which two Azure services should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正確答案: A,C
說明：（僅 Fast2test 成員可見）
You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?
正確答案: A
說明：（僅 Fast2test 成員可見）
You use Azure Data Lake Storage Gen2 to store data that data scientists and data engineers will query by using Azure Databricks interactive notebooks. The folders in Data Lake Storage will be secured, and users will have access only to the folders that relate to the projects on which they work.
You need to recommend which authentication methods to use for Databricks and Data Lake Storage to provide the users with the appropriate access. The solution must minimize administrative effort and development effort Which authentication method should you recommend for each Azure service? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
You need to recommend which authentication methods to use for Databricks and Data Lake Storage to provide the users with the appropriate access. The solution must minimize administrative effort and development effort Which authentication method should you recommend for each Azure service? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
正確答案:
References:
https://docs.azuredatabricks.net/dev-tools/api/latest/authentication.html
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lakes-store-authentication-using-azure-active-directory
You are designing a real-time processing solution for maintenance work requests that are received via email. The solution will perform the following actions:
Store all email messages in an archive.
Access weather forecast data by using the Python SDK for Azure Open Datasets.
Identify high priority requests that will be affected by poor weather conditions and store the requests in an Azure SQL database.
The solution must minimize costs.
How should you complete the solution? To answer, drag the appropriate services to the correct locations. Each service 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.
Store all email messages in an archive.
Access weather forecast data by using the Python SDK for Azure Open Datasets.
Identify high priority requests that will be affected by poor weather conditions and store the requests in an Azure SQL database.
The solution must minimize costs.
How should you complete the solution? To answer, drag the appropriate services to the correct locations. Each service 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.
正確答案:
Reference:
https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-capture-overview
https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-azure-event-hubs
You need to design the storage for the visual monitoring system.
Which storage solution should you recommend?
Which storage solution should you recommend?
正確答案: D
說明：（僅 Fast2test 成員可見）
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 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.
正確答案:
References:
https://docs.microsoft.com/en-us/rest/api/storageservices/designing-a-scalable-partitioning-strategy-for-azure-table-storage
You are designing the security for an Azure SQL database.
You have an Azure Active Directory (Azure AD) group named Group1.
You need to recommend a solution to provide Group1 with read access to the database only.
What should you include in the recommendation?
You have an Azure Active Directory (Azure AD) group named Group1.
You need to recommend a solution to provide Group1 with read access to the database only.
What should you include in the recommendation?
正確答案: C
說明：（僅 Fast2test 成員可見）