Which Transact-SQL command should you use?

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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.