NiC IT Academy

SNOWFLAKE QUIZ – 05

By Mr.Chandra

Loading

01. Which is the default table type in Snowflake?

02. Which table type exists only during a user session?

03. Which table type supports Fail-safe?

04. What is the Fail-safe period for a Permanent Table?

05. Which table type can be created at Database, Schema, and Table levels? [Select 2]

06. What is the maximum Time Travel retention for a Permanent Table?

07. Which statement is TRUE regarding Temporary Tables?

08. Can we create a temporary database?

09. A company wants to store staging data for 1 day but does not need Fail-safe. Which table type is best?

10. Your production customer table contains financial records and must be recoverable even after Time Travel expires. Which table type should be used?

11. What is the main difference between Permanent and Transient Tables?

12. Can a Temporary Table be accessed by another user session?

13. A company wants to minimize storage costs while retaining data for short-term ETL processing. Which object type should be recommended?

14. Is it possible to create a Permanent Table with DATA_RETENTION_TIME_IN_DAYS = 91?

15. A developer creates a Snowflake table and inserts data into it. Later, some rows are updated and eventually the table is accidentally truncated. The developer attempts to recover the data using Time Travel, but Snowflake does not allow the recovery. What is the most likely reason?

Login with your email & password

Sign up with your email & password

Signup/Registration Form