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
Suggested Answer:C🗳️
BACKUP DATABASE AS COPY OF [source_server_name.]source_database_name Is used for copying a database to the same or a different SQL Database server. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-azure-sql-database
C is correct. Tested just now.
https://www.mssqltips.com/sqlservertip/2235/creating-backups-and-copies-of-your-sql-azure-databases/#:~:text=To%20create%20a%20copy%2C%20use,DatabaseName.
-"CREATE DATABASE Orders_Reporting AS COPY OF Orders" - doesnt work
-the A seems correct
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.70-765 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RohitRaj2311
4 years, 7 months agomickeyisacat615
4 years, 5 months agoSlava_bcd81
4 years, 7 months ago