DA0-001 · Question #328
Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?
The correct answer is D. Clustered index. A clustered index is a special type of index that determines the physical order in which rows are stored in a table, essentially organizing the table data itself based on the index key. This structure allows for efficient retrieval of data based on the sorted key values.
Question
Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?
Options
- AForeign key
- BFunction
- CStored procedure
- DClustered index
How the community answered
(33 responses)- A3% (1)
- B6% (2)
- D91% (30)
Why each option
A clustered index is a special type of index that determines the physical order in which rows are stored in a table, essentially organizing the table data itself based on the index key. This structure allows for efficient retrieval of data based on the sorted key values.
A foreign key is a column or set of columns in a table that refers to the primary key in another table, used to enforce referential integrity, not to sort and store table row data.
A function is a block of reusable code that performs a specific task and returns a value, not an object that sorts and stores table row data.
A stored procedure is a prepared SQL code that you can save and reuse, used for executing a series of commands, not for sorting and storing table data.
A clustered index defines the physical order of data rows in the table and stores the actual table data at the leaf level of the index. When a table has a clustered index, the data rows are stored in sorted order based on the clustered index key, making the table itself sorted by that key-value pair. This provides efficient retrieval for queries that filter or sort by the clustered index columns.
Concept tested: Database indexes - clustered index
Source: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.