DP-300 Certification Practice Question #229

Question

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.
Hot Area:

Accepted Answer

SQL Managed Instance is a cloud-based managed service and does not have access to on-premises resources or local storage directly; therefore, restoring a backup using the `DISK` or `TAPE` option is unsupported. Instead, backups must be placed in Azure Blob Storage, and the native `RESTORE DATABASE ... FROM URL` command must be used to execute the restore process.

More DP-300 practice questions