Replication Failover/Failback Flashcards

1
Q

What does a replication group allow a customer to do?

A

To specify what to replicate, where to replicate to, and how often. This means specifying which account objects replicate, to which regions or cloud platforms, at customizable scheduled intervals.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does a failover group allow a customer to do

A

the replication AND the failover of objects in a group. the objects in a group are replicated with point in time consistency, from a source account to one or more target accounts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What objects can be replicated

A

Databases
Integrations (Security, API)
Network Policies
Parameters (account level)
Resource Monitors
Roles
Shares
Users
Warehouses

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

T/F You can choose to failover all failover groups, or only select failover groups.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what does database replication do

A

enables the storing of read-only replicas of an individual primary database in other Snowflake Accounts in different regions or cloud platforms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is client redirect

A

a connection URL that can be used by Snowflake clients to connect to Snowflake. The connection can redirect clients to a different Snowflake account as needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

With async replicataion secondary replicas will typically lag behind the primary objects by how long

A

The amount of time you configured the replication schedule to be.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

T/F you have to recover reads and writes at the same time

A

False, you can choose to recover both, or one at a time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

When an outage is resolved, what steps are needed to restore normal function

A

Replication: Refresh the failover group(s) in the Snowflake account in the region where the outage occurred.

Failback: Promote the failover group(s) in the Snowflake account where the outage occurred to again serve as the primary failover group(s).

Client Redirect: Point the connection URL used by clients to the Snowflake account in the region where the outage occurred.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the steps to restore Read before Write

A

Client Redirect: Point the connection URL to a snowflake account that stores your read only replica failover group
Failover (When needed): in the event of a long term outage, promote the secondary failover group in the Snowflake account where your connection URL is pointint to serve as read-write primary failover group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the steps to restore Write before Read

A

Failover: Provide the secondary failover group with critical account objects in a different region to serve as the primary failover group(s), which allows writing to the account objects included in each failover group(s). Once the databases in the group(s) are writable, you can use your ETL processes to prioritze writes and reconcile data

Client Redirect (When Needed): Point the connection URL used by clients to the Snowflake account that stores the new primary failover group(s).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

T/F A replication group is Read Only

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are Five examples of things that cannot be replicated from one region to another

A
  1. Pipes
  2. Streams
  3. Tasks
  4. Stages
  5. External Tables
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which objects are available to replicate on all editions

A

Database and Share. Everything else takes a Business Critical Edition or higher

How well did you know this?
1
Not at all
2
3
4
5
Perfectly