Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
No JOINs allowed in materialized view definition Can JOIN materialized views with other tables when querying them Single table only - cannot reference multiple tables Limited aggregate functions (COUNT, SUM, MIN, MAX) No window functions, subqueries, or complex SQL constructs Can filter, group, and perform basic calculations
A. A Materialized View cannot support any aggregate functions - Wrong - supports few aggregate functions but with some restrictions. B. A Materialized View can only reference up to two tables - Wrong - can query only a single table. C. A Materialized View cannot be joined with other tables - Wrong - We can. D. A Materialized View cannot be defined with a JOIN - Correct - Joins, including self-joins, are not supported.
D is correct