I think A is correct, I dont knw why correct answer is D while it is not fully correct 😎
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/