Dell-EMC
E20-818 · Question #154
You are having a discussion with a customer regarding Microsoft SQL Server 2005 database layout and the topic of separating the "data" and "log" files arises. They want to know that in addition to…
The correct answer is A. Log files should be placed on a different drive when rolling back a database. See the full explanation below for the reasoning.
Question
You are having a discussion with a customer regarding Microsoft SQL Server 2005 database layout and the topic of separating the "data" and "log" files arises. They want to know that in addition to performance, if there is another reason for selecting separate volumes for their data and log files. How would you respond to the customer's inquiry?
Options
- ALog files should be placed on a different drive when rolling back a database
- BPerformance is the only reason to separate data and log files
- CData and logs should be separate due to "Write Ahead Log" functionality
- DSeparating data and logs improves SQL Server Read/Write buffer cache functionality
How the community answered
(17 responses)- A82% (14)
- B12% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.