The answer is B.
Does the exam kit has an explanation or link to why C should be the correct answer?
3. correct answer: c
a. incorrect: When SQL Server scans the data in the physical order, this scan is called
the allocation order scan.
B. incorrect: The Clustered Index Scan is an operator that can scan data in logical or
c. correct: When SQL Server scans the data in the logical order of an index, this scan
is called the index order scan.
D. incorrect: Seek is not used for scans.
If this is special case of clustered index scan then that means clustered index scan and index order scan both should be the answer...
No idea how you can we check the index order scan has happened or not?
SQL Server DBA | MCSE SQL Server 2012/2014