Hugo Kornelis (8/30/2012)
Thanks, Koen! (EDIT: And Braindonor, who added a reply while I was typing)I submitted this question quite a long time ago - and I found that I had to spend time to research some of the options again. :w00t:
BTW, maybe it's a bit early to say anything about the percentages, but at this point I am mainly surprised at:
* 28% wrong answers on the "bitmap on computed" option - I expected this to be lower
* 17% wrong answers on the "nonclustered on a view" option - here, I expected a higher failure rate
The other percentages are (so far) about on par with my expectation.
Good question, Hugo! I guess you could say it was so good, even you learned from it! 😛
I'm most surprised that (at the time I answered) 49% thought "clustered with included columns" was a valid answer. Since the clustered index by design includes all columns at the leaf level, the only way I can see choosing that answer is if they were blindly guessing, or they reasoned that it was a trick choice and "with included columns" meant the implicit inclusion of columns rather than the explicit definition of included columns.