ExamGecko
Question list
Search
Search

Question 65 - DS0-001 discussion

Report
Export

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

A.
Columnstore
Answers
A.
Columnstore
B.
Non-clustered
Answers
B.
Non-clustered
C.
Unique
Answers
C.
Unique
D.
Secondary
Answers
D.
Secondary
Suggested answer: A

Explanation:

The index that stores records in a tabular format is columnstore. A columnstore index is a type of index that stores and compresses data by columns rather than by rows. A columnstore index can improve the performance and efficiency of queries that perform aggregations, calculations, or analysis on large amounts of data, such as data warehouse or business intelligence applications. A columnstore index can also reduce the storage space required for data by applying various compression techniques, such as dictionary encoding, run-length encoding, bit packing, etc. The other options are either different types of indexes or not related to indexes at all. For example, a non-clustered index is a type of index that stores the values of one or more columns in a sorted order along with pointers to the corresponding rows in the table; a unique index is a type of index that enforces uniqueness on one or more columns in a table; a secondary index is an alternative term for a non-clustered index.Reference:CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.1 Given a scenario, perform common database maintenance tasks.

asked 02/10/2024
mustapha amraui
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first