Microsoft
70-473 · Question #70
70-473 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
You have a Microsoft Azure SQL database named DB1 and a copy of DB1 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. Not: Each correct selection is worth one point.
Options
- ACREATE DATABASE DB1Test AS Snapshot OF DB1;
- BCREATE DATABASE DB1Test AS COPY OF DB1;
- CSELECT d.name AS DBName, d.state_desc FROME sys.databases d WHERE name - DB1Test';
- DDROP DATABASEDB1Test;
- EALTER DATABASE DB1Test SET ONLINE;
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.