Apply Clustering and Materialized Views ARA-C01 Practice Questions (Page 5)

Questions 21–22

1. 21application · medium

   A table is frequently filtered on a high-cardinality column, and queries return a small subset of rows. The table is updated with new rows continuously. Which optimization is most appropriate?

   • ACreate a materialized view that pre-filters the data
   • BCreate a materialized view that aggregates the data
   • CDefine a clustering key on the filter column
   • DUse a larger warehouse to speed up scans
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which of the following is a limitation of Snowflake materialized views?

   • AThey cannot be used in queries that join multiple tables
   • BThey can only be created on tables with a clustering key
   • CThey cannot be created on tables that use certain data types like VARIANT
   • DThey must be refreshed manually after every DML operation
   Reveal Solution Discussion Select an answer first