Snowflake COF-C02 Practice Exams
Last updated on Oct 22,2026- Exam Code: COF-C02
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Oct 22,2026
Question #41
What is the maximum Time Travel retention period for a temporary Snowflake table?
- A . 90 days
- B . 1 day
- C . 7 days
- D . 45 days
Correct Answer: B
B
Explanation:
The maximum Time Travel retention period for a temporary Snowflake table is 1 day. This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window
B
Explanation:
The maximum Time Travel retention period for a temporary Snowflake table is 1 day. This is the standard retention period for temporary tables, which allows for accessing historical data within a 24-hour window
Question #42
When should a stored procedure be created with caller’s rights?
- A . When the caller needs to be prevented from viewing the source code of the stored procedure
- B . When the caller needs to run a statement that could not execute outside of the stored procedure
- C . When the stored procedure needs to run with the privileges of the role that called the stored procedure
- D . When the stored procedure needs to operate on objects that the caller does not have privileges on
Correct Answer: C
C
Explanation:
Stored procedures in Snowflake can be created with either ‘owner’s rights’ or ‘caller’s rights’. A stored procedure created with caller’s rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller’s access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.
Reference: Snowflake’s official documentation on stored procedures, specifically the section on execution context (caller’s rights vs. owner’s rights), provides detailed guidance on when to use caller’s rights: https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#caller-s-rights-vs-owner-s-rights
C
Explanation:
Stored procedures in Snowflake can be created with either ‘owner’s rights’ or ‘caller’s rights’. A stored procedure created with caller’s rights executes with the privileges of the role that calls the procedure, not the privileges of the role that owns the procedure. This is particularly useful in scenarios where the procedure needs to perform operations that depend on the caller’s access permissions, ensuring that the procedure can only access objects that the caller is authorized to access.
Reference: Snowflake’s official documentation on stored procedures, specifically the section on execution context (caller’s rights vs. owner’s rights), provides detailed guidance on when to use caller’s rights: https://docs.snowflake.com/en/sql-reference/stored-procedures-usage.html#caller-s-rights-vs-owner-s-rights
Question #43
The Snowflake Cloud Data Platform is described as having which of the following architectures?
- A . Shared-disk
- B . Shared-nothing
- C . Multi-cluster shared data
- D . Serverless query engine
Correct Answer: C
C
Explanation:
Snowflake’s architecture is described as a multi-cluster, shared data architecture. This design combines the simplicity of a shared-disk architecture with the performance and scale-out benefits of a shared-nothing architecture, using a central repository accessible from all compute nodes2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
C
Explanation:
Snowflake’s architecture is described as a multi-cluster, shared data architecture. This design combines the simplicity of a shared-disk architecture with the performance and scale-out benefits of a shared-nothing architecture, using a central repository accessible from all compute nodes2.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
Question #44
What is the Fail-safe retention period for transient and temporary tables?
- A . 0 days
- B . 1 day
- C . 7 days
- D . 90 days
Correct Answer: A
A
Explanation:
The Fail-safe retention period for transient and temporary tables in Snowflake is 0 days. Fail-safe is a feature designed to protect data against accidental loss or deletion by retaining historical data for a period after its Time Travel retention period expires. However, transient and temporary tables, which are designed for temporary or short-term storage and operations, do not have a Fail-safe period. Once the data is deleted or the table is dropped, it cannot be recovered.
References: Snowflake Documentation: Understanding Fail-safe
A
Explanation:
The Fail-safe retention period for transient and temporary tables in Snowflake is 0 days. Fail-safe is a feature designed to protect data against accidental loss or deletion by retaining historical data for a period after its Time Travel retention period expires. However, transient and temporary tables, which are designed for temporary or short-term storage and operations, do not have a Fail-safe period. Once the data is deleted or the table is dropped, it cannot be recovered.
References: Snowflake Documentation: Understanding Fail-safe
Question #45
Which function returns the URL of a stage using the stage name as the input?
- A . BUILD_STAGE_FILE_URL
- B . BUILD_SCOPED_FILE_URL
- C . GET_PRESIGNED_URL
- D . GET STAGE LOCATION
Correct Answer: C
C
Explanation:
The function in Snowflake that returns the URL of a stage using the stage name as the input is C. GET_PRESIGNED_URL. This function generates a pre-signed URL for a specific file in a stage, enabling secure, temporary access to that file without requiring Snowflake credentials. While the function is primarily used for accessing files in external stages, such as Amazon S3 buckets, it is instrumental in scenarios requiring direct, secure file access for a limited time.
It’s important to note that as of my last update, Snowflake’s documentation does not specifically list a function named GET_PRESIGNED_URL for directly obtaining a stage’s URL by its name. The description aligns closely with functionality available in cloud storage services (e.g., AWS S3’s presigned URLs) which can be used in conjunction with Snowflake stages for secure, temporary access to files. For direct interaction with stages and their files, Snowflake offers various functions and commands, but the exact match for generating a presigned URL through a simple function call may vary or require leveraging external cloud services APIs in addition to Snowflake’s capabilities.
References: Snowflake Documentation and cloud services (AWS, Azure, GCP) documentation on presigned URLs and stage interactions.
C
Explanation:
The function in Snowflake that returns the URL of a stage using the stage name as the input is C. GET_PRESIGNED_URL. This function generates a pre-signed URL for a specific file in a stage, enabling secure, temporary access to that file without requiring Snowflake credentials. While the function is primarily used for accessing files in external stages, such as Amazon S3 buckets, it is instrumental in scenarios requiring direct, secure file access for a limited time.
It’s important to note that as of my last update, Snowflake’s documentation does not specifically list a function named GET_PRESIGNED_URL for directly obtaining a stage’s URL by its name. The description aligns closely with functionality available in cloud storage services (e.g., AWS S3’s presigned URLs) which can be used in conjunction with Snowflake stages for secure, temporary access to files. For direct interaction with stages and their files, Snowflake offers various functions and commands, but the exact match for generating a presigned URL through a simple function call may vary or require leveraging external cloud services APIs in addition to Snowflake’s capabilities.
References: Snowflake Documentation and cloud services (AWS, Azure, GCP) documentation on presigned URLs and stage interactions.
Question #46
Which common query problems are identified by the Query Profile? (Select TWO.)
- A . Syntax error
- B . Inefficient pruning
- C . Ambiguous column names
- D . Queries too large to fit in memory
- E . Object does not exist or not authorized
Correct Answer: B, D
B, D
Explanation:
The Query Profile in Snowflake can identify common query problems, including:
B. Inefficient pruning: This refers to the inability of a query to effectively limit the amount of data being scanned, potentially leading to suboptimal performance.
D. Queries too large to fit in memory: This indicates that a query requires more memory than is available in the virtual warehouse, which can lead to spilling to disk and degraded performance.
The Query Profile helps diagnose these issues by providing detailed execution statistics and visualizations, aiding in query optimization and troubleshooting.
References:
Snowflake Documentation: Query Profile
Top of Form
B, D
Explanation:
The Query Profile in Snowflake can identify common query problems, including:
B. Inefficient pruning: This refers to the inability of a query to effectively limit the amount of data being scanned, potentially leading to suboptimal performance.
D. Queries too large to fit in memory: This indicates that a query requires more memory than is available in the virtual warehouse, which can lead to spilling to disk and degraded performance.
The Query Profile helps diagnose these issues by providing detailed execution statistics and visualizations, aiding in query optimization and troubleshooting.
References:
Snowflake Documentation: Query Profile
Top of Form
Question #47
A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?
- A . The primary cluster in the virtual warehouse
- B . The entire virtual warehouse
- C . The database in which the virtual warehouse resides
- D . The Queries currently being run on the virtual warehouse
Correct Answer: B
B
Explanation:
The auto-suspend and auto-resume settings in Snowflake apply to the entire virtual warehouse. These settings allow the warehouse to automatically suspend when it’s not in use, helping to save on compute costs. When queries or tasks are submitted to the warehouse, it can automatically resume operation. This functionality is designed to optimize resource usage and cost-efficiency.
References:
SnowPro Core Certification Exam Study Guide (as of 2021)
Snowflake documentation on virtual warehouses and their settings (as of 2021)
B
Explanation:
The auto-suspend and auto-resume settings in Snowflake apply to the entire virtual warehouse. These settings allow the warehouse to automatically suspend when it’s not in use, helping to save on compute costs. When queries or tasks are submitted to the warehouse, it can automatically resume operation. This functionality is designed to optimize resource usage and cost-efficiency.
References:
SnowPro Core Certification Exam Study Guide (as of 2021)
Snowflake documentation on virtual warehouses and their settings (as of 2021)
Question #48
Which user object property requires contacting Snowflake Support in order to set a value for it?
- A . DISABLED
- B . MINS TO BYPASS MFA
- C . MINS TO BYPASS NETWORK POLICY
- D . MINS TO UNLOCK
Correct Answer: B
B
Explanation:
The user property ‘MINS TO BYPASS MFA’ in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.
B
Explanation:
The user property ‘MINS TO BYPASS MFA’ in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.
Question #49
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
- A . Row level access policies
- B . Data masking policies
- C . Data encryption
- D . Time Travel
- E . External tokenization
Correct Answer: C, D
C, D
Explanation:
Data encryption and Time Travel are part of Snowflake’s Continuous Data Protection (CDP) feature set that do not require additional configuration. Data encryption is automatically applied to all files stored on internal stages, and Time Travel allows for querying and restoring data without any extra setup
C, D
Explanation:
Data encryption and Time Travel are part of Snowflake’s Continuous Data Protection (CDP) feature set that do not require additional configuration. Data encryption is automatically applied to all files stored on internal stages, and Time Travel allows for querying and restoring data without any extra setup
Question #50
Which Snowflake data type is used to store JSON key value pairs?
- A . TEXT
- B . BINARY
- C . STRING
- D . VARIANT
Correct Answer: D
D
Explanation:
The VARIANT data type in Snowflake is used to store JSON key-value pairs along with other semi-structured data formats like AVRO, BSON, and XML. The VARIANT data type allows for flexible and dynamic data structures within a single column, accommodating complex and nested data. This data type is crucial for handling semi-structured data in Snowflake, enabling users to perform SQL operations on JSON objects and arrays directly.
References: Snowflake Documentation: Semi-structured Data Types
D
Explanation:
The VARIANT data type in Snowflake is used to store JSON key-value pairs along with other semi-structured data formats like AVRO, BSON, and XML. The VARIANT data type allows for flexible and dynamic data structures within a single column, accommodating complex and nested data. This data type is crucial for handling semi-structured data in Snowflake, enabling users to perform SQL operations on JSON objects and arrays directly.
References: Snowflake Documentation: Semi-structured Data Types