NiC IT Academy

SNOWFLAKE QUIZ – 06

By Mr.Chandra

Loading

1) In Snowflake, what is the purpose of the "Query Acceleration Service"?

2) Which of the following services is used for real-time data ingestion in Snowflake?

3) Which Snowflake command is used to change the structure of an existing table?

4) Which of the following are common use cases for Snowflake?

5) What does the term "auto-suspend" mean in the context of a Snowflake virtual warehouse?

6) What is the main function of the Snowflake ROLE hierarchy?

7) What is the maximum number of columns allowed in a Snowflake table?

8) Which of the following is a Snowflake feature designed to replicate data across regions or cloud platforms?

9) Which Snowflake function allows querying data stored in external cloud storage, like S3, without loading it into Snowflake?

10) What is the role of the Snowflake "Information Schema"?

11) What type of scaling is available for Snowflake virtual warehouses?

12) How does Snowflake’s "Multi-Cluster Warehouse" feature enhance performance?

13) What is the main advantage of Snowflake’s "Instantaneous Cloning"?

14) Which of the following statements about Snowflake pricing is true?

15) What is the purpose of "Result Cache" in Snowflake?

16) Which of the following is a valid Snowflake role type?

17) What is the retention period of a materialized view in Snowflake?

18) What does Snowflake's "Time Travel" feature allow you to do?

19) Which of the following statements is true about Snowflake's shared data model?

20) What is the purpose of the "ACCOUNTADMIN" role in Snowflake?

Login with your email & password

Sign up with your email & password

Signup/Registration Form