SK0-004 · Question #375
An administrator has been tasked with making recommendations for purchasing disks that will support a transactional database where performance is of greatest concern and budget is secondary. Which…
The correct answer is C. SAS. SAS drives are the enterprise standard for transactional databases requiring high I/O performance. FC and iSCSI are storage networking protocols, not disk types, and SATA is a lower-performance consumer-grade interface.
Question
An administrator has been tasked with making recommendations for purchasing disks that will support a transactional database where performance is of greatest concern and budget is secondary. Which the following disk types should the administrator recommend?
Options
- AFC
- BiSCSI
- CSAS
- DSATA
How the community answered
(34 responses)- A9% (3)
- B15% (5)
- C71% (24)
- D6% (2)
Why each option
SAS drives are the enterprise standard for transactional databases requiring high I/O performance. FC and iSCSI are storage networking protocols, not disk types, and SATA is a lower-performance consumer-grade interface.
FC (Fibre Channel) is a high-speed storage networking protocol used to connect servers to SANs, not a physical disk interface type comparable to SAS or SATA.
iSCSI is a network protocol that encapsulates SCSI commands over IP for SAN connectivity, not a physical disk drive type with its own spindle or interface performance characteristics.
SAS (Serial Attached SCSI) drives are engineered for enterprise workloads, offering rotational speeds of 10,000-15,000 RPM, low latency, high IOPS, and dual-port redundancy. These characteristics make SAS the standard recommendation for performance-critical transactional databases where budget is not a constraint.
SATA drives are designed for desktop and consumer use, typically spinning at 5,400-7,200 RPM with higher latency and lower IOPS than SAS, making them unsuitable when performance is the top priority.
Concept tested: Enterprise disk interface selection for database performance
Source: https://learn.microsoft.com/en-us/windows-server/storage/storage-spaces/choosing-drives
Topics
Community Discussion
No community discussion yet for this question.