DP-200 exam

You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: Use the Azure Key Vault, not the Windows Certificate Store, to store the master key. Note: The Master Key Configuration page is where you set up your CMK (Column Master...

CORRECT TEXT Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to generate an email notification to [email protected] if the available storage in an Azure Cosmos DB database named cosmos10277521 is less...

HOTSPOT You need to mask tier 1 data. Which functions should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: A: Default Full masking according to the data types of the designated fields. For string data...

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 questions sets might have more than one correct solution, while others might not have a correct solution. After you...

HOTSPOT You have an Azure data factory that has two pipelines named PipelineA and PipelineB. PipelineA has four activities as shown in the following exhibit. PipelineB has two activities as shown in the following exhibit. You create an alert for the data factory that uses Failed pipeline runs metrics for...

DRAG DROP You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order....

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

How should you monitor SALESDB to meet the technical requirements?A . Query the sys.resource_stats dynamic management view.B . Review the Query Performance Insights for SALESDD . Query the sys.dm_os_wait_stats dynamic management view.E . Review the auditing information of SALESDView AnswerAnswer: A Explanation: Scenario: Disk IO, CPU, and memory usage must...

You have an Azure subscription that contains the resources shown in the following table. All the resources have the default encryption settings.A . Enable Azure Storage encryption for storageaccount1.B . Enable Transparent Data Encryption (TDE) for synapsedb1.C . Enable encryption at rest for cosmosdb1.D . Enable Azure Storage encryption for...