DP-900 · Question #307
You have a database that stores data in the format shown in the following table. Of which type of database is this an example?
The correct answer is A. column family. A column family (wide-column) database groups columns into families and stores sparse, multi-dimensional data indexed by row key, column family, column qualifier, and timestamp.
Question
Options
- Acolumn family
- Brelational
- Ckey-value
- Ddocument
How the community answered
(22 responses)- A91% (20)
- C5% (1)
- D5% (1)
Why each option
A column family (wide-column) database groups columns into families and stores sparse, multi-dimensional data indexed by row key, column family, column qualifier, and timestamp.
Column family stores organize data by grouping related columns into families rather than storing all columns in a single flat row. Systems like Apache Cassandra and HBase use this model, which is evident when data is presented with grouped column sets alongside row identifiers.
A relational database stores data in normalized tables with fixed schemas and enforces relationships via foreign keys - it does not group columns into families.
A key-value store associates a single opaque value with each key, without any internal column structure or grouping.
A document database stores semi-structured JSON or BSON documents indexed by a document ID, not organized into column families.
Concept tested: Column family non-relational database model
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/big-data/column-oriented-data-stores
Topics
Community Discussion
No community discussion yet for this question.