Author name: Abhay Krishnan

Week 7 covered Domain 5: Time Travel, Fail-safe, cloning, replication and failover, sharing, and the Marketplace. Today is a 30-minute closed-book drill, the recurring Domain 5 traps, and the Week 7 Practice Test. 🗣️ How to use today Step Time What you do 1. Closed-book drill 30 min Run the four drill tasks below. No […]

Day 45 shared data privately between accounts with shares and reader accounts. Today opens that up to public discovery and privacy-preserving collaboration. 🗣️ Plain-English First Term What it sounds like What it means in Snowflake Snowflake Marketplace An online store for data A public catalog where providers list data and apps for consumers to query

Day 44 protected data with Time Travel, Fail-safe, and Zero-Copy Cloning. Today moves to sharing data across regions and accounts. 🗣️ Plain-English First This sub-objective mixes recovery words with collaboration words. The exam separates copying data (replication) from granting access to it (sharing). Term What it sounds like What it means in Snowflake Replication Making

Day 43 closed Domain 4. Today opens Domain 5 with its three recovery and copy features: Time Travel, Fail-safe, and Zero-Copy Cloning. 🗣️ Plain-English First This sub-objective uses recovery words that sound interchangeable. The exam treats each as a separate mechanism with its own owner and window. Term What it sounds like What it means

No new material today. Six days into Domain 4, you have read Query Profiles, separated workloads, weighed Search Optimization against clustering, and unpacked caches, window functions, and FLATTEN. Today is a 30-minute closed-book drill, the recurring Domain 4 traps, and the Week 6 Practice Test. Domain 4 carries a large share of the scored questions.

Day 41 closed with one rule to carry forward. A JSON column name is case-insensitive, but a JSON key is case-sensitive. Today that rule earns its place. Semi-structured data is JSON, XML, Avro, Parquet, and ORC stored without a fixed schema. Snowflake holds it in the VARIANT data type. You load JSON with PARSE_JSON, read

Day 40 skipped work with three caches. Today the work is the query itself. Aggregate functions like COUNT and SUM collapse many rows into one summary. Window functions run the same kind of math but keep every row. The OVER clause is the switch between them. You meet ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG, then

Day 39 changed how data sits on disk so a query reads fewer micro-partitions. Today’s topic skips the read entirely. Snowflake keeps three caches that answer a query without redoing the work. The result cache returns a whole answer that was computed before. The metadata cache answers counts and ranges from statistics alone. The warehouse

Week 7 checkpoint, Domain 5 focus. Ten questions on Time Travel, Fail-safe, cloning, sharing, the Marketplace, and clean rooms, with a target of 8 out of 10. 01 A permanent table’s Time Travel retention period has fully elapsed. The data has moved into Fail-safe. A data engineer needs it back for an audit. Who can

Week 6 checkpoint. Ten questions across Domain 4. They cover Query Profiles, the three caches, Search Optimization, the Query Acceleration Service, clustering, materialized views, window functions, and FLATTEN. The mix mirrors the real COF-C03 pattern. A few are straight recall. Several turn on an edition boundary or a qualifier word, where every option looks plausible