2025 Data Replication and Failovers Flashcards
What are the two key performance indicators that are considered for disaster recovery
Recovery Time Objective (RTO)
Recovery Point Objective (RPO)
What is Tri-Secret Secure
A composite key is a combination of Snowflake and consumer-managed keys
What is data replication used for
Duplicating/sharing data across regions/clouds
How do you modify an existing database to act as the primary database for replication?
ALTER DATABASE <DB-NAME> ENABLE REPLICATOIN TO ACCOUNTS <ACCOUNT1>, <ACCOUNT2></ACCOUNT2></ACCOUNT1></DB-NAME>
How do you create a secondary database for use in replication
CREATE DATABASE <dbname> AS REPLICA OF <dbname></dbname></dbname>
How do you refresh a secondary database
ALTER DATABASE <dbname> REFRESH; (either manual or a task)</dbname>
Are incremental refreshes supported?
Yes
What happens when trying to replicate a database with an external table
Replication is blocked
Can Stages and Pipes be replicated
No
Is Historical usage data on a primary database replicated
No
Can databases from shares be replicated
No
When replicating streams, the stream can successfully track the change in what objects
Tables and Views in the same database as the stream (and not shared)
This excludes Directory and External Tables
If you want to drop a primary database, what steps do you have to take
Promote the secondary database to a primary database.
Drop the former primary database
Are stored procedures and UDFS replicated from the primary to the secondary database
Yes
When does automatic clustering occur on a secondary database
When it is promoted to the primary database
Where does automatic maintenance of the materialized views occur
Primary database
What happens when the primary database is Enterprise or higher and the other account is lower
Replication fails
What happens if the primary database has a dangling reference to a tag in another DB
Replication fails
How is Time Travel and Fail Safe data maintained on a secondary database
Independently and not replicated
How are cloned objects treated during replication
They are physically replicated
How can you enable failover for a database
ALTER DATABASE ENABLE FAILOVER TO ACCOUNTS….
What edition is required for failover
Business Critical
What role is required to enable failover
ACCOUNTADMIN
Can zero copy clones be cloned into transient tables
Yes, you will save money by using transient tables because you do not need time travel on the cloned tables
