Practice · Microsoft Certified: Azure Database Administrator Associate

~/azure-dp-300 · azure-dp-300_d1_83acee1b3cb9 ▊

← Microsoft Certified: Azure Database Administrator Associate · practice sheet

azure-dp-300_d1_83acee1b3cb9 domain/d1 · medium single

A DBA plans to migrate a SQL Server 2019 database to Azure SQL Managed Instance using native backup and restore. What is the correct method for placing the backup into Azure Storage and restoring it to the managed instance for this source version?

A Direct backup using WITH SAS CREDENTIAL, then RESTORE FROM URL with SAS CREDENTIAL
B Direct backup using the deprecated WITH CREDENTIAL syntax, then RESTORE FROM URL
C Upload the .bak file directly to Azure Storage, then RESTORE FROM DISK
D Use the Managed Instance link to replicate the backup, then fail over

Unlock this exam to join the per-question discussion and vote on questions.

next question →