nerdexam
CompTIA

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.

Cloud Architecture and Design

Question

Which of the following generally has better performance when accessing larger databases?

Options

  • ANAS
  • BSAN
  • CCIFS
  • DNFS

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    91% (29)
  • C
    3% (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.

ANAS

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.

BSANCorrect

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.

CCIFS

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.

DNFS

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

#SAN#NAS#storage performance#database storage

Community Discussion

No community discussion yet for this question.

Full CV0-003 Practice