nerdexam
Dell-EMC

E20-818 · Question #95

E20-818 Question #95: Real Exam Question with Answer & Explanation

The correct answer is A. Limited Recovery, "Attach to Database" option. See the full explanation below for the reasoning.

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

Community Discussion

No community discussion yet for this question.

Full E20-818 Practice