You have just installed two new 400 GB hard disks in your server that you are going to use to hold a database named Inventory. You need to add, update, and delete data as fast as possible. How should you configure these hard disks?

You have just installed two new 400 GB hard disks in your server that you are going to use to hold a database named Inventory. You need to add, update, and delete data as fast as possible. How should you configure these hard disks?


D – Configure the hard disks as two independent drives.
F – Place the data file on the first volume and the log file on the second volume.

(Because you want to perform write operations as fast as possible, a mirror is not going to work for you because the write speed is very slow. And because you do not have enough disks, you cannot create a RAID-5 array (it requires three at least). RAID 0 is out of the question because of the complete lack of fault tolerance, so the best option is to create two independent disks and put the log and data files on separate disks. That way, if you lose one, you can still recover data from the other.)