Suggested Answer:
A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column.A Reference: https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server
Answer is correct.
Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition.
Ref: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver16
What helps me remember things related to synapse, spark (firing of neurons) is remembering the brain. MPP- distributed computer nodes working parallel just like a network of neurons in the brain as well.
Clustered index will NOT sort the data physically. I know they want you to select that answer, but if you ever go for an interview, don't even think of saying "data is stored physically by the clustering key".
So, clustered index is correct for the exam, incorrect in real-life.
https://sqlwithmanoj.com/2013/06/02/clustered-index-do-not-guarantee-physically-ordering-or-sorting-of-rows/
Correct Answer.
if you have a table with a clustered index on a column called "id", all the rows with the lowest "id" value will be stored together physically on disk, followed by all the rows with the next lowest "id" value, and so on. This physical sorting allows the database to quickly locate and retrieve specific rows of data based on their indexed column values, improving query performance.
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.
raydel92
Highly Voted 2 years, 2 months agob94da7f
Most Recent 7 months agoAGTraining
9 months, 1 week agoEdgy_San
10 months agotestdumps2017
1 year, 4 months agochiiiweiii
1 year, 9 months agoPinha
1 year, 10 months agoNuriaIzard
1 year, 11 months ago