How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

Last Updated on October 25, 2021 by Admin 3

HOTSPOT

You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.

You need to initiate a backup of Sales.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-300 Administering Relational Databases on Microsoft Azure Part 09 Q01 096 Question
DP-300 Administering Relational Databases on Microsoft Azure Part 09 Q01 096 Question
DP-300 Administering Relational Databases on Microsoft Azure Part 09 Q01 096 Answer
DP-300 Administering Relational Databases on Microsoft Azure Part 09 Q01 096 Answer

Explanation:

Box 1: TO URL = ‘https://storage1.blob.core.windows.net/blob1/Sales.bak’
Native database backup in Azure SQL Managed Instance.
You can backup any database using standard BACKUP T-SQL command:

BACKUP DATABASE tpcc2501
TO URL = ‘https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak’
WITH COPY_ONLY

Box 2: COPY_ONLY