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.
Option A
B.
Option B
C.
Option C
D.
Option D
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?
‘AS COPY OF’ is in SQL 2014(Azure) not available in SQL 2012
Thanks for that bit of info. The question did mention that the admin is working on an AZURE SQL Database and NOT 2012. So A would still be correct.