CompTIA DataSys+ (DS0-001) — Question 17

Which of the following indexes stores records in a tabular format?

Answer options

• A. Columnstore
• B. Non-clustered
• C. Unique
• D. Secondary

Correct answer: A

Explanation

The correct answer is Columnstore, as this type of index is specifically designed to store data in a tabular format, optimizing for data warehousing and analytics. Non-clustered, Unique, and Secondary indexes do not inherently store records in a tabular structure, as they focus on different aspects of data organization and retrieval.