Interesting question.

My dislike of XML in most of its manifestations (and especially of the hype of XML as a universal panacea) has ensured that I have learnt practically nothing about how XML in T-SQL works. But I found I could get this one right by counting rows - two options deliver too many rows, one delivers too few. Since three of teh four optons were wrong, the other must be the right one. Well, I thought I had counted the rows right, but I don't understand this T-SQL-XML stuff well enough to be at all sure. So when I clicked on my choice and discovered it was right I was not altogether unsurprised, and quite pleased.

I have a question arising from the discussion: Why are references to parent nodes not liked?