COF-C03 Practice Question: Performance Optimization, Querying, and Transformation
Snowflake's optimizer uses various techniques to improve query performance dynamically. Which TWO of the following are examples of Adaptive Query Optimization?
⚠ Common exam trap
Candidates often confuse static pruning via micro-partitions with dynamic optimization techniques, failing to recognize runtime adjustments like Bloom filters and dynamic pruning.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Dynamic Pruning
Adaptive Query Optimization refers to the engine's ability to adjust its execution plan based on real-time data characteristics observed during query processing. This includes techniques like dynamic pruning and join filtering, which allow the engine to bypass irrelevant data even when static metadata is insufficient.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Static partition pruning based on metadata
Why it's wrong here
Static pruning happens during the query compilation and planning phase before execution begins. While efficient, it is not 'adaptive' because it relies on pre-existing metadata rather than adjusting its behavior based on the actual data encountered during the query's execution run.
- ✓
Dynamic Pruning
Why this is correct
Dynamic pruning occurs during query execution, specifically in join operations. When one side of a join (the build side) is processed, Snowflake uses the resulting values to prune micro-partitions from the other side (the probe side) in real-time, significantly reducing the amount of data scanned.
- ✓
Join Filtering (Bloom Filters)
Why this is correct
Snowflake uses Bloom filters to perform join filtering dynamically. As data is processed, the engine creates a compact representation of the join keys. This filter is then pushed down to the scan operators of other tables, allowing the engine to skip rows that definitely won't match.
- ✗
Manual Clustering Key assignment
Why it's wrong here
Assigning a clustering key is a manual configuration task performed by a user or administrator to influence how data is stored. It is a proactive optimization strategy rather than an adaptive behavior of the query engine during the execution of a specific SQL statement.
- ✗
Automatic Micro-partitioning
Why it's wrong here
Automatic micro-partitioning is a fundamental storage feature of Snowflake that happens during data ingestion. While it provides the foundation for all pruning, the act of creating partitions is not part of the query optimization process that adapts during query execution.
About these practice questions
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.