title: requirements for an Indexed View
body: <p>I am currently working towards my certification in SQL Server 70-461. I'm working through some practice tests at the moment and have come across a question on requirements for an indexed view. I understand that indexed views must have SCHEMABINDING and COUNT_BIG(*) if a GROUP BY clause is used and that the index must be clustered and that this will then materialise the data.</p>
  
  <pre><code>CREATE VIEW VW_Test
  AS
  SELECT ColumnA, ColumnB FROM Table
  WHERE ColumnC &gt; 200
  </code></pre>
  
  <p>In the sample question, the index is to be created on ColumnA. ColumnB and ColumnC are both computed columns.</p>
  
  <p>The question is, what are the requirements for ColumnB and ColumnC?</p>
  
  <ul>
  <li>Determinstic</li>
  <li>Precise</li>
  <li>Marked PERSISTED</li>
  </ul>
  
  <p>Unfortunately, in my training material I have not come across these terms in this context so if you can give me some guidance on what they mean then I will be able to figure it out from there.</p>