Hugo Kornelis (11/9/2010)
Nice, easy question.
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).
I'm one of those that selected None of the Above. That was because it has nothing to do with recovery models. The model, master, and tempdb databases are prohibited from having snapshots. That, in my opinion, means that "True" cannot be the correct answer to this question and I already know that "False" was wrong. The only other option was "None of the Above" which I thought would mean "It depends on which database."