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.
Those couple of SET options seems to be red-herring, but they are pretty much in-line with BOL text. Here is the excerpt taken from BOL (link mentioned by Ron)
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.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter