Chapter 6 of 6 · Snowflake ADA-C02
Disaster Recovery, Backup and Data Replication
Replication, groups, failover, backups, Time Travel and Fail-safe.
- 9topics
- 47 minfast track
- 3diagrams and exhibits
- 9%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Replication Basics - Primary, Secondary, Objects and Access ControlManage data replication: primary and secondary databases, what database and account objects replicate, and the effect on roles…5 min
- 2Account Replication, Schedules, Replication Groups and Failover GroupsPerform account replication with replication and failover groups, schedule refreshes with REPLICATION_SCHEDULE and pick the right…Diagram5 min
- 3Replication and Editions, Lower Edition Targets and Key ConsiderationsKnow what account replication needs per Snowflake edition, how IGNORE EDITION CHECK works for lower edition targets and the key…5 min
- 4Replication Impact on Clustering, Materialized Views, External Tables and PoliciesHow account replication affects dependent objects: automatic clustering, materialized views, external tables, masking and row…5 min
- 5Replication Impact on Streams, Tasks, Stages, Pipes, History and IcebergHow account replication affects streams, tasks, stages, pipes, cloned objects, usage history and Iceberg tables, and what to…5 min
- 6Database Failover, Failback on Schemas and Client RedirectAnalyze failover and failback across accounts, what happens to schemas, and how Client Redirect connections keep applications…Diagram6 min
- 7Disaster Recovery Plans, Failover Procedures and BackupsDesign a Snowflake disaster recovery plan, pick the failover or failback procedure, and apply backup best practices with backup…6 min
- 8Time Travel, Fail-safe, Retention Periods and Historical QueriesManage Time Travel and Fail-safe, set data retention periods at each level, and query historical data with AT and BEFORE…Diagram5 min
- 9Restore Dropped Objects, Disable Time Travel and Edition ImplicationsRestore dropped tables, schemas and databases with UNDROP, enable or disable Time Travel at each level, and see how editions…5 min
About this chapter
What this chapter covers
This chapter is about keeping data and service available, and getting data back after a mistake or an outage. For the SnowPro Advanced: Administrator ADA-C02 exam it tests what an administrator must set up and decide: which replication object, which edition, which command, and what still needs doing in the target account after a refresh or failover.
Questions are scenarios that start with "An administrator needs to ...". They are single answer, multiple select or interactive, and the answer usually depends on one detail such as an edition rule, a group type or an object that does not replicate.
How the topics fit together
Two different problems need two different tools. Losing a region is a replication problem. Undoing a bad change is a Time Travel problem.
- Replication makes read only copies of databases and, on Business Critical or higher, account objects in other accounts, regions or clouds.
- Groups replicate a set of objects together; a failover group can also be promoted to read write.
- Editions decide what is possible, and replicating Business Critical data to a lower edition needs an explicit override.
- Dependent objects such as clustered tables, materialized views, policies, streams, tasks, stages, pipes and Iceberg tables each behave in their own way in the target.
- Failover and failback move work to the secondary and back, with Client Redirect keeping connections stable.
- Backups, Time Travel and Fail-safe cover recovery inside one account.
Replication copies mistakes as well. A corrupted table is repaired with Time Travel or a backup, not with failover.
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 first time. The later pages build on the group types from page 2.
Ready for more practice?
The full Snowflake ADA-C02 question bank has 814 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.