Exam DS0-001 topic 1 question 77 discussion

A Columnstore index stores records in a tabular format, but unlike row-based storage, it stores data column-wise instead of row-wise. This format is optimized for analytical queries and improves performance in data warehousing and big data processing scenarios. A non-clustered index stores a separate structure that references the data rows but does not store records in a tabular format. A unique index enforces uniqueness on a column but does not dictate how records are physically stored. A secondary index is an additional index that improves query performance but does not determine how records are stored in a tabular format.