Which two statements should you execute?

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 statements 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.state-desc
FROM sys.databases d
WHERE name= ‘DB1Test’
D. DROP DATABASE DB1Test
E. ALTER DATABASE DB1TestSET ONLINE;

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.