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:
A 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
What 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 ????
A 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
Question 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.
The correct answer is clustered index sorts and stores rows of the table or view.
upvoted 2 times
...
...
This section is not available anymore. Please use the main Exam Page.98-364 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.
gtc108
Highly Voted 5 years, 4 months agoPk
5 years, 1 month agoJovial
5 years agodefcon1
3 years, 6 months agodefcon1
Most Recent 3 years, 6 months agoadilene
3 years, 9 months agourcoh
4 years agoguzmanjd2
4 years, 4 months agojulie2020
5 years, 2 months agohelefy
5 years, 1 month ago