Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Time Travel and Data Recovery

The video tutorial covers the use of SQL in Snowflake, focusing on setting up schemas, modifying data retention times, creating and testing tables, utilizing the time travel feature to query past data, and recovering deleted objects using the undrop command. It provides practical examples and commands to demonstrate these features effectively.

What is the default data retention time for tables in Snowflake's Enterprise Edition?

• 90 days

• Unlimited

• 1 day

• 30 days

What is the maximum data retention time available in Snowflake's Enterprise Edition?

• Unlimited

• 9090 days

• 90 days

• 365 days

What happens when you set the data retention time at the database level in Snowflake?

• It changes the retention time for existing objects.

• It affects all future objects created in the database.

• It has no effect on any objects.

• It only affects the current tables.

What must be done to change the retention time for existing objects in a database?

• Recreate the database

• Nothing, it changes automatically

• Manually adjust each object

• Use a global setting

Which keyword is used to query a table snapshot before a specific timestamp in Snowflake?

• AFTER

• BEFORE

• DURING

• AT

How can you restore a deleted database in Snowflake if the retention time is set to zero?

• It cannot be restored

• Use the UNDROPPED command

• Use the UNDELETE command

• Use the RESTORE command

Which command is used to recover a deleted object in Snowflake?

• RECREATE

• UNDROPPED

• RECOVER

• RESTORE