COF-C02 Free Practice Test

- (Topic 3)
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

1. A. Cloud services layer
2. B. Compute layer
3. C. Storage layer
4. D. Cloud agnostic layer

Correct Answer: A
Query parsing and compilation in Snowflake occur within the cloud services layer. This layer is responsible for various management tasks, including query compilation and optimization

- (Topic 4)
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

1. A. Data Replication
2. B. Secure Data Sharing
3. C. Data Exchange
4. D. Snowflake Marketplace

Correct Answer: C
Snowflake??s Data Exchange feature provides a data hub for secure data collaboration. It allows providers to publish data that can be discovered and accessed by a selected group of invited members, facilitating secure and controlled data sharing within a collaborative environment3. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 5)
Which SQL command can be used to verify the privileges that are granted to a role?

1. A. SHOW GRANTS ON ROLE <Role Name>
2. B. SHOW ROLES
3. C. SHOW GRANTS TO ROLE
4. D. SHOW GRANTS FOR ROLE

Correct Answer: C
To verify the privileges that have been granted to a specific role in Snowflake, the correct SQL command isSHOW GRANTS TO ROLE <Role Name>. This command lists all the privileges granted to the specified role, including access to schemas, tables, and other database objects. This is a useful command for administrators and users withsufficient privileges to audit and manage role permissions within the Snowflake environment.
References:
✑ Snowflake Documentation: SHOW GRANTS

- (Topic 3)
What is used to diagnose and troubleshoot network connections to Snowflake?

1. A. SnowCD
2. B. Snowpark
3. C. Snowsight
4. D. SnowSQL

Correct Answer: A
SnowCD (Snowflake Connectivity Diagnostic Tool) is used to diagnose and troubleshoot network connections to Snowflake. It runs a series of connection checks to evaluate the network connection to Snowflake

- (Topic 5)
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

1. A. If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.
2. B. If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.
3. C. If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.
4. D. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.
5. E. If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Correct Answer: AB
When initiating a session in Snowflake, the system determines the current role based on the user's connection details and role assignments. If a user specifies a role during the connection, and that role is already granted to them, Snowflake sets it as the current role for the session. Alternatively, if no role is specified during the connection, but the user has a default role assigned, Snowflake will use this default role as the current session role. These mechanisms ensure that users operate within their permissions, enhancing security and governance within Snowflake environments.
References:
✑ Snowflake Documentation: Understanding Roles