Snowflake Architect Disaster Recovery and High Availability Flashcards
5 cards from real Snowflake Architect Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 5 Snowflake Architect Disaster Recovery and High Availability flashcards as text
What feature does Snowflake provide for high availability and fault tolerance?
Answer: Cross-Region Replication
For high availability and fault tolerance, Snowflake offers Cross-Region Replication. This feature allows organizations to replicate their data and objects from a primary region to one or more secondary regions. In the event of a regional outage or disaster, this ensures that data remains accessible and operations can quickly resume from a different geographical location, minimizing downtime and data loss.
Which of the following helps ensure that Snowflake can recover data even after a significant outage?
Answer: Fail-Safe
Fail-Safe is a critical Snowflake feature that ensures data recoverability even after significant outages. It provides an extended data retention period (typically 7 days) beyond the standard Time Travel period. This allows Snowflake to recover historical data in the unlikely event of a catastrophic system failure, serving as a robust last line of defense for disaster recovery.
How does Snowflake support disaster recovery for geographically dispersed organizations?
Answer: By offering Multi-Cloud Deployment and Cross-Cloud Replication
Snowflake supports disaster recovery for geographically dispersed organizations through Multi-Cloud Deployment and Cross-Cloud Replication. Multi-cloud deployment allows an organization to run Snowflake across different cloud providers, while cross-cloud replication enables data to be replicated between these distinct cloud environments. This strategy provides maximum resilience, ensuring business continuity even if an entire cloud provider or region experiences a major outage.
What is the primary advantage of Snowflake's Multi-Cluster Warehouses during a disaster?
Answer: They distribute workloads to maintain performance under heavy demand.
Snowflake's Multi-Cluster Warehouses are designed to automatically scale compute resources to handle varying workloads and ensure consistent performance. During periods of heavy demand or even partial cluster failures (a type of disaster), they distribute queries across multiple independent compute clusters. This prevents performance degradation and ensures that critical operations can continue uninterrupted, maintaining high availability and responsiveness.
Which Snowflake feature enables users to access a historical snapshot of their data?
Answer: Time Travel
Time Travel is a powerful Snowflake feature that allows users to access and query historical versions of their data. It enables users to view data as it existed at any point within a defined retention period, recover accidentally dropped objects, or analyze changes over time. This capability is invaluable for data recovery, auditing, and understanding data evolution without needing to create explicit backups.