DP-300 V1

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: B Explanation: Scenario: SalesSQLDb1 uses database...

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results...

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

HOTSPOT You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point....

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four 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 order. View AnswerAnswer: Explanation:...

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

What should you use to migrate the PostgreSQL database?A . Azure Data BoxB . AzCopyC . Azure Database Migration ServiceD . Azure Site RecoveryView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four 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 order. View AnswerAnswer: Explanation:...

HOTSPOT You have a Microsoft SQL Server database named DB1 that contains a table named Table1. The database role membership for a user named User1 is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in...

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