https://msdn.microsoft.com/en-us/library/gg492088.aspx

says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. Grrr.

knew one, guessed on the other, and got it wrong. Oh well.

isn't only 15k on 64-bit and 1k on 32-bit?

I think it should have been worth more that 1 point. This was a tough one, I must have checked and unchecked Dropping the index box 5 times,...

I must have read option 1 and 4 - 20 times, looking for something that was different. I chose the 4th one.

How do you get 3 rows?

hmmm - I'm looking at 2014 docs, looks like it does run DBCC CheckCatalog

I know 8k had something to do with this subject, just wasn't the right answer.

I was thinking D as many of you did.

thought for sure the path was missing from the query was the answer

pretty sure you get the red arrow if you disable a login or did I misread something here.

I blew that one.

got that one wrong. As a one man developer/DBA/Server Admin, I have god rights and don't have to think about permissions much.

2 out of 3, oh well.

I got 3 out of 4, do I get 3/4 of a point?