1) Which Snowflake feature provides a continuous, near real-time loading of data into Snowflake?

2) In Snowflake, what is a virtual warehouse primarily used for?

3) Which of the following is NOT an available warehouse size in Snowflake?

4) What is the purpose of Snowflake's "Materialized Views"?

5) Which role in Snowflake has the highest level of access to the account?

6) Which of the following commands can be used to resume a suspended virtual warehouse?

7) Which of the following describes the behavior of a "Task" in Snowflake?

8) What is Snowflake's "Search Optimization Service" used for?

9) How does Snowflake handle failover in multi-region deployments?

10) What is the retention period for "Time Travel" in Snowflake at maximum?

11) Which Snowflake feature ensures that your data remains available in case of accidental deletion or corruption, even after the Time Travel period expires?

12) Which of the following is a key use case for Snowflake’s "Secure Data Sharing" feature?

13) Which Snowflake command would you use to switch the context to a specific database?

14) How does Snowflake handle concurrency for multiple users running queries simultaneously?

15) Which command is used to grant privileges to a role in Snowflake?

16) Which Snowflake object allows you to define complex SQL logic such as loops, conditionals, and exception handling?

17) In Snowflake, how are storage costs calculated?

18) What type of Snowflake role can be assigned to a group of users to manage access to shared objects?

19) Which Snowflake command would you use to load data from a file into a table?

20) Which Snowflake function helps reduce the query cost by reusing the results of previously executed queries?