DP-300 Exam Question 26
You have an Azure SQL managed instance.
You need to restore a database named DB1 by using Transact-SQL.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to restore a database named DB1 by using Transact-SQL.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 27
You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.
On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.
You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.
Which role should you assign to User2?
On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.
You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.
Which role should you assign to User2?
DP-300 Exam Question 28
You have the following Transact-SQL query.

Which column returned by the query represents the free space in each file?

Which column returned by the query represents the free space in each file?
DP-300 Exam Question 29
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?
DP-300 Exam Question 30
You have an Azure virtual machine named VM1 that runs Red Hat Enterprise Linux (RHEL).
You need to install and configure Microsoft SQL Server 2022 Standard on 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.

You need to install and configure Microsoft SQL Server 2022 Standard on 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.





