CompTIA Data+ (DA0-001) — Question 285

Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?

Answer options

• A. Foreign key
• B. Function
• C. Stored procedure
• D. Clustered index

Correct answer: D

Explanation

A clustered index is the correct answer because it determines the physical order of data in a table based on key values, effectively sorting and storing the rows. In contrast, a foreign key is used for referential integrity, a function performs operations or calculations, and a stored procedure contains a set of SQL statements for execution, none of which primarily focuses on sorting and storing row data in the same way as a clustered index.