• Exactly, aggregate functions are deterministic. So they are allowed in indexed view. "Correct" answer is incorrect! 🙂

    Deterministic and Nondeterministic Functions:

    http://msdn.microsoft.com/en-us/library/ms178091.aspx