Exam DP-300 topic 6 question 22 discussion

DRAG DROP -
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:

Suggested Answer:
Box 1: CREATE CREDENTIAL -
[https://<
Create a credential.
The following examples create SQL Server credentials for authentication to the Microsoft Azure Blob Storage service.
CREATE CREDENTIAL [https://<mystorageaccountname>.blob.core.windows.net/<mystorageaccountcontainername>]
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = '<SAS_TOKEN>';
Incorrect:
The other CREATE CREDENTIAL option does not refer to mysqlbackups - the name of the account.
Box 2: BACKUP..
Do no include WITH CREDENTIAL when backing up To URL using Shared Access Signature.
Example:
BACKUP DATABASE AdventureWorks2016
TO URL = 'https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks2016.bak';

GO -

Box 3: RESTORE -
Do no include WITH CREDENTIAL when restoring up To URL using Shared Access Signature.
Example: BACKUP DATABASE AdventureWorks2016
TO URL = 'https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks2016.bak';

GO -
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15