Level 8 - : Backup and Recovery

Question 1

Which features automatically protect your Snowflake data WITHOUT user or system administrator intervention?

Answer 1

Availability zones (AWS, Azure, Google)
Triple redundancy for critical services

Question 2

Which activity requires intervention by Snowflake Support to restore data?

Answer 2

Fail-safe

Question 3

Which statements are true for Snowflake’s zero-copy cloning feature?

Answer 3

Data is stored once – only changed micro-partitions are stored and owned exclusively by the clone.
You can instantly promote a cloned and updated table, database, or schema to production.

Question 4

Which statements are true for Snowflake’s fail-over capabilities?

Answer 4

Must have Snowflake Business Critical Edition or higher
Must have an account in the region where you wish to share replicated data