CV0-003 · Question #52
Which of the following generally has better performance when accessing larger databases?
The correct answer is B. SAN. SANs (Storage Area Networks) use block-level storage over dedicated high-speed networks, making them better suited for large database workloads than file-based alternatives. NAS, CIFS, and NFS all add protocol overhead that reduces performance at scale.
Question
Which of the following generally has better performance when accessing larger databases?
Options
- ANAS
- BSAN
- CCIFS
- DNFS
How the community answered
(32 responses)- A6% (2)
- B91% (29)
- C3% (1)
Why each option
SANs (Storage Area Networks) use block-level storage over dedicated high-speed networks, making them better suited for large database workloads than file-based alternatives. NAS, CIFS, and NFS all add protocol overhead that reduces performance at scale.
NAS (Network Attached Storage) uses file-level access over standard Ethernet, introducing additional protocol overhead that limits throughput and IOPS compared to block-level SAN storage.
A SAN provides block-level storage access over a dedicated, high-speed network (typically Fibre Channel or iSCSI), which allows database servers to interact with storage as if it were locally attached. This low-latency, high-throughput architecture is specifically optimized for I/O-intensive workloads like large databases, where the overhead of file-level protocols significantly degrades performance.
CIFS (Common Internet File System) is a file-sharing protocol that runs on top of NAS infrastructure, not a storage architecture itself, and adds latency unsuitable for large database performance.
NFS (Network File System) is a file-level protocol similar to CIFS and, while usable for some database workloads, introduces protocol overhead that reduces performance compared to block-level SAN storage.
Concept tested: SAN vs NAS performance for database workloads
Source: https://learn.microsoft.com/en-us/azure/storage/common/storage-introduction
Topics
Community Discussion
No community discussion yet for this question.