Which statement is true about Snowflake materialized views?

• A. ORDER BY clause is allowed in a materialized view.
• B. A materialized view can query only a single table.
• C. Materialized views support UDFs.
• D. GROUP BY keys in a materialized view can include columns not present in the SELECT list.

Answer: (B)

Materialized views in Snowflake are precomputed results based on a query that references a single base table. This design keeps the refresh and maintenance straightforward, which is why the defining query is restricted to one table. That makes the statement about querying only a single table the correct one.

Consider why the others aren’t true: an ORDER BY clause isn’t meaningful in a materialized view’s stored results, since Snowflake doesn’t guarantee a particular storage order or retrieval order for MV data. So including ORDER BY in the MV definition isn’t supported. User-defined functions aren’t part of the standard MV definition behavior either, as MVs rely on deterministic, reproducible results and have restrictions around nonstandard functions. Finally, when you use GROUP BY, all non-aggregated columns typically need to appear in the SELECT list; you can’t group by a column that isn’t included in the output.