SK0-004 · Question #162
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 correct answer is C. IOPS D. Seek time and latency. For a high-transaction, low-capacity database workload, IOPS and seek time with latency are the critical storage metrics because they directly govern how quickly and how many discrete I/O operations the storage subsystem can service.
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).
Options
- ACapacity
- BRPM
- CIOPS
- DSeek time and latency
- EForm factor
- FBus width
How the community answered
(22 responses)- B5% (1)
- C86% (19)
- E9% (2)
Why each option
For a high-transaction, low-capacity database workload, IOPS and seek time with latency are the critical storage metrics because they directly govern how quickly and how many discrete I/O operations the storage subsystem can service.
Capacity is explicitly ruled out as a concern by the requirements, since the data volume is small, making it the least relevant criterion for this selection.
RPM is a mechanical drive property that influences IOPS and latency indirectly, but IOPS and seek time are the precise, directly measurable metrics for evaluating transactional storage performance.
IOPS (Input/Output Operations Per Second) directly measures the number of discrete read and write operations the storage device can handle per second, which is the primary bottleneck when a database processes a large number of concurrent transactions.
Seek time and latency measure how quickly the storage subsystem can locate and begin returning requested data; minimizing these values is essential for OLTP database workloads characterized by random, small-block I/O patterns where every millisecond of access delay compounds across thousands of simultaneous transactions.
Form factor describes the physical dimensions of the drive and has no bearing on the transaction throughput or latency requirements described in the scenario.
Bus width is a hardware interface specification and is not a primary drive-selection criterion when evaluating storage performance for a high-transaction database use case.
Concept tested: IOPS and latency as primary storage criteria for OLTP databases
Source: https://learn.microsoft.com/en-us/azure/virtual-machines/premium-storage-performance
Topics
Community Discussion
No community discussion yet for this question.