Study SnowPro COF-C02 Performance and Cost: key concepts, common traps, and exam decision cues.
This chapter is where many candidates reach for “bigger warehouse” too early. COF-C02 wants you to read query profile, cache behavior, pruning, and concurrency before you spend more credits.
| Lesson | Focus |
|---|---|
| 3.1 Query Profile & Performance Signals | Learn how to read performance evidence instead of guessing. |
| 3.2 Warehouses, Concurrency & Caching | Learn warehouse sizing, scaling, suspend behavior, and cache boundaries. |
| 3.3 Pruning, Tuning & Cost Control | Learn pruning-friendly design, tuning instincts, and credit control. |
| If the question is really about… | Go first to… |
|---|---|
| why a query is slow | 3.1 Query Profile |
| warehouse behavior, concurrency, or caching | 3.2 Warehouses & Caching |
| scan reduction or credit spend | 3.3 Pruning & Cost |