1) How does Snowflake handle semi-structured data like JSON and XML?

2) Which command is used to create a Snowflake stage for data loading?

3) Which of the following is a benefit of using Snowflake over traditional on-premises data warehouses?

4) In Snowflake, what is the function of the "ALTER PIPE" command?

5) Which of the following is an important feature of Snowflake’s multi-cluster warehouses?

6) What is a "Zero-Copy Clone" in Snowflake?

7) Which Snowflake command is used to set the parameters for a virtual warehouse?

8) What is the purpose of a "Task" in Snowflake?

9) Which Snowflake feature helps optimize query performance by managing how data is organized in micro-partitions?

10) How can you optimize costs when using Snowflake for ad-hoc querying?

11) Which of the following Snowflake commands allows you to retrieve historical versions of a table?

12) What is the "Fail-Safe" feature in Snowflake designed for?

13) Which of the following Snowflake storage options is used for data loading and unloading?

14) What is the maximum size of a single row in Snowflake?

15) How does Snowflake manage encryption?

16) Which type of Snowflake join returns all rows from both tables, matching records where available, and fills in NULLs where there are no matches?

17) Which feature in Snowflake can be used to ensure consistent data reads in high-availability applications?

18) Which Snowflake command is used to drop a database?

19) In Snowflake, which of the following is a key advantage of "Secure Views"?

20) How does Snowflake handle versioning when using Time Travel?