You administer a Microsoft 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_Reporting FROM DISK = ‘D:Orders.bak
B. BACKUP DATABASE Orders TO DISK = ‘D:Orders.bak’
CREATE DATABASE Orders_Reporting FROM 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
