Choosing the right storage criteria for a database server

Factors to consider when selecting storage for a database server that processes company accounts.

Prev Question Next Question

Question

A server administrator has been asked to make recommendations for purchase of a new database server that will be processing all of the company accounts.

One area of concern from prior experience is the storage type used by the database server.

The server is expected to have a large number of transactions that occur, but will not require a large amount of capacity for the data storage.

Given these requirements, which of the following storage criteria are MOST important? (Select TWO).

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F.

CD.

Based on the requirements of the scenario, the two most important storage criteria are:

C. IOPS: Input/output operations per second (IOPS) is a measure of the number of input/output operations that can be performed by a storage device per second. IOPS is an important factor to consider when selecting storage for a database server, as a high number of transactions are expected to occur. The more IOPS a storage device can provide, the faster the database server can process transactions, leading to better overall performance.

D. Seek time and latency: Seek time and latency are two measures of the time it takes for a storage device to retrieve data. Seek time is the time it takes for a read/write head to move to the correct location on the disk to retrieve data, while latency is the time it takes for the disk to spin to the correct position. A low seek time and latency are important for a database server, as they can help reduce the time it takes to retrieve data and improve performance.

A. Capacity: While capacity is an important consideration when selecting storage, it is not as important in this scenario, as the database server is not expected to require a large amount of capacity for data storage.

B. RPM: RPM, or revolutions per minute, is a measure of the speed at which a hard disk drive spins. While a higher RPM can result in faster data access times, it is not as important as IOPS and seek time/latency in this scenario.

E. Form factor: Form factor refers to the physical size and shape of a storage device. While it is important to ensure that the selected storage device is compatible with the database server, it is not as critical as IOPS and seek time/latency.

F. Bus width: Bus width refers to the number of bits that can be transferred between the storage device and the server's processor at once. While a wider bus can result in faster data transfer speeds, it is not as important as IOPS and seek time/latency in this scenario.