Which storage type is designed for high-performance database workloads requiring block-level access?

• A. Block storage offers raw blocks with high performance for databases.
• B. Object storage stores structured data with relational schema in databases.
• C. File storage uses block-level access rather than a hierarchical filesystem.
• D. Tape storage provides online access with instant retrieval.

Answer: (A)

Block-level storage is designed for high-performance database workloads that require fast, random access to data. It exposes raw storage in fixed-size blocks that the database can address directly, minimizing overhead and delivering low latency and high IOPS for data pages, logs, and indexes. This setup lets you manage the database files on top of the volumes with predictable performance and the flexibility to stripe or cache as needed.

Object storage, while scalable, stores data as objects with metadata and is optimized for throughput and large-scale access rather than low-latency, random I/O, making it less suited for transactional databases. File storage provides a file-system interface and introduces extra layering, which can add latency and reduce per-block performance for database workloads. Tape storage is designed for long-term archival and offline access, not for online, high-performance database operations.