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?
The correct answer is A. Locate the data and log files on different Symmetrix volumes. See the full explanation below for the reasoning.
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.
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- C4% (1)
- D9% (2)
Community Discussion
No community discussion yet for this question.