E20-818 · Question #95
A replica of a Microsoft SQL Server database needs to be created for use in an application test environment. The database replica needs to be taken simultaneously with the corresponding application…
Sign in or unlock E20-818 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
Question
A replica of a Microsoft SQL Server database needs to be created for use in an application test environment. The database replica needs to be taken simultaneously with the corresponding application file system. Replication Manager will be used to manage the replica creation process. The replica database can be mounted on a separate test database host from the production database. SQL Server has been installed on this host. Which mount recovery mode should be used when mounting this replica on the test database host?
Options
- ALimited Recovery, "Attach to Database" option
- BAdvanced Recovery, "Recovery" option
- CLimited Recovery, "File System Mount" option
- DAdvanced Recovery, "Standby" option
Unlock E20-818 to see the answer
You've previewed enough free E20-818 questions. Unlock E20-818 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.