Dell-EMC
E20-885 · Question #157
E20-885 Question #157: Real Exam Question with Answer & Explanation
The correct answer is D. Use RAID 1/0 for transaction logs and tempDB.. See the full explanation below for the reasoning.
Question
The SQL database and transaction logs have been physically isolated on separate RAID groups. What other actions can be taken to optimize SQL performance?
Options
- AUse RAID 1/0 for transaction logs only.
- BUse RAID 5 for transaction logs and tempDB.
- CUse RAID 5 for tempDB only.
- DUse RAID 1/0 for transaction logs and tempDB.
Community Discussion
No community discussion yet for this question.