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

Questions 1–5

1. 1foundation · easy

   What is the effect of increasing the size of a Snowflake warehouse (e.g., from X-Small to Small)?

   • AIt increases the storage capacity of the warehouse
   • BIt reduces the cost per query
   • CIt increases the number of servers available to process queries, which can speed up query execution
   • DIt automatically enables multi-clustering for the warehouse
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake feature provides a visual representation of the steps and operators involved in executing a query, helping to identify performance bottlenecks?

   • AResult Cache
   • BQuery Profile
   • CData Sampling
   • DWarehouse Load
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A financial analytics team runs a dashboard that repeatedly executes the same aggregation query: `SELECT region, SUM(sales) FROM transactions WHERE date >= '2024-01-01' GROUP BY region`. The underlying table is large and updated frequently. The team wants to reduce query latency and cost. What should they do?

   • ACreate a materialized view on the aggregation.
   • BAdd a clustering key on `date`.
   • CEnable result caching on the warehouse.
   • DUse a larger warehouse for the dashboard.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A team runs a series of dashboards that execute the same query every 5 minutes. The underlying table is updated every hour. The team notices that the query still scans the table each time, and they want to reduce compute cost. What is the most effective approach?

   • AEnsure the query text is identical and the warehouse is the same.
   • BIncrease the warehouse size.
   • CAdd a clustering key on the filter column.
   • DUse a materialized view for the query.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Under which condition will Snowflake's result cache return a cached result for a query?

   • AThe query uses the same tables as a previous query
   • BThe query text is identical to a previously executed query and the underlying data has not changed
   • CThe query is run on the same warehouse as a previous query
   • DThe query returns the same number of rows as a previous query
   Reveal Solution Discussion Select an answer first