CompTIA Server+ SK0-005 Practice Question
A systems administrator is configuring local storage for a new Windows Server that will host a high-volume OLTP relational database. The rack-mount server contains eight identical 2.4 TB 10 K SAS drives attached to a hardware RAID controller with battery-backed write cache. The administrator must meet the following database role requirements:
- Minimize transaction-log latency during sequential writes
- Provide high random IOPS for data files
- Maintain redundancy for all critical volumes, including the operating system
Which storage design BEST satisfies these requirements?
Create two virtual disks: a two-disk RAID 1 for both the OS and transaction logs, and a six-disk RAID 5 for database data files.
Create a single eight-disk RAID 5 virtual disk and partition it into volumes for the OS, data and transaction log files.
Stripe all eight drives as a single RAID 0 virtual disk and schedule nightly full backups to an external array.
Create three virtual disks: a two-disk RAID 1 for the operating system, a four-disk RAID 10 for database data files, and a dedicated two-disk RAID 1 for transaction log files.