How should you complete the Transact-SQL statement?

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.

View Answer

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: WITH COPY_ONLY

Reference: https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed-instance/ba-p/386154