You have a Microsoft
Azure SQL database named DB1 and a copy named DB1Test.
You use DB1Test to test the deployment of major updates to the database.
You discover that DB1Test contains outdated data.
You need to ensure that DB1Test contains recent data from DB1.
Which two s
tatements should you execute? Each correct answer presents part of the solution.
NOTE:
Each correct selection is worth one point.
A. CREATE DATABASE DB1Test AS Snapshot OF DB1
B. CREATE DATABASE DB1Test AS COPY OF DB1
C. SELECT d.name AS DBName, d.stat
e-desc
FROM sys.databases d
WHERE name= -DB1Test-
D. DROP DATABASE DB1Test
E. ALTER DATABASE DB1Test
SET ONLINE;
Explanation:
This command copies Database1 to a new database named Database2 on the same server. Depending on the size of your data
base, the copying operation might take some time to complete.
— Execute on the master database.
— Start copying.
CREATE DATABASE Database1_copy AS COPY OF Database1;
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-copy