nerdexam
CompTIA

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.

Data Concepts and Environments

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)
  • A
    3% (1)
  • B
    6% (2)
  • D
    91% (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.

AForeign key

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.

BFunction

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.

CStored procedure

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.

DClustered indexCorrect

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

#Database concepts#Indexes#Clustered index#Table structure

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice