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.
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)- A3% (1)
- B6% (2)
- C12% (4)
- D79% (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.
Form factor describes the physical dimensions of the drive and has no bearing on its read/write performance for small file access.
Capacity indicates how much data the drive can store but does not affect the speed at which small files are accessed.
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.
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
Community Discussion
No community discussion yet for this question.