DP-300 Practice Questions — Page 28

You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1.

You need to identify and repair any physical or logical corruption in DB1. The solution must meet the following requirements:

✑ Minimize how long it takes to complete the procedure.

✑ Minimize data loss.

How should you complete the command? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You have an Azure SQL database.

You need to identify whether a delayed query execution is associated to a RESOURCE_SEMAPHORE wait.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual Machines. The instances host 500 Azure SQL databases.

You need to ensure that all the databases have the same configuration. The solution must meet the following requirements:

✑ Auditing must be enabled.

✑ Azure Defender must be enabled.

✑ Public network access must be disabled.

✑ Administrative effort must be minimized.

Which two resources should you create in the subscription? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL Database instance named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.

You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1 Dev.

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

Select and Place:

You have two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. VM1 hosts a database named db1.

You plan to create a database availability group (DAG) for db1. The solution must use certificate authentication between VM1 and VM2.

You need to configure authentication for the outbound connections of VM1.

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.

Select and Place:

You have a SQL Server on Azure Virtual Machines instance that hosts a database named DB1.

You need to configure the autogrow and autoshrink settings for DB1.

Which statements should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQ1.

You need to use PowerShell to enable and configure automated patching for SQ1. The solution must include both SQL Server and Windows security updates.

How should you complete the command? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.