nerdexam
CompTIA

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.

Server hardware installation and management

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)
  • B
    5% (1)
  • C
    86% (19)
  • E
    9% (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.

ACapacity

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.

BRPM

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.

CIOPSCorrect

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.

DSeek time and latencyCorrect

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.

EForm factor

Form factor describes the physical dimensions of the drive and has no bearing on the transaction throughput or latency requirements described in the scenario.

FBus width

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

#IOPS#seek time and latency#storage selection#disk performance

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice