- (Topic 3)
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Correct Answer:
BD
Running EXPLAIN and SHOW commands, as well as running a custom query, consume virtual warehouse credits in the Snowflake environment. These activities require computational resources, and therefore, credits are used to account for the usage of these resources. References: [COF-C02] SnowPro Core Certification Exam Study Guide
- (Topic 6)
What are type predicates used for?
Correct Answer:
C
Type predicates in Snowflake are used to determine if a value in a VARIANT column is of a particular data type. This is useful when working with semi-structured data stored in VARIANT columns, as it allows for data type validation and conditional processing based on the data type.
References:
✑ Snowflake Documentation: Type Predicates
- (Topic 2)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Correct Answer:
B
The GET command is used to download files from a Snowflake stage to a local folder on a client??s machine2.
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
- (Topic 6)
Authorization to execute CREATE
Correct Answer:
A
In Snowflake, the authorization to executeCREATE <object>statements, such as creating tables, views, databases, etc., is determined by the role currently set as the user's primary role. The primary role of a user or session specifies the set of privileges(including creation privileges) that the user has. While users can have multiple roles, only the primary role is used to determine what objects the user can create unless explicitly specified in the session.
Reference: This is based on the principle of Role-Based Access Control (RBAC) in Snowflake, where roles are used to manage access permissions. The official Snowflake documentation on Understanding and Using Roles would be the best resource to verify this information: https://docs.snowflake.com/en/user-guide/security-access-control- overview.html#roles
- (Topic 1)
When is the result set cache no longer available? (Select TWO)
Correct Answer:
CE
The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data. Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.
