Optimize Query Performance COF-C03 Practice Questions (Page 6)

Questions 26–29

1. 26foundation · easy

   What is micro-partition pruning in Snowflake?

   • AThe process of splitting a large micro-partition into smaller ones
   • BThe process of sorting micro-partitions by a clustering key
   • CThe process of compressing micro-partitions to reduce storage
   • DThe process of skipping entire micro-partitions that do not contain data matching the query's filter predicates
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   Which warehouse setting is used to automatically scale out to handle increased query concurrency?

   • AAuto-suspend
   • BMulti-cluster (multi-warehouse) configuration
   • CWarehouse size
   • DAuto-resume
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which Snowflake view or table provides information about the execution time and credits used for past queries?

   • AINFORMATION_SCHEMA.WAREHOUSES
   • BINFORMATION_SCHEMA.QUERY_HISTORY
   • CINFORMATION_SCHEMA.VIEWS
   • DINFORMATION_SCHEMA.TABLES
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   An e-commerce platform has a table of customer orders (5 TB) with a column `email` that is rarely used in queries, but when it is used, the query is a point lookup: `SELECT * FROM orders WHERE email = 'user@example.com'`. The table is already clustered on `order_date`. Queries on `email` are slow because they scan many micro-partitions. What is the most cost-effective way to speed up these point lookups?

   • AEnable search optimization on the `email` column.
   • BCreate a materialized view on `email`.
   • CUse a larger warehouse for those queries.
   • DAdd `email` to the clustering key.
   Reveal Solution Discussion Select an answer first