Passed my Snowflake SnowPro Certification 🎉
A few things I noticed from my exam experience that might help others preparing:
The questions were not that lengthy. For me, it was mostly an elimination game between 2 likely options.
Quite a few questions around Telemetry, DMFs, Information Schema, and Account Usage/Account Schema functions — mainly understanding what does what.
Alerts and how they can send notifications using resources.
Iceberg Tables — got 1–2 questions.
Cortex AI functions, including functions like .SENTIMENT().
Result Cache vs Warehouse Cache.
Understanding spilling — where it happens and what it means.
Query Profile questions, including identifying when results came from cache.
I prepared using Coco Test and SkillCertPro. They were useful for practice, but don’t keep false hope that the exact same questions will appear in the exam. The questions can be different.
My biggest advice: keep your concepts clear about what each Snowflake functionality actually does.
For example:
Streams → capture CDC/change tracking
Tasks → schedule/automate SQL execution
DMF → data quality metrics
Resource Monitor → control/monitor warehouse credit usage
Once you understand the purpose of a feature, you can usually eliminate the wrong options even if you haven’t seen the exact question before.
Overall, it wasn’t as tough as I expected. I had zero prior experience with Snowflake and was genuinely keen to learn, so if you’re starting from scratch, don’t get intimidated.
Good luck to everyone preparing! 🚀❄️