DP-300 V0

Task 6 You need to ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895.View AnswerAnswer: To ensure that any enhancements made to the Query Optimizer through patches are available to dbl and db2 on sql37006895, you need to enable the...

You have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the...

You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently. You enable columnstore archival compression. What are two possible results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Queries...

HOTSPOT You have SQL Server on an Azure virtual machine. You review the query plan shown in the following exhibit. For each of the following statements, select yes if the statement is true. Otherwise, select no. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store

HOTSPOT You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer,...

Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.View AnswerAnswer: To configure a disaster recovery solution for db1, you can use...

Task 8 You plan to perform performance testing of db1. You need prevent db1 from reverting to the last known good query plan.View AnswerAnswer: To prevent db1 from reverting to the last known good query plan, you need to disable the automatic plan correction feature for the database. This feature...

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

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?A . For each customer, grant the customer ddl_admin to the existing schema.B . For each customer, create an additional schema...

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1. You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server. Which resource...