DP-200

HOTSPOT You need to ensure phone-based polling data upload reliability requirements are met. How should you configure monitoring? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: FileCapacity FileCapacity is the amount of storage used by...

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 a SQL pool in Azure Synapse. A user reports that queries against the pool take longer than expected to complete. You need to add monitoring to the underlying storage to help diagnose the issue. Which two metrics should you monitor? Each correct answer presents part of the solution....

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 create an Azure SQL database named db3 on an Azure SQL server named SQL10277521. Db3 must use the Sample (AdventureWorksLT)...

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

DRAG DROP You have an Azure SQL database named DB1 in the Each US 2 region. You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server. Which three actions should you perform in sequence? To answer, move the appropriate actions from...

DRAG DROP You need to ensure that phone-based polling data can be analyzed in the PollingData database. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer are and arrange them in the correct order. View AnswerAnswer: Explanation:...

You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view should you query?A . sys.dm_pdw_nodes_tran_database_transactionsB . sys.dm_pdw_waitsC . sys.dm_pdw_request_stepsD . sys.dm_pdw_exec_sessionsView AnswerAnswer: A Explanation: You...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A Explanation: We 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...

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