Koen Verbeeck (2/13/2013)
This question could've been better if the question asker realized there are more than one countries in the world.
It looks to me as though a lot of the ANSWERERS need to realize that. The data points could have been:
Time: 5:10 PM
Returning: 2012-05-17 18:10:42.8078994
And we'd still have the UTC function as the only possible right answer of the four given. Any inference that you were in the UK running under BST would be irrelevant.
This QOD is solid in simply telling you two things, your current time and the result of a query. The only assumption, and a perfectly reasonable one, is that the computers involved are set to their current local time.
With those three pieces of information, which function was used? The time offset forces us to say the UTC function. The further implication of the 330 minute offset that the computers are in India is interesting, but is not relevant to knowing that SYSUTCDATETIME () is the answer.