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 #91
In Snowflake, the use of federated authentication enables which Single Sign-On (SSO) workflow activities? (Select TWO).
- A . Authorizing users
- B . Initiating user sessions
- C . Logging into Snowflake
- D . Logging out of Snowflake
- E . Performing role authentication
Correct Answer: B C
B C
Explanation:
Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO).
The key activities enabled by this setup include:
B. Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization.
C. Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization’s identity provider instead of managing separate credentials for Snowflake.
References: Snowflake Documentation: Configuring Federated Authentication
B C
Explanation:
Federated authentication in Snowflake allows users to use their organizational credentials to log in to Snowflake, leveraging Single Sign-On (SSO).
The key activities enabled by this setup include:
B. Initiating user sessions: Federated authentication streamlines the process of starting a user session in Snowflake by using the existing authentication mechanisms of an organization.
C. Logging into Snowflake: It simplifies the login process, allowing users to authenticate with their organization’s identity provider instead of managing separate credentials for Snowflake.
References: Snowflake Documentation: Configuring Federated Authentication
Question #92
Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?
- A . Snowsight
- B . SnowCD
- C . Snowpark
- D . SnowSQL
Correct Answer: D
D
Explanation:
SnowSQL is the Command Line Interface (CLI) client provided by Snowflake for executing SQL queries and performing various tasks. It allows users to connect to their Snowflake accounts and interact with the Snowflake data warehouse.
Installation: SnowSQL can be downloaded and installed on various operating systems.
Configuration: Users need to configure SnowSQL with their Snowflake account credentials.
Usage: Once configured, users can run SQL queries, manage data, and perform administrative tasks through the CLI.
References:
Snowflake Documentation: SnowSQL
Snowflake Documentation: Installing SnowSQL
D
Explanation:
SnowSQL is the Command Line Interface (CLI) client provided by Snowflake for executing SQL queries and performing various tasks. It allows users to connect to their Snowflake accounts and interact with the Snowflake data warehouse.
Installation: SnowSQL can be downloaded and installed on various operating systems.
Configuration: Users need to configure SnowSQL with their Snowflake account credentials.
Usage: Once configured, users can run SQL queries, manage data, and perform administrative tasks through the CLI.
References:
Snowflake Documentation: SnowSQL
Snowflake Documentation: Installing SnowSQL
Question #93
Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?
- A . Alerts
- B . External tables
- C . Secure views
- D . Materialized views
Correct Answer: A
Question #94
A company strongly encourages all Snowflake users to self-enroll in Snowflake’s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A . Okta Verify
- B . Duo Mobile
- C . Microsoft Authenticator
- D . Google Authenticator
Correct Answer: B
B
Explanation:
Snowflake’s default Multi-Factor Authentication (MFA) service is powered by Duo Security. Users are required to install the Duo Mobile application on their devices to use MFA for increased login security when connecting to Snowflake. This service is managed entirely by Snowflake, and users do not need to sign up separately with Duo1.
B
Explanation:
Snowflake’s default Multi-Factor Authentication (MFA) service is powered by Duo Security. Users are required to install the Duo Mobile application on their devices to use MFA for increased login security when connecting to Snowflake. This service is managed entirely by Snowflake, and users do not need to sign up separately with Duo1.
Question #95
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A . Time Travel – 1 day. Fail-safe – 1 day
- B . Time Travel – 0 days. Fail-safe – 1 day
- C . Time Travel – 1 day. Fail-safe – 0 days
- D . Transient tables are retained in neither Fail-safe nor Time Travel
Correct Answer: C
C
Explanation:
Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains data beyond the Time Travel period for recovery purposes in case of extreme data loss. Since transient tables are designed for temporary or intermediate workloads with no requirement for long-term durability, they do not include a Fail-safe period by default1.
References:
Snowflake Documentation on Storage Costs for Time Travel and Fail-safe
C
Explanation:
Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains data beyond the Time Travel period for recovery purposes in case of extreme data loss. Since transient tables are designed for temporary or intermediate workloads with no requirement for long-term durability, they do not include a Fail-safe period by default1.
References:
Snowflake Documentation on Storage Costs for Time Travel and Fail-safe
Question #96
In a Snowflake role hierarchy, what is the top-level role?
- A . SYSADMIN
- B . ORGADMIN
- C . ACCOUNTADMIN
- D . SECURITYADMIN
Correct Answer: C
C
Explanation:
In a Snowflake role hierarchy, the top-level role is ACCOUNTADMIN. This role has the highest level of privileges and is capable of performing all administrative functions within the Snowflake account
C
Explanation:
In a Snowflake role hierarchy, the top-level role is ACCOUNTADMIN. This role has the highest level of privileges and is capable of performing all administrative functions within the Snowflake account
Question #97
Which Snowflake layer is always leveraged when accessing a query from the result cache?
- A . Metadata
- B . Data Storage
- C . Compute
- D . Cloud Services
Correct Answer: D
D
Explanation:
The Cloud Services layer in Snowflake is responsible for managing the result cache. When a query is executed, the results are stored in this cache, and subsequent identical queries can leverage these cached results without re-executing the entire query1.
D
Explanation:
The Cloud Services layer in Snowflake is responsible for managing the result cache. When a query is executed, the results are stored in this cache, and subsequent identical queries can leverage these cached results without re-executing the entire query1.
Question #98
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
- A . When the system has enough load for 2 minutes
- B . When the system has enough load for 6 minutes
- C . When the system has enough load for 8 minutes
- D . When the system has enough load for 10 minutes
Correct Answer: A
A
Explanation:
In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A). This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it2.
A
Explanation:
In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A). This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it2.
Question #99
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
- A . Data is live, ready-to-query, and can be personalized.
- B . Data needs to be loaded into a cloud provider as a consumer account.
- C . Data is not available for copying or moving to an individual Snowflake account.
- D . Data is available without copying or moving.
- E . Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Correct Answer: A, D
A, D
Explanation:
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
A, D
Explanation:
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
Question #100
Which command should be used to unload all the rows from a table into one or more files in a named stage?
- A . COPY INTO
- B . GET
- C . INSERT INTO
- D . PUT
Correct Answer: A
A
Explanation:
To unload data from a table into one or more files in a named stage, the COPY INTO <location> command should be used. This command exports the result of a query, such as selecting all rows from a table, into files stored in the specified stage. The COPY INTO command is versatile, supporting various file formats and compression options for efficient data unloading.
References: Snowflake Documentation: COPY INTO Location
A
Explanation:
To unload data from a table into one or more files in a named stage, the COPY INTO <location> command should be used. This command exports the result of a query, such as selecting all rows from a table, into files stored in the specified stage. The COPY INTO command is versatile, supporting various file formats and compression options for efficient data unloading.
References: Snowflake Documentation: COPY INTO Location