Snowflake COF-C02 Practice Exams
Last updated on Oct 24,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 24,2026
Question #251
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
- A . parse_json()
- B . json_extract_path_text()
- C . object_construct()
- D . flatten
Correct Answer: A
A
Explanation:
The parse_json() function in Snowflake interprets an input string as a JSON document and produces a VARIANT value containing the JSON document. This function is specifically designed for parsing strings that contain valid JSON information3.
A
Explanation:
The parse_json() function in Snowflake interprets an input string as a JSON document and produces a VARIANT value containing the JSON document. This function is specifically designed for parsing strings that contain valid JSON information3.
Question #252
Which object type is granted permissions for reading a table?
- A . User
- B . Role
- C . Attribute
- D . Schema
Correct Answer: B
B
Explanation:
In Snowflake, permissions for accessing database objects, including tables, are not granted directly to users but rather to roles. A role encapsulates a collection of privileges on various Snowflake objects. Users are then granted roles, and through those roles, they inherit the permissions necessary to read a table or perform other actions. This approach adheres to the principle of least privilege, allowing for granular control over database access and simplifying the management of user permissions.
Reference: Snowflake’s official documentation on access control introduces the concept of roles and
how they are used to manage permissions: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#roles
B
Explanation:
In Snowflake, permissions for accessing database objects, including tables, are not granted directly to users but rather to roles. A role encapsulates a collection of privileges on various Snowflake objects. Users are then granted roles, and through those roles, they inherit the permissions necessary to read a table or perform other actions. This approach adheres to the principle of least privilege, allowing for granular control over database access and simplifying the management of user permissions.
Reference: Snowflake’s official documentation on access control introduces the concept of roles and
how they are used to manage permissions: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html#roles
Question #253
How does the Snowflake search optimization service improve query performance?
- A . It improves the performance of range searches.
- B . It defines different clustering keys on the same source table.
- C . It improves the performance of all queries running against a given table.
- D . It improves the performance of equality searches.
Correct Answer: D
D
Explanation:
The Snowflake Search Optimization Service is designed to enhance the performance of specific types of queries on large tables.
The correct answer is:
D. It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table’s columns, which significantly speeds up the retrieval of rows based on those equality search conditions.
This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.
References:
Snowflake Documentation: Search Optimization Service at Snowflake Documentation
D
Explanation:
The Snowflake Search Optimization Service is designed to enhance the performance of specific types of queries on large tables.
The correct answer is:
D. It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table’s columns, which significantly speeds up the retrieval of rows based on those equality search conditions.
This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table.
References:
Snowflake Documentation: Search Optimization Service at Snowflake Documentation
Question #254
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A . Schemas
- B . Roles
- C . Secure Views
- D . Stored Procedures
- E . Tables
- F . Secure User-Defined Functions (UDFs)
Correct Answer: A, C, F
A, C, F
Explanation:
In Snowflake, you can share several types of objects with other Snowflake accounts. These include schemas, secure views, and secure user-defined functions (UDFs). Sharing these objects allows for collaboration and data access across different Snowflake accounts while maintaining security and governance controls4.
A, C, F
Explanation:
In Snowflake, you can share several types of objects with other Snowflake accounts. These include schemas, secure views, and secure user-defined functions (UDFs). Sharing these objects allows for collaboration and data access across different Snowflake accounts while maintaining security and governance controls4.
Question #255
Which SQL statement will require a virtual warehouse to run?
- A . SELECT COUNT{*) FROM TBL_EMPLOYEE;
- B . ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
- C . INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,’Adam*,20000,* Finance’);
- D . CREATE OR REPLACE TABLE TBL_EMPLOYEE (
EMP_ID NUMBER,
EMP_NAME VARCHAR(30),
EMP_SALARY NUMBER, DEPT VARCHAR{20)
);
Correct Answer: C
C
Explanation:
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,’Adam’,20000,’Finance’); This SQL statement performs a data modification operation (DML) by inserting a new record into the TBL_EMPLOYEE table, which requires computational resources provided by a virtual warehouse to execute.
References:
Snowflake Documentation: Understanding Virtual Warehouses
C
Explanation:
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,’Adam’,20000,’Finance’); This SQL statement performs a data modification operation (DML) by inserting a new record into the TBL_EMPLOYEE table, which requires computational resources provided by a virtual warehouse to execute.
References:
Snowflake Documentation: Understanding Virtual Warehouses
Question #256
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
- A . Pre-signed URL
- B . Scoped URL
- C . Signed URL
- D . File URL
Correct Answer: A
A
Explanation:
Pre-signed URLs in Snowflake allow users to access unstructured data without the need for authentication into Snowflake or passing an authorization token. These URLs are open and can be directly accessed or downloaded by any user or application, making them ideal for business intelligence applications or reporting tools that need to display unstructured file contents
A
Explanation:
Pre-signed URLs in Snowflake allow users to access unstructured data without the need for authentication into Snowflake or passing an authorization token. These URLs are open and can be directly accessed or downloaded by any user or application, making them ideal for business intelligence applications or reporting tools that need to display unstructured file contents
Question #257
Which Snowflake architectural layer is responsible for a query execution plan?
- A . Compute
- B . Data storage
- C . Cloud services
- D . Cloud provider
Correct Answer: C
C
Explanation:
In Snowflake’s architecture, the Cloud Services layer is responsible for generating the query execution plan. This layer handles all the coordination, optimization, and management tasks, including query parsing, optimization, and compilation into an execution plan that can be processed by the Compute layer.
C
Explanation:
In Snowflake’s architecture, the Cloud Services layer is responsible for generating the query execution plan. This layer handles all the coordination, optimization, and management tasks, including query parsing, optimization, and compilation into an execution plan that can be processed by the Compute layer.
Question #258
Which Snowflake technique can be used to improve the performance of a query?
- A . Clustering
- B . Indexing
- C . Fragmenting
- D . Using INDEX__HINTS
Correct Answer: A
A
Explanation:
Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on the values of one or more columns. This organization allows Snowflake to efficiently prune non-relevant micro-partitions during a query, which reduces the amount of data scanned and improves query performance.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Clustering
A
Explanation:
Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on the values of one or more columns. This organization allows Snowflake to efficiently prune non-relevant micro-partitions during a query, which reduces the amount of data scanned and improves query performance.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Clustering
Question #259
What action can a user take to address query concurrency issues?
- A . Enable the query acceleration service.
- B . Enable the search optimization service.
- C . Add additional clusters to the virtual warehouse
- D . Resize the virtual warehouse to a larger instance size.
Correct Answer: C
C
Explanation:
To address query concurrency issues, a user can add additional clusters to the virtual warehouse. This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.
C
Explanation:
To address query concurrency issues, a user can add additional clusters to the virtual warehouse. This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.
Question #260
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A . An FTP server with TLS encryption
- B . An HTTPS server with WebDAV
- C . A Google Cloud storage bucket
- D . A Windows server file share on Azure
Correct Answer: D
D
Explanation:
In Snowflake, when the account is located on Microsoft Azure, a valid source for an external stage can be an Azure container or a folder path within an Azure container. This includes Azure Blob storage which is accessible via the azure:// endpoint. A Windows server file share on Azure, if configured properly, can be a valid source for staging data files for Snowflake. Options A, B, and C are not supported as direct sources for an external stage in Snowflake on Azure12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
D
Explanation:
In Snowflake, when the account is located on Microsoft Azure, a valid source for an external stage can be an Azure container or a folder path within an Azure container. This includes Azure Blob storage which is accessible via the azure:// endpoint. A Windows server file share on Azure, if configured properly, can be a valid source for staging data files for Snowflake. Options A, B, and C are not supported as direct sources for an external stage in Snowflake on Azure12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide