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?
A.
BACKUP DATABASE Orders TO DISK = 'D:\Orders.bak' RESTORE DATABASE Orders_Reporting FROM DISK = 'D:\Orders.bak
B.
BACKUP DATABASE Orders TO DISK = 'D:\Orders.bak' CREATE 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.bak' MIRROR TO DISK = 'Orders_Reporting
Maybe it is possible that C. is the correct answer. According to post I saw.Its states the below in Azure.
The database copy process is asynchronous, which means the database copy command returns immediately and you don't need an active connection while copying since the actual copy is done by SQL Azure in the background.
The command below creates an exact copy of your source database with same edition and maximum database size.
--Script #1 - Creating a database copy
CREATE DATABASE AdventureWorksCopy
AS COPY OF AdventureWorks
GO
C: cannot be the answer, since the statement 'Create database Orders_Reporting As copy of Orders' simply creates a new database that is not the same as the Azure database Orders .
I think the answer should be A.
If you are using SQL AZURE, the option on Answer C is Available to you.
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.70-462 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.
mickeygeorge
4 years, 5 months agoAwoke
4 years, 5 months agoDadi
4 years, 10 months agoMIKU8735_0968
4 years, 6 months ago