DP-300

What should you implement to meet the disaster recovery requirements for the PaaS solution?A . Availability ZonesB . failover groupsC . Always On availability groupsD . geo-replicationView AnswerAnswer: B Explanation: Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal...

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

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?A . From SQL Server Configuration Manager (SSMS), enable SQL...

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?A . Configure SalesSQLDb1 as writable.B . Update the connection strings of SalesSQLDb1App1.C . Update the firewall rules of SalesSQLDb1.D . Update the users in SalesSQLDb1.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...

HOTSPOT You have SQL Server on an Azure virtual machine that contains a database named DB1. The database reports a CHECKSUM error. You need to recover the database. How should you complete the statements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth...

You have an Azure SQL database. You discover that the plan cache is full of compiled plans that were used only once. You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table. You need relieve the memory pressure. What should you configure?A...

DRAG DROP You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct...

Which audit log destination should you use to meet the monitoring requirements?A . Azure StorageB . Azure Event HubsC . Azure Log AnalyticsView AnswerAnswer: C Explanation: Scenario: Use a single dashboard to review security and audit data for all the PaaS databases. With dashboards can bring together operational data that...

D18912E1457D5D1DDCBD40AB3BF70D5D You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . sys.dm_pdw_nodes_tran_locksB . sys.dm_exec_compute_node_errorsC . sys.dm_exec_requestsD . sys.dm_cdc_errorsE . sys.dm_pdw_nodes_os_wait_statsF . sys.dm_tran_locksView AnswerAnswer:...

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?A . distributed availability groupsB ....