What is an object associated with a table that sorts on their key values? 'A clustered index'
An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.
Clustered indexes sort and store the data rows in the table or view based on their key values. These key values are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be stored in only one order.
The only time the data rows in a table are stored in sorted order is when the table contains a clustered index. When a table has a clustered index, the table is called a clustered table. If a table has no clustered index, its data rows are stored in an unordered structure called a heap.
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver16
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jellybiscuit
Highly Voted 1 year, 9 months agoHeetec
Highly Voted 1 year, 8 months agojames2033
Most Recent 7 months, 2 weeks agochoby
1 year agoNuriaIzard
1 year, 5 months agosanroda
1 year, 6 months ago