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.bak’RESTORE DATABASE Orders_ReportingFROM
DISK = ‘D:\\Orders.bak
B.
BACKUP DATABASE Orders TO DISK = ‘D:\\Orders.bak’CREATE DATABASE Orders_ReportingFROM
DISK = ‘D:\\Orders.bak
C.
CREATE DATABASE Orders_Reporting AS COPY OF Orders
D.
BACKUP DATABASE Orders TO DISK = ‘D:\\Orders.bak’MIRROR 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.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-azure-sql-database