DP-300 Exam Question 191
You have an Azure subscription.
You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:
- Minimize how long it takes to fail over.
- Maintain existing connections to the primary replica during a
failover.
What should you do?
You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:
- Minimize how long it takes to fail over.
- Maintain existing connections to the primary replica during a
failover.
What should you do?
DP-300 Exam Question 192
SIMULATION
You need to increase the maximum storage size of the query store on db1 to 4,000 MB.
You may need to use SQL Server Management Studio and the Azure portal.
You need to increase the maximum storage size of the query store on db1 to 4,000 MB.
You may need to use SQL Server Management Studio and the Azure portal.
DP-300 Exam Question 193
You have an Azure subscription.
You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.
You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:
- Install critical updates for SQL Server automatically.
- Minimize performance impact on the virtual machine.
Which management mode should you select?
You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.
You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:
- Install critical updates for SQL Server automatically.
- Minimize performance impact on the virtual machine.
Which management mode should you select?
DP-300 Exam Question 194
A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

You need to recommend changes to the data types to reduce storage and improve performance.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You need to recommend changes to the data types to reduce storage and improve performance.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 195
Hotspot Question
You have a new Azure SQL managed instance.
You plan to create a SQL Server Agent job named SalesTotal.
You need to ensure that SalesTotal can send out notifications.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a new Azure SQL managed instance.
You plan to create a SQL Server Agent job named SalesTotal.
You need to ensure that SalesTotal can send out notifications.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.


