Optimize Warehouse and Query Performance ARA-C01 Practice Questions (Page 7)

Questions 31–34

1. 31foundation · easy

   A query filters on a column that is used as a clustering key. What is the most likely benefit during query execution?

   • AThe query will use a traditional index to find the matching rows.
   • BThe query will return results from the query result cache.
   • CThe query will automatically use a larger warehouse to speed up execution.
   • DThe query will scan fewer micro-partitions because the optimizer can prune those that do not match the filter.
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   Which technique is used by Snowflake to avoid scanning entire tables when a query has a filter on a column?

   • AQuery result caching
   • BIndex-based lookup
   • CMicro-partition pruning
   • DMaterialized view usage
   Reveal Solution Discussion Select an answer first
4. 33foundation · easy

   A user runs the same query twice in a row without any changes to the underlying data. The second execution returns results almost instantly. Which Snowflake caching layer is most likely responsible for this performance improvement?

   • AMetadata cache
   • BQuery result cache
   • CWarehouse cache
   • DData cache
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A team runs a set of identical reporting queries every 5 minutes. The underlying data changes every hour. The team notices that the queries are not using the query result cache and are scanning data each time. What is the most likely reason?

   • AThe tables have clustering keys defined.
   • BThe queries are run from different warehouses.
   • CThe warehouse is set to auto-suspend after 5 minutes.
   • DThe queries include a non-deterministic function like CURRENT_TIMESTAMP.
   Reveal Solution Discussion Select an answer first