HOTSPOT -
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
98-364 Exam QuestionsBrowse all questions from this exam
98-364 Exam - Question 97
Show AnswerHide Answer
Correct Answer: 
Discussion
6 commentsgtc108
Jan 23, 2020A clustered index sorts and stores the data rows of the table or view in order based on the index key. This type of index is implemented as a B-tree structure that supports fast retrieval of the rows, based on their key values. - YES
Pk
Apr 17, 2020Correct answer is No - clustered index sorts the data rows, not columns.
Jovial
May 24, 2020What about 2nd answer isnt it supposed to be non clustered index as to create a new clustered index it cant be same as the primary key which creates the clustered index right ????
defcon1
Nov 30, 2021A nonclustered index can be defined on a table or view with a clustered index or on a heap. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver15
defcon1
Nov 30, 2021A nonclustered index can be defined on a table or view with a clustered index or on a heap. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver15
Jovial
May 24, 2020What about 2nd answer isnt it supposed to be non clustered index as to create a new clustered index it cant be same as the primary key which creates the clustered index right ????
defcon1
Nov 30, 2021A nonclustered index can be defined on a table or view with a clustered index or on a heap. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver15
defcon1
Nov 30, 2021A nonclustered index can be defined on a table or view with a clustered index or on a heap. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver15
defcon1
Nov 30, 2021Correct is NO YES YES NO https://docs.microsoft.com/en-us/sql/relational-databases/indexes/indexes?view=sql-server-ver15
julie2020
Apr 6, 2020stores the data "rows" of the table? or stores the data "Columns" of a table? so what's the correct answer?
helefy
Apr 23, 2020The correct answer is clustered index sorts and stores rows of the table or view.
guzmanjd2
Jan 26, 2021Question 1 is 'NO' ----->"Clustered indexes sort and store the data rows in the table or view based on their key values. "---https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15#:~:text=Clustered%20indexes%20sort%20and%20store,stored%20in%20only%20one%20order.
urcoh
Jun 2, 2021No,no,yes,no.
adilene
Sep 1, 2021ESTA PERFECTA LA RESPUESTA: https://docs.microsoft.com/es-es/sql/relational-databases/indexes/indexes?view=sql-server-ver15