DP-300 Exam Question 1
SIMULATION
You need to ensure that any enhancements made to the Query Optimizer through patches are available to db1 and db2 on sql12345678.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to ensure that any enhancements made to the Query Optimizer through patches are available to db1 and db2 on sql12345678.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
DP-300 Exam Question 2
Drag and Drop Question
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
DP-300 Exam Question 3
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVM1 hosts a database named DB1.
You need to retrieve query plans from the Query Store on DB1.
What should you do first?
You need to retrieve query plans from the Query Store on DB1.
What should you do first?
DP-300 Exam Question 4
SIMULATION
You need to configure a monthly backup of db2. The monthly backups must be retained for five years, and then deleted.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
You need to configure a monthly backup of db2. The monthly backups must be retained for five years, and then deleted.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
DP-300 Exam Question 5
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
- During normal operations, provide at least two readable copies of
Sales.
- Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
- During normal operations, provide at least two readable copies of
Sales.
- Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication.
Does this meet the goal?