DP-300 Question #201: Real Exam Question with Answer & Explanation

Question

Hotspot 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. Answer:

Options

• __typehotspot
• variantdropdown

Explanation

Azure SQL Managed Instance — T-SQL Restore Question

Dropdown 1: RESTORE [DATABASE / FILE / LOG]

Correct: DATABASE

Why DATABASE is correct: RESTORE DATABASE is the T-SQL command to restore an entire database from a backup. The question asks you to restore DB1 — a full database object — so DATABASE is the appropriate keyword.

Why the alternatives are wrong:

• FILE — Not a valid standalone RESTORE option in this context. FILE = is used as a clause inside a restore statement to specify which logical file to restore, not as the command type itself.
• LOG — RESTORE LOG restores a transaction log backup (.trn file). This is used for point-in-time recovery after a full database restore, not for restoring the database itself.

Technical concept: The RESTORE statement has three main forms: RESTORE DATABASE (full/differential backup), RESTORE LOG (log backup), and RESTORE FILELISTONLY/HEADERONLY (informational). You match the command to the backup type.

Dropdown 2: FROM [DISK / TAPE / URL]

Correct: URL = N'https://mybackups.blob.core.windows.net/bkups/DB1.bak'

Why URL is correct: Azure SQL Managed Instance cannot access local disk paths or tape devices — it is a PaaS service with no access to on-premises file systems. Backups must reside in Azure Blob Storage, and FROM URL is the required syntax to reference a blob storage location.

RESTORE DATABASE DB1
FROM URL = N'https://mybackups.blob.core.windows.net/bkups/DB1.bak';

Why the alternatives are wrong:

• DISK = N'\\NAS01\$SQLBackups\DB1.bak' — FROM DISK references a local or UNC network path. Azure SQL Managed Instance has no access to on-premises NAS/file shares directly via this mechanism. This syntax is valid for SQL Server on-premises or SQL Server on Azure VMs, not Managed Instance.
• TAPE = N'\\Tape0' — Tape device support is a legacy SQL Server feature for physical tape drives. It is not supported in Azure SQL Managed Instance at all.

Technical concept: Azure SQL Managed Instance enforces that backup/restore operations use Azure Blob Storage via the URL parameter. You must also configure a credential (using CREATE CREDENTIAL) with a SAS token or managed identity to authenticate against the storage account before the restore will succeed.

No community discussion yet for this question.