You administer a Windows Azure SQL Database database named Orders.

You need to create a copy of Orders named Orders_Reporting.

Which Transact-SQL command should you use?

A. BACKUP DATABASE Orders TO DISK = D:\Orders.bakRESTORE DATABASE Orders_ReportingFROM DISK = D:\Orders.bak

B. BACKUP DATABASE Orders TO DISK = D:\Orders.bakCREATE DATABASE Orders_ReportingFROM DISK = D:\Orders.bak

C. CREATE DATABASE Orders_Reporting AS COPY OF Orders

D. BACKUP DATABASE Orders TO DISK = D:\Orders.bakMIRROR TO DISK = Orders_Reporting

Explanation:

BACKUP DATABASE -¦AS COPY OF [source_server_name.]source_database_name

Is used for copying a database to the same or a different SQL Database server.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-azure-sql-database