Chapter 3 of 5 · Snowflake DEA-C02

Storage and Data Protection

Time Travel, Fail-safe, replication, clustering, cloning, validating and rolling back changes.

  • 4topics
  • 20 minfast track
  • 2diagrams and exhibits
  • 14%of the exam

Topics in this chapter

Take them in order, or jump to the one you need.

  1. 1Time Travel, Fail-safe and ReplicationChoose the right Snowflake recovery feature: Time Travel retention, Fail-safe, how streams extend retention, and cross-region and…Diagram5 min
  2. 2Micro-partitions and ClusteringRead clustering depth and information, pick effective cluster keys, and manage Automatic Clustering cost with suspend and resume…5 min
  3. 3Zero-copy Cloning and Permission InheritanceClone Snowflake databases, schemas and tables without copying data, and learn which objects clone and how privileges, tasks and…5 min
  4. 4Validating and Rolling Back ChangesTest a Snowflake change on a clone, compare results, promote with SWAP WITH, and roll back with UNDROP, Time Travel clones and a…Diagram5 min

About this chapter

What this chapter covers

This chapter tests how a data engineer protects data and keeps large tables fast and cheap to query. It covers recovery features, the way micro-partitions and clustering affect pruning, and cloning as the base for safe releases.

Questions are scenarios such as "A Data Engineer needs to undo a bad load" or "queries on a large table scan too many partitions". Most hinge on choosing the right feature, knowing its retention or cost rule, and spotting the unwanted side effect.

How the topics fit together

A change moves through test, promotion and, if needed, recovery. Clustering keeps the tables underneath efficient.

Productionlive tablesCLONEDev clonezero copyvalidateSWAP WITHpromoteproblemTime TravelundooutageReplicationfailover
  • Recovery features cover Time Travel, the effect of streams on retention, Fail-safe and replication.
  • Micro-partitions and clustering cover analysis functions, depth, cluster keys and Automatic Clustering cost.
  • Cloning covers what is cloned, how privileges behave and development environments.
  • Validation and rollback cover testing on clones, swapping and restoring.
Exam tip

Memorize the numbers as a set. Time Travel is 0 to 90 days on Enterprise (1 day on Standard, 1 day for transient and temporary), Fail-safe is 7 days for permanent tables only, and an unconsumed stream extends retention up to 14 days by default.

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, SQL and comparison tables.
  • Common mistakes: the classic traps.
  • What to remember for the exam: the facts to memorize.
  • Check yourself: three questions to test your understanding.

Read the pages in order. The last page reuses clones, Time Travel and UNDROP from the earlier ones.

Ready for more practice?

The full Snowflake DEA-C02 question bank has 709 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.