nerdexam
Dell-EMC

E20-891 · Question #107

EMC NetWorker is being proposed to a customer as a backup and recovery solution for a Microsoft SQL server. One of the customer's concerns is the ability to support database recovery at any…

The correct answer is A. Use NMSQL and set the recovery model property to Full. See the full explanation below for the reasoning.

Question

EMC NetWorker is being proposed to a customer as a backup and recovery solution for a Microsoft SQL server. One of the customer’s concerns is the ability to support database recovery at any requested time. Microsoft SQL Server Management Studio is used to display the properties of the user databases, as shown in the exhibit. How can the customer's needs be achieved?

Exhibit

E20-891 question #107 exhibit

Options

  • AUse NMSQL and set the recovery model property to Full
  • BUse NMDA and set the recovery model property to Full
  • CUse NMSQL and set the recovery model property to Simple
  • DUse NMDA and set the recovery model property to Simple

How the community answered

(59 responses)
  • A
    78% (46)
  • B
    2% (1)
  • C
    14% (8)
  • D
    7% (4)

Community Discussion

No community discussion yet for this question.

Full E20-891 Practice