DS0-001 · Question #77
DS0-001 Question #77: Real Exam Question with Answer & Explanation
The correct answer is A: Columnstore. Columnstore indexes store data organized in a columnar, compressed tabular format - meaning data is physically arranged column-by-column rather than row-by-row, but the overall structure still represents a full table of records. This makes them highly efficient for analytical (OL
Question
Which of the following indexes stores records in a tabular format?
Options
- AColumnstore
- BNon-clustered
- CUnique
- DSecondary
Explanation
Columnstore indexes store data organized in a columnar, compressed tabular format - meaning data is physically arranged column-by-column rather than row-by-row, but the overall structure still represents a full table of records. This makes them highly efficient for analytical (OLAP) workloads that scan large volumes of data across specific columns.
Why the distractors are wrong:
- Non-clustered (B): Stores a separate index structure with pointers back to the base table rows - it does not store the actual records in tabular format.
- Unique (C): This describes a constraint (enforcing uniqueness), not a storage format. A unique index can be clustered or non-clustered.
- Secondary (D): "Secondary index" is a general term synonymous with non-clustered - it references data rather than storing it in a self-contained tabular structure.
Memory tip: Think Columnstore = Complete table stored in a column-oriented tabular layout. In Microsoft's ecosystem (SQL Server, Synapse, Power BI), the Tabular model is directly powered by the VertiPaq/columnstore engine - so "tabular" and "columnstore" are tightly paired concepts. If you see "tabular format" on an exam, think columnstore.
Community Discussion
No community discussion yet for this question.