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 #181
What does the TableScan operator represent in the Query Profile?
- A . The access to a single table
- B . The access to data stored in stage objects
- C . The list of values provided with the VALUES clause
- D . The records generated using the TABLE (GENERATOR (…)) construct
Correct Answer: A
A
Explanation:
In the Query Profile of Snowflake, the TableScan operator represents the access to a single table. This operator indicates that the query execution involved reading data from a table stored in Snowflake. TableScan is a fundamental operation in query execution plans, showing how the database engine retrieves data directly from tables as part of processing a query.
References: Snowflake Documentation: Understanding the Query Profile
A
Explanation:
In the Query Profile of Snowflake, the TableScan operator represents the access to a single table. This operator indicates that the query execution involved reading data from a table stored in Snowflake. TableScan is a fundamental operation in query execution plans, showing how the database engine retrieves data directly from tables as part of processing a query.
References: Snowflake Documentation: Understanding the Query Profile
Question #182
Which default warehouse configuration has the highest precedence whenever a new session is created by a user?
- A . Default warehouse tor the user
- B . Default warehouse in the configuration file of the client utilities
- C . Default warehouse specified on a CLI or in drivers/connectors parameters
- D . Default warehouse of the role assigned to the user
Correct Answer: D
Question #183
What factors impact storage costs in Snowflake? (Select TWO).
- A . The account type
- B . The storage file format
- C . The cloud region used by the account
- D . The type of data being stored
- E . The cloud platform being used
Correct Answer: A, C
A, C
Explanation:
The factors that impact storage costs in Snowflake include the account type (Capacity or On Demand) and the cloud region used by the account. These factors determine the rate at which storage is billed, with different regions potentially having different rates3.
A, C
Explanation:
The factors that impact storage costs in Snowflake include the account type (Capacity or On Demand) and the cloud region used by the account. These factors determine the rate at which storage is billed, with different regions potentially having different rates3.
Question #184
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- A . Customer-managed encryption keys through Tri-Secret Secure
- B . Automatic encryption of all data
- C . Up to 90 days of data recovery through Time Travel
- D . Object-level access control
- E . Column-level security to apply data masking policies to tables and views
Correct Answer: B, D
B, D
Explanation:
In all Snowflake editions, two key capabilities are universally available:
B. Automatic encryption of all data: Snowflake automatically encrypts all data stored in its platform, ensuring security and compliance with various regulations. This encryption is transparent to users and does not require any configuration or management.
D. Object-level access control: Snowflake provides granular access control mechanisms that allow administrators to define permissions at the object level, including databases, schemas, tables, and views. This ensures that only authorized users can access specific data objects.
These features are part of Snowflake’s commitment to security and governance, and they are included in every edition of the Snowflake Data Cloud.
References:
Snowflake Documentation on Security Features
SnowPro® Core Certification Exam Study Guide
B, D
Explanation:
In all Snowflake editions, two key capabilities are universally available:
B. Automatic encryption of all data: Snowflake automatically encrypts all data stored in its platform, ensuring security and compliance with various regulations. This encryption is transparent to users and does not require any configuration or management.
D. Object-level access control: Snowflake provides granular access control mechanisms that allow administrators to define permissions at the object level, including databases, schemas, tables, and views. This ensures that only authorized users can access specific data objects.
These features are part of Snowflake’s commitment to security and governance, and they are included in every edition of the Snowflake Data Cloud.
References:
Snowflake Documentation on Security Features
SnowPro® Core Certification Exam Study Guide
Question #185
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
- A . GET_STATE_LOCATION
- B . GET_PRESENT_URL
- C . BUILD_SCOPED_FILE_URL
- D . BUILD_STAGE_FILE_URL
Correct Answer: D
D
Explanation:
Purpose: The BUILD_STAGE_FILE_URL function generates a temporary, pre-signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
Key Points:
Security: The URL has a limited lifespan, enhancing security.
Use Cases: Sharing staged data with external tools or applications, or downloading it directly.
Snowflake Documentation (BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html
D
Explanation:
Purpose: The BUILD_STAGE_FILE_URL function generates a temporary, pre-signed URL that allows you to access a file within a Snowflake stage (internal or external). This URL requires authentication to use.
Key Points:
Security: The URL has a limited lifespan, enhancing security.
Use Cases: Sharing staged data with external tools or applications, or downloading it directly.
Snowflake Documentation (BUILD_STAGE_FILE_URL): https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url.html
Question #186
Which function will provide the proxy information needed to protect Snowsight?
- A . SYSTEMADMIN_TAG
- B . SYSTEM$GET_PRIVATELINK
- C . SYSTEMSALLONTLIST
- D . SYSTEMAUTHORIZE
Correct Answer: B
B
Explanation:
The SYSTEM$GET_PRIVATELINK function in Snowflake provides proxy information necessary for configuring PrivateLink connections, which can protect Snowsight as well as other Snowflake services. PrivateLink enhances security by allowing Snowflake to be accessed via a private connection within a cloud provider’s network, reducing exposure to the public internet.
References: Snowflake Documentation: PrivateLink Setup
B
Explanation:
The SYSTEM$GET_PRIVATELINK function in Snowflake provides proxy information necessary for configuring PrivateLink connections, which can protect Snowsight as well as other Snowflake services. PrivateLink enhances security by allowing Snowflake to be accessed via a private connection within a cloud provider’s network, reducing exposure to the public internet.
References: Snowflake Documentation: PrivateLink Setup
Question #187
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
- A . Row access policies
- B . Data masking policies
- C . Data encryption
- D . Role based access control
Correct Answer: B
B
Explanation:
Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others. This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.
B
Explanation:
Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others. This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.
Question #188
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
- A . USERADMIN
- B . PUBLIC
- C . ORGADMIN
- D . SYSADMIN
Correct Answer: A
A
Explanation:
The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege. This role is responsible for creating and managing users and roles within the Snowflake account.
References: Access control considerations | Snowflake Documentation
A
Explanation:
The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege. This role is responsible for creating and managing users and roles within the Snowflake account.
References: Access control considerations | Snowflake Documentation
Question #189
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
- A . Execute a COPY command
- B . Updating data
- C . Snowpipe
- D . AUTOMATIC__CLUSTERING
- E . Scaling up a warehouse
Correct Answer: C, E
C, E
Explanation:
Snowflake manages various compute resources and features, including Snowpipe and the ability to scale up a warehouse. Snowpipe is Snowflake’s continuous data ingestion service that allows users to load data as soon as it becomes available. Scaling up a warehouse refers to increasing the compute resources allocated to a virtual warehouse to handle larger workloads or improve performance.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowpipe and Virtual Warehouses1
C, E
Explanation:
Snowflake manages various compute resources and features, including Snowpipe and the ability to scale up a warehouse. Snowpipe is Snowflake’s continuous data ingestion service that allows users to load data as soon as it becomes available. Scaling up a warehouse refers to increasing the compute resources allocated to a virtual warehouse to handle larger workloads or improve performance.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Snowpipe and Virtual Warehouses1
Question #190
How do secure views compare to non-secure views in Snowflake?
- A . Secure views execute slowly compared to non-secure views.
- B . Non-secure views are preferred over secure views when sharing data.
- C . Secure views are similar to materialized views in that they are the most performant.
- D . There are no performance differences between secure and non-secure views.
Correct Answer: D
D
Explanation:
Secure views and non-secure views in Snowflake are differentiated primarily by their handling of data access and security rather than performance characteristics. A secure view enforces row-level security and ensures that the view definition is hidden from the users. However, in terms of performance, secure views do not inherently execute slower or faster than non-secure views. The performance of both types of views depends more on other factors such as underlying table design, query complexity, and system workload rather than the security features embedded in the views themselves.
References:
Snowflake Documentation on Views: This section provides an overview of both secure and non-secure views, clarifying that the main difference lies in security features rather than performance, thus supporting the assertion that there are no inherent performance differences.
D
Explanation:
Secure views and non-secure views in Snowflake are differentiated primarily by their handling of data access and security rather than performance characteristics. A secure view enforces row-level security and ensures that the view definition is hidden from the users. However, in terms of performance, secure views do not inherently execute slower or faster than non-secure views. The performance of both types of views depends more on other factors such as underlying table design, query complexity, and system workload rather than the security features embedded in the views themselves.
References:
Snowflake Documentation on Views: This section provides an overview of both secure and non-secure views, clarifying that the main difference lies in security features rather than performance, thus supporting the assertion that there are no inherent performance differences.