DA0-001 Question #328: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• A. 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.
• B. 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.
• C. 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.

Concept tested. Database indexes - clustered index

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver16

No community discussion yet for this question.