Which storage configuration should you use?

You administer a SQL Server 2008 instance. You plan to deploy a new database that has
the following capacity requirements: 275 GB for the database data file 50 GB for the
transaction log file The storage array has six 100-GB disk drives available for the database.
The disks are attached to a redundant array of independent disks (RAID) controller that
supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to
be maximized. The database and transaction log files must be protected in the event of a
drive failure. You need to design the storage system. Which storage configuration should
you use?

You administer a SQL Server 2008 instance. You plan to deploy a new database that has
the following capacity requirements: 275 GB for the database data file 50 GB for the
transaction log file The storage array has six 100-GB disk drives available for the database.
The disks are attached to a redundant array of independent disks (RAID) controller that
supports RAID levels 0, 1, 5, and 10. The write performance of the transaction log needs to
be maximized. The database and transaction log files must be protected in the event of a
drive failure. You need to design the storage system. Which storage configuration should
you use?

A.
A single RAID 10 volume

B.
A RAID 0 volume and a RAID 5 volume

C.
A RAID 1 volume and a RAID 5 volume

D.
A single RAID 5 volume



Leave a Reply 0

Your email address will not be published. Required fields are marked *