Câu 56: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

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?

1. A. BACKUP DATABASE Orders TO DISK = 'D:\Orders.bak' RESTORE DATABASE Orders_Reporting FROM DISK = 'D:\Orders.bak
2. B. BACKUP DATABASE Orders TO DISK = 'D:\Orders.bak' CREATE DATABASE Orders_Reporting FROM DISK = 'D:\Orders.bak
3. C. CREATE DATABASE Orders_Reporting AS COPY OF Orders — đáp án hiện tại
4. D. BACKUP DATABASE Orders TO DISK = 'D:\Orders.bak' MIRROR TO DISK = 'Orders_Reporting