NiC IT Academy

SNOWFLAKE QUIZ – 09

By Mr.Chandra

Loading

1) What does the "RECLUSTER" operation in Snowflake do?

2) What is the purpose of the "ALTER SESSION" command in Snowflake?

3) Which of the following Snowflake features is responsible for monitoring and automating data loading operations?

4) What happens when a virtual warehouse in Snowflake is suspended?

5) What is the default query result cache duration in Snowflake?

6) Which of the following can be used to identify the most resource-intensive queries in Snowflake?

7) How can you prevent a virtual warehouse from being auto-suspended in Snowflake?

8) In Snowflake, what does the "ALTER TABLE" command allow you to do?

9) Which of the following allows you to secure the data being transferred between Snowflake and external applications?

10) Which command is used to unload data from a Snowflake table into a stage?

11) What is the benefit of using clustering keys in Snowflake?

12) What is a key feature of Snowflake's "Fail-safe" mechanism?

13) Which of the following Snowflake functions allows users to create dynamic SQL statements?

14) What is the maximum retention period for historical data in Snowflake when using both Time Travel and Fail-safe combined?

15) Which Snowflake feature automatically scales up compute resources during periods of high concurrency?

16) How does Snowflake optimize storage costs?

17) Which of the following is true about Snowflake's handling of semi-structured data?

18) Which Snowflake command can be used to set the timezone for a session?

19) What is the primary use of "Stages" in Snowflake?

20) Which of the following commands would you use to clone a table in Snowflake with zero additional storage cost?

Login with your email & password

Sign up with your email & password

Signup/Registration Form