Dell-EMC
E20-885 · Question #157
The SQL database and transaction logs have been physically isolated on separate RAID groups. What other actions can be taken to optimize SQL performance?
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.
How the community answered
(35 responses)- A6% (2)
- B17% (6)
- C6% (2)
- D71% (25)
Community Discussion
No community discussion yet for this question.