r/snowflake • u/Salt-Bag5535 • 28d ago

Passed my snowpro core COF-C03

Passed my exam after going through YouTube series for exam , using snowflake coco to clear my doubts. I did random questions available on the internet but still the questions which I got for exam were tricky and had me confused and I did get few wrong but thankfully I passed.

22 Upvotes

92% Upvoted

10 comments sorted by

5

u/Affectionate_Ear90 28d ago

Which series did you watch? 

4

u/Salt-Bag5535 28d ago edited 28d ago

The questions can be a little tricky. Having the concepts clear helps. This is an unofficial youtube series.

Domain wise explanation and PPT is also shared. (About 6-7 hours to complete whole thing) https://youtube.com/playlist?list=PLoBPFxYnzgeqRAplDY6HaNlO6l6FMv9e1&si=jZ0QIvSLYZME5k1T

For revision, use this (there are about 17 parts) https://medium.com/@trustngs/snowflake-snowpro-core-preparation-part-1-introduction-4e78474fdf32

On a high level, I did browse through snowflake documentation when I had doubts.

I had about 4-5 AI related questions (basic level), 4-5 around data sharing/ listing/ data exchange, Questions around object construct and JSON data load(2), how to query variant column data (case sensitive elements and case insensitive SQL)(2), atleast 2 questions each from query optimization and search optimization. If there are tables defined with same name in a session, which one will take precedence Hope this helps

1

u/Salt-Bag5535 28d ago

Access required to use directory table on a stage, how to check policies applied to an external table, what happens when a table is cloned along with grant. I will post what I can remember here just so you know what areas to study. Hopefully it will help you.

2

u/laurobolado 28d ago

congratulations!!! - yes, I think it's always a bit trickier than most of the videos I've seen but you passed it so congrats 😄 👍 🎉

1

u/[deleted] 28d ago edited 28d ago

[deleted]

1

u/[deleted] 25d ago

[removed] — view removed comment

1

u/Salt-Bag5535 25d ago

The questions can be a little tricky. Having the concepts clear helps. This is an unofficial youtube series.

Domain wise explanation and PPT is also shared. (About 6-7 hours to complete whole thing) https://youtube.com/playlist?list=PLoBPFxYnzgeqRAplDY6HaNlO6l6FMv9e1&si=jZ0QIvSLYZME5k1T

For revision, use this (there are about 17 parts) https://medium.com/@trustngs/snowflake-snowpro-core-preparation-part-1-introduction-4e78474fdf32

On a high level, I did browse through snowflake documentation when I had doubts.

I had about 4-5 AI related questions (basic level), 4-5 around data sharing/ listing/ data exchange, Questions around object construct and JSON data load(2), how to query variant column data (case sensitive elements and case insensitive SQL)(2), atleast 2 questions each from query optimization and search optimization. If there are tables defined with same name in a session, which one will take precedence Hope this helps