Chapter 6: Continuous Data Protection Flashcards
Which of the following Snowflake editions provide Time Travel capability? (Choose all that apply.)
Enterprise
Standard
Business Critical
Virtual Private Snowflake
Enterprise
Standard
Business Critical
Virtual Private Snowflake
Which of the following is the minimum Snowflake edition that provides 90 days of Time Travel?
Enterprise
Standard
Business Critical
Virtual Private Snowflake
Enterprise
True or False: Time Travel requires extra storage, which results in additional costs.
True
False
True
What is the maximum amount of Time Travel duration possible when using Snowflake Standard edition?
7 days
90 days
One day
Zero days
One day
What is the maximum amount of Time Travel possible for a temporary table?
7 days
90 days
One day
Zero days
One day
Which of the following table types don’t provide any Fail-safe storage? (Choose all that apply.)
Permanent tables
Temporary tables
Transient tables
Aggregate tables
Temporary tables
Transient tables
Data that has entered Fail-safe storage can be accessed by which of the following?
Any user
Snowflake support
IT staff
Administrators
Snowflake support
What is the maximum amount of Time Travel possible for a transient table?
7 days
90 days
1 day
0 days
1 day
What is the maximum allowable duration for Time Travel for a permanent table in the Snowflake Enterprise edition?
7 days
90 days
0 days
One day
90 days
True or False: It is possible to disable Fail-safe for certain databases, schemas, or tables.
True
False
False
True or False: Fail-safe storage is a way for Snowflake customers to access historical data that may have been accidentally deleted.
False
True
False
Which of the following objects can be undropped? (Choose all that apply.)
Databases
Tables
Schemas
External stages
File formats
Databases
Tables
Schemas
