DP-300 Certification Practice Question #230

Question

You have an Azure subscription that contains the resources shown in the following table.

You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.
Which three Transact-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

To perform a backup and restore to Azure Blob Storage using a Shared Access Signature (SAS), a server-level credential must first be created. When using a SAS token, the credential name must match the container URL path (Option 4). When the credential is named after the container URL path, the `BACKUP` and `RESTORE` statements do not need to explicitly include the `WITH CREDENTIAL` clause, as SQL Server matches the URL path automatically (Option 5 and Option 3). Additionally, to back up to a stripe set, the backup command specifies multiple `TO URL` destinations, and the restore command must reference the matching stripe set `FROM URL` components. Option 1 contains a syntax error (`URL = URL =`), leaving Option 3 as the correct restoration step.

More DP-300 practice questions