L' Eomot Inversé
It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike mine, or indeed pretty well anyone elses), so in that respect it's a good question.

L' Eomot Inversé (10/6/2012)

---

It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike mine, or indeed pretty well anyone elses), so in that respect it's a good question.

L' Eomot Inversé (10/6/2012)

---

But all those settings up front are just a red herring - completely irrelevant to the question. It's not a trick question, because it's extremely unlikely that anyone thinks that those settings could have any effect on the answer. Nevertheless, I think that that stuff detracts from the quality of the question; it might leave someone wondering if there were some setting (not one of those listed) that could have affected the answer, which would be unfortunate.

The following steps are required to create an indexed view and are critical to the successful implementation of the indexed view:
1. Verify the SET options are correct for all existing tables that will be referenced in the view.
2. Verify the SET options for the session are set correctly before creating any new tables and the view.