DP-300 Exam Question 156
You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
DP-300 Exam Question 157
Drag and Drop Question
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server.
SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain.
Server1 hosts a file share named Share1.
You need to ensure that a SOL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege.
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 order.
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server.
SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain.
Server1 hosts a file share named Share1.
You need to ensure that a SOL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege.
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 order.
DP-300 Exam Question 158
You have an Azure subscription that contains an Azure SQL database named SQLDB1 in the Hyperscale service tier. SQLDB1 has zone-redundant storage (ZRS) enabled.
You need to create a copy of SQLDB1 in the paired Azure region. The solution must minimize administrative effort.
What should you do first?
You need to create a copy of SQLDB1 in the paired Azure region. The solution must minimize administrative effort.
What should you do first?
DP-300 Exam Question 159
Hotspot Question
You have an Azure subscription.
You plan to provision a logical SQL server for Azure SQL Database by using a Bicep template.
You need to configure the resource section of the template to ensure that the deployment always maximizes performance for network connections to the server, regardless of whether the connection originates from within or outside of Azure.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an Azure subscription.
You plan to provision a logical SQL server for Azure SQL Database by using a Bicep template.
You need to configure the resource section of the template to ensure that the deployment always maximizes performance for network connections to the server, regardless of whether the connection originates from within or outside of Azure.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 160
You have an Azure subscription.
You create a logical SQL server that hosts four databases. Each database will be used by a separate customer.
You need to ensure that each customer can access only its own database. The solution must minimize administrative effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You create a logical SQL server that hosts four databases. Each database will be used by a separate customer.
You need to ensure that each customer can access only its own database. The solution must minimize administrative effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.