PrepAway - Latest Free Exam Questions & Answers

You administer a Windows Azure SQL Database database named Orders.

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.bakRES

TORE DATABASE Orders_Reporting FROM DISK = D:\Orders.bak

B. BACKUP DATABASE Orders TO DISK = D:\Orders.bakCREATE 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.bakMIRROR TO DISK = Orders_Reporting


Leave a Reply