Provisioning SQL Databases — Question 61

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?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because it directly copies the Orders database to create Orders_Reporting using the appropriate command syntax. Options A and B incorrectly attempt to use backup and restore, which are not required for an Azure SQL Database copy operation. Option D also misapplies backup concepts and does not achieve the intended result.