nerdexam
CompTIA

SK0-003 · Question #729

A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution?

The correct answer is D. A single SSD. To provision storage for a 200GB database requiring extremely low seek time, a single Solid State Drive (SSD) is the best solution.

Server hardware installation and management

Question

A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution?

Options

  • AA JBOD
  • BA RAID 50 array
  • CA NAS
  • DA single SSD

How the community answered

(44 responses)
  • A
    16% (7)
  • B
    5% (2)
  • C
    7% (3)
  • D
    73% (32)

Why each option

To provision storage for a 200GB database requiring extremely low seek time, a single Solid State Drive (SSD) is the best solution.

AA JBOD

A JBOD configuration simply aggregates storage without improving seek time; it typically uses HDDs which have mechanical seek delays.

BA RAID 50 array

A RAID 50 array, while offering performance and redundancy, typically uses hard disk drives (HDDs) which have mechanical seek times significantly higher than SSDs.

CA NAS

A NAS introduces network latency and the underlying storage might still be HDD-based, making it unsuitable for "extremely low seek time" requirements.

DA single SSDCorrect

A single SSD provides extremely low seek times because it has no moving parts, relying on flash memory for data access, which is significantly faster than magnetic disks. For a 200GB database where seek time is critical, an SSD offers superior performance compared to HDD-based solutions.

Concept tested: Storage media types and performance characteristics

Source: https://learn.microsoft.com/en-us/windows-server/storage/disk-management/understanding-disk-sectors

Topics

#Storage solutions#SSD#Database storage#Performance optimization

Community Discussion

No community discussion yet for this question.

Full SK0-003 Practice