Snowflake COF-C02 Practice Exams
Last updated on Oct 23,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 23,2026
Question #121
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
- A . A defined level of access to an object
- B . An entity in which access can be granted
- C . Each object has an owner, who can in turn grail access to that object.
- D . Access privileges are assigned to roles. which are in turn assigned to use’s
Correct Answer: D
D
Explanation:
Snowflake implements Discretionary Access Control (DAC) by using a role-based access control model. In this model, access privileges are not directly assigned to individual objects or users but are encapsulated within roles. These roles are then assigned to users, effectively granting them the access privileges contained within the role. This approach allows for granular control over database access, making it easier to manage permissions in a scalable and flexible manner.
References: Snowflake Documentation on Access Control
D
Explanation:
Snowflake implements Discretionary Access Control (DAC) by using a role-based access control model. In this model, access privileges are not directly assigned to individual objects or users but are encapsulated within roles. These roles are then assigned to users, effectively granting them the access privileges contained within the role. This approach allows for granular control over database access, making it easier to manage permissions in a scalable and flexible manner.
References: Snowflake Documentation on Access Control
Question #122
How many resource monitors can be assigned at the account level?
- A . 1
- B . 2
- C . 3
- D . 4
Correct Answer: A
A
Explanation:
Snowflake allows for only one resource monitor to be assigned at the account level. This monitor oversees the credit usage of all the warehouses in the account.
References: Snowflake Documentation
A
Explanation:
Snowflake allows for only one resource monitor to be assigned at the account level. This monitor oversees the credit usage of all the warehouses in the account.
References: Snowflake Documentation
Question #123
In the Snowflake access control model, which entity owns an object by default?
- A . The user who created the object
- B . The SYSADMIN role
- C . Ownership depends on the type of object
- D . The role used to create the object
Correct Answer: D
D
Explanation:
In Snowflake’s access control model, the default owner of an object is the role that was used to create the object. This role has the OWNERSHIP privilege on the object and can grant access to other roles1
D
Explanation:
In Snowflake’s access control model, the default owner of an object is the role that was used to create the object. This role has the OWNERSHIP privilege on the object and can grant access to other roles1
Question #124
Which Snowflake table objects can be shared with other accounts? (Select TWO).
- A . Temporary tables
- B . Permanent tables
- C . Transient tables
- D . External tables
- E . User-Defined Table Functions (UDTFs)
Correct Answer: B, D
B, D
Explanation:
In Snowflake, permanent tables and external tables can be shared with other accounts using Secure Data Sharing. Temporary tables, transient tables, and UDTFs are not shareable objects
B, D
Explanation:
In Snowflake, permanent tables and external tables can be shared with other accounts using Secure Data Sharing. Temporary tables, transient tables, and UDTFs are not shareable objects
Question #125
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
- A . BINARY_FORMAT
- B . ESCAPE_UNENCLOSED_FIELD
- C . FIELD_OPTIONALLY_ENCLOSED_BY
- D . SKIP BYTE ORDER MARK
Correct Answer: C
C
Explanation:
When creating a CSV file format in Snowflake and the requirement is to wrap columns by single quotes or double quotes, the FIELD_OPTIONALLY_ENCLOSED_BY parameter should be used in the file format specification. This parameter allows you to define a character (either a single quote or a double quote) that can optionally enclose each field in the CSV file, providing flexibility in handling fields that contain special characters or delimiters as part of their data.
References: Snowflake Documentation: CSV File Format
C
Explanation:
When creating a CSV file format in Snowflake and the requirement is to wrap columns by single quotes or double quotes, the FIELD_OPTIONALLY_ENCLOSED_BY parameter should be used in the file format specification. This parameter allows you to define a character (either a single quote or a double quote) that can optionally enclose each field in the CSV file, providing flexibility in handling fields that contain special characters or delimiters as part of their data.
References: Snowflake Documentation: CSV File Format
Question #126
What is the purpose of multi-cluster virtual warehouses?
- A . To create separate data warehouses to increase query optimization
- B . To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
- C . To eliminate or reduce Queuing of concurrent queries
- D . To allow the warehouse to resize automatically
Correct Answer: C
C
Explanation:
Multi-cluster virtual warehouses in Snowflake are designed to manage user and query concurrency
needs. They allow for the allocation of additional clusters of compute resources, either statically or
dynamically, to handle increased loads and reduce or eliminate the queuing of concurrent queries2.
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20an d%20off%20hours.
C
Explanation:
Multi-cluster virtual warehouses in Snowflake are designed to manage user and query concurrency
needs. They allow for the allocation of additional clusters of compute resources, either statically or
dynamically, to handle increased loads and reduce or eliminate the queuing of concurrent queries2.
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20an d%20off%20hours.
Question #127
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
- A . ACCOUNTADMIN
- B . SECURITYADMIN
- C . SYSADMIN
- D . USERADMIN
Correct Answer: A
A
Explanation:
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should ideally be granted to the ACCOUNTADMIN role. This recommendation stems from the best practices for implementing a least privilege access control model, ensuring that only the necessary permissions are granted at each level of the role hierarchy. The ACCOUNTADMIN role has the highest level of privileges in Snowflake, including the ability to manage all aspects of the Snowflake account. By assigning the top-most custom role to ACCOUNTADMIN, you ensure that the administration of role hierarchies and the assignment of roles remain under the control of users with the highest level of oversight and responsibility within the Snowflake environment.
References: Snowflake Documentation on Access Control: Managing Access Control
A
Explanation:
Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should ideally be granted to the ACCOUNTADMIN role. This recommendation stems from the best practices for implementing a least privilege access control model, ensuring that only the necessary permissions are granted at each level of the role hierarchy. The ACCOUNTADMIN role has the highest level of privileges in Snowflake, including the ability to manage all aspects of the Snowflake account. By assigning the top-most custom role to ACCOUNTADMIN, you ensure that the administration of role hierarchies and the assignment of roles remain under the control of users with the highest level of oversight and responsibility within the Snowflake environment.
References: Snowflake Documentation on Access Control: Managing Access Control
Question #128
What causes objects in a data share to become unavailable to a consumer account?
- A . The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
- B . The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every
24 hours. - C . The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
- D . The consumer account acquires the data share through a private data exchange.
Correct Answer: C
C
Explanation:
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re-applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access.
The DATA_RETENTION_TIME_IN_DAYS parameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running the GRANT IMPORTED PRIVILEGES command in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer’s account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data (https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)
C
Explanation:
Objects in a data share become unavailable to a consumer account if the objects in the data share are deleted or if the permissions on these objects are altered without re-applying the grant permissions systematically. This is because the sharing mechanism in Snowflake relies on explicit grants of permissions on specific objects (like tables, views, or secure views) to the share. If these objects are deleted or if their permissions change without updating the share accordingly, consumers can lose access.
The DATA_RETENTION_TIME_IN_DAYS parameter does not directly affect the availability of shared objects, as it controls how long Snowflake retains historical data for time travel and does not impact data sharing permissions.
Running the GRANT IMPORTED PRIVILEGES command in the consumer account is not related to the availability of shared objects; this command is used to grant privileges on imported objects within the consumer’s account and is not a routine maintenance command that would need to be run regularly.
Acquiring a data share through a private data exchange does not inherently make objects unavailable; issues would only arise if there were problems with the share configuration or if the shared objects were deleted or had their permissions altered without re-granting access to the share.
Reference: Snowflake Documentation on Managing Access to Shared Data (https://docs.snowflake.com/en/user-guide/data-sharing-consuming.html#managing-access-to-shared-data)
Question #129
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
- A . DELETE
- B . DROP
- C . REMOVE
- D . TRUNCATE
Correct Answer: C
C
Explanation:
The REMOVE command is used in Snowflake to delete files from a stage after they have been successfully ingested into Snowflake tables. This command helps manage storage by allowing users to clean up staged files that are no longer needed, ensuring that the stage does not accumulate unnecessary data over time. Unlike DELETE, DROP, or TRUNCATE commands, which are used for managing data within Snowflake tables or dropping objects, REMOVE specifically targets the management of files in stages.
References: Snowflake Documentation on Stages and File Management
C
Explanation:
The REMOVE command is used in Snowflake to delete files from a stage after they have been successfully ingested into Snowflake tables. This command helps manage storage by allowing users to clean up staged files that are no longer needed, ensuring that the stage does not accumulate unnecessary data over time. Unlike DELETE, DROP, or TRUNCATE commands, which are used for managing data within Snowflake tables or dropping objects, REMOVE specifically targets the management of files in stages.
References: Snowflake Documentation on Stages and File Management
Question #130
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
- A . 60
- B . 91
- C . 120
- D . 121
Correct Answer: C
C
Explanation:
Snowflake bills virtual warehouse usage in one-minute increments, rounding up to the nearest minute for any partial minute of compute time used. If a virtual warehouse runs for 61 seconds and then, after being shut down, restarts and runs for an additional 30 seconds, the total time billed would be 120 seconds or 2 minutes. The first 61 seconds are rounded up to 2 minutes, and the subsequent 30 seconds are within a new minute, which is also rounded up to the nearest minute.
References:
Snowflake Documentation: Virtual Warehouses Billing
C
Explanation:
Snowflake bills virtual warehouse usage in one-minute increments, rounding up to the nearest minute for any partial minute of compute time used. If a virtual warehouse runs for 61 seconds and then, after being shut down, restarts and runs for an additional 30 seconds, the total time billed would be 120 seconds or 2 minutes. The first 61 seconds are rounded up to 2 minutes, and the subsequent 30 seconds are within a new minute, which is also rounded up to the nearest minute.
References:
Snowflake Documentation: Virtual Warehouses Billing