DP-300 Exam Question 56
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 secondary replica?
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 secondary replica?
DP-300 Exam Question 57
You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.
Which deployment option and pricing tier should you configure?
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.
Which deployment option and pricing tier should you configure?
DP-300 Exam Question 58
You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?
You need to implement automatic tuning for the databases of MI1.
What should you do?
DP-300 Exam Question 59
You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure SQL Server named Server1 in the West US Azure region.
You need to ensure that any Azure services deployed to RG1 can access Server1.
How should you complete the Azure Command-Line Interface <CU) command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to ensure that any Azure services deployed to RG1 can access Server1.
How should you complete the Azure Command-Line Interface <CU) command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 60
You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?
You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?