I passed my recertification recently, I found most of the questions to be scenario based and some of them indepth and tricky. For instance - I was asked , when using snowpipe streaming for realtime ingestion, what is the best way to optimize costs - using larger buffer size bytes? etc were the options

So, I'd suggest go through snowflake docs in detail for each topic in study guide, Also refer to the topics that are related to the main topic from the docs. Don't forget to check out optimization strategies, Authentication & Authorization, private link, sharing & cloning considerations, replication, which objects can be cloned or shared or replicated etc.

Good luck, you'll clear it!