nerdexam
Dell-EMC

E20-818 · Question #153

A customer has asked you to review their Microsoft SQL Server 2005 database layout. What are the key best practices that should be recommended?

Sign in or unlock E20-818 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.

Question

A customer has asked you to review their Microsoft SQL Server 2005 database layout. What are the key best practices that should be recommended?

Options

  • ALocate the data and log files on different Symmetrix volumes.
  • BLocate the data and log files on different Symmetrix volumes.
  • CCreate one device group for all file groups, databases, and instances.
  • DAllocate different Symmetrix volumes for "system" and "end user" databases.

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.

Full E20-818 Practice