You administer a Microsoft Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Re
Posted: Mon Oct 17, 2022 4:48 pm
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
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