I like the point the question tries to make, but I have however some issues with the answers: how would you know what people expect? If someone not from the former British empire expects it to work, then answer A should be correct. In my country, 9 september 1752 is a perfectly valid date. I expected it to fail because there was no precision specified for the datetime2 datatype (I should check BOl to see if there is a default). So I got the question right for the wrong reason.

Conclusion: great question, but the answers could have been worked out better 😀