Chapter 5 of 5 · Snowflake SnowPro Core COF-C03
Data Collaboration
Time Travel, Fail-safe, cloning, replication, Secure Data Sharing, listings and Native Apps.
- 5topics
- 27 minfast track
- 2diagrams and exhibits
- 10%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Time Travel and Fail-safeHow Snowflake Time Travel and Fail-safe protect data: retention periods by edition and table type, AT and BEFORE queries, UNDROP…Diagram6 min
- 2Zero-Copy Cloning, Replication and FailoverZero-copy cloning in Snowflake, what a clone inherits, plus database replication, replication and failover groups, editions and…5 min
- 3Secure Data Sharing - Providers, Consumers and Reader AccountsHow Snowflake Secure Data Sharing works without copying data: provider and consumer accounts, who pays, imported databases and…Diagram5 min
- 4Direct Shares, Secure Objects, Resharing and Data Clean RoomsSnowflake direct shares, secure views and UDFs, database roles, per-consumer filtering, the resharing rules and how Data Clean…6 min
- 5Snowflake Marketplace, Listings and Native AppsPrivate vs public listings, Snowflake Marketplace, free, trial and paid access, Cross-Cloud Auto-Fulfillment and how Snowflake…5 min
About this chapter
What this chapter covers
This chapter is 10% of the SnowPro Core COF-C03 exam, the smallest domain, but its questions are among the most predictable. It tests how Snowflake protects data over time, copies it inside and across accounts, and shares it with other accounts without moving it.
Expect short scenarios about a Snowflake Practitioner who must restore data, copy an environment, share with a partner or publish a data product. Questions are single answer or multiple select. Retention periods, editions and who pays for what decide most of them.
How the topics fit together
Every feature in this domain rests on the same idea: Snowflake data lives in immutable micro-partitions, and metadata decides who can see which version.
- Time Travel and Fail-safe keep past versions of data for recovery.
- Cloning copies an object in the same account by copying metadata only.
- Replication and failover copy objects to other accounts and regions for disaster recovery and cross-region use.
- Secure Data Sharing gives other accounts live, read-only access with no copy.
- Listings, Snowflake Marketplace and Native Apps package shares and applications for many consumers.
For each feature, learn three facts: which edition it needs, who pays (provider or consumer), and whether data is copied. Most answer options differ on exactly one of those.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with diagrams, tables and SQL.
- Common mistakes: the classic traps.
- What to remember for the exam: the facts to memorize.
- Check yourself: three questions to test your understanding.
Ready for more practice?
The full Snowflake SnowPro Core COF-C03 question bank has 845 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.