Dell-EMC
E20-818 · Question #154
E20-818 Question #154: Real Exam Question with Answer & Explanation
Sign in or unlock E20-818 to reveal the answer and full explanation for question #154. The question stem and answer options stay visible for context.
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
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.