nerdexam
CompTIA

SK0-004 · Question #10

A technician is called upon to add storage to a database server. The database administrator needs the maximum performance for accessing many small files. Which of the following specifications should…

The correct answer is D. Seek time. When accessing many small files randomly, seek time - the time required for the drive head to physically move to the target data location - is the dominant performance bottleneck.

Server hardware installation and management

Question

A technician is called upon to add storage to a database server. The database administrator needs the maximum performance for accessing many small files. Which of the following specifications should the technician focus on when selecting the drive to add to the server?

Options

  • AForm factor
  • BCapacity
  • CBus bandwidth
  • DSeek time

How the community answered

(33 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    12% (4)
  • D
    79% (26)

Why each option

When accessing many small files randomly, seek time - the time required for the drive head to physically move to the target data location - is the dominant performance bottleneck.

AForm factor

Form factor describes the physical dimensions of the drive and has no bearing on its read/write performance for small file access.

BCapacity

Capacity indicates how much data the drive can store but does not affect the speed at which small files are accessed.

CBus bandwidth

Bus bandwidth determines maximum data transfer throughput, which is only a bottleneck for large sequential transfers - not for small random file access where seek time dominates.

DSeek timeCorrect

Seek time measures how quickly a drive can position its read/write head over the correct track, which directly governs random I/O performance. For database workloads involving many small, randomly distributed files, the drive spends the majority of its time seeking rather than transferring data. Minimizing seek time is therefore the critical selection criterion for this use case.

Concept tested: Drive seek time impact on random small-file I/O

Source: https://learn.microsoft.com/en-us/windows-server/storage/storage-spaces/choosing-drives

Topics

#seek time#IOPS#small file access#database storage

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice