COF-C02 SnowPro Core Certification Exam is now Stable and With Pass Result | Test Your Knowledge for Free

COF-C02 Practice Questions

SnowPro Core Certification Exam

Last Update 2 days ago
Total Questions : 948

Dive into our fully updated and stable COF-C02 practice test platform, featuring all the latest SnowPro Core Certification exam questions added this week. Our preparation tool is more than just a Snowflake study aid; it's a strategic advantage.

Our free SnowPro Core Certification practice questions crafted to reflect the domains and difficulty of the actual exam. The detailed rationales explain the 'why' behind each answer, reinforcing key concepts about COF-C02. Use this test to pinpoint which areas you need to focus your study on.

COF-C02 PDF

$43.75
~~$124.99~~

Add to Cart

COF-C02 Testing Engine

$50.75
~~$144.99~~

Add to Cart

COF-C02 PDF + Testing Engine

$63.7
~~$181.99~~

Add to Cart

Question # 41

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

PURGE

MODIFY

REMOVE

DELETE

Discussion 0

Question # 42

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Options:

Use the DROP command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO

command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

Discussion 0

command, which will automatically delete the files after they have been successfully loaded. Additionally, you can use the REMOVE command after the load completes to manually delete the files from the stage12.

References = DROP STAGE, REMOVE

Question # 43

What affects whether the query results cache can be used?

Options:

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Discussion 0

Question # 44

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

Discussion 0

Question # 45

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Options:

Reader

Consumer

Vendor

Standard

Personalized

Discussion 0

Question # 46

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

PUT

GET

COPY

SELECT

Discussion 0

Question # 47

The is the minimum Fail-safe retention time period for transient tables?

Options:

1 day

7 days

12 hours

0 days

Discussion 0

Question # 48

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options:

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

The ACCOUNTADMIN role must be granted to only one user.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Discussion 0

Question # 49

What is the maximum Time Travel retention period for a temporary Snowflake table?

Options:

90 days

1 day

7 days

45 days

Discussion 0

Question # 50

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Options:

Row level access policies

Data masking policies

Data encryption

Time Travel

External tokenization

Discussion 0

Question # 51

What is the purpose of multi-cluster virtual warehouses?

Options:

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

Discussion 0

Question # 52

Which of the following describes a Snowflake stored procedure?

Options:

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller's rights or an owner's rights.

Discussion 0

Question # 53

What happens to historical data when the retention period for an object ends?

Options:

The data is cloned into a historical object.

The data moves to Fail-safe

Time Travel on the historical data is dropped.

The object containing the historical data is dropped.

Discussion 0

Question # 54

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Options:

Custom Edition

Virtual Private Snowflake

Business Critical Edition

Standard Edition

Enterprise Edition

Discussion 0

Question # 55

What is the minimum Snowflake edition that has column-level security enabled?

Options:

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Discussion 0

Question # 56

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Options:

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

Discussion 0

Question # 57

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

Materialized view

Sequence

Secure view

Transient table

Clustered table

Discussion 0

Question # 58

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Options:

Schema

View

Internal stage

Table

User

Role

Discussion 0

Question # 59

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Options:

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Discussion 0

Question # 60

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options:

SHOW GRANTS OF ROLE MY_ROLE

SHOW GRANTS TO ROLE MY_ROLE

SHOW GRANTS FOR ROLE MY_ROLE

SHOW GRANTS ON ROLE MY_ROLE

Discussion 0

Get COF-C02 dumps and pass your exam in 24 hours!

We Accept

Secure Site

TESTED 17 Apr 2026
Customer Review

Hi this is Romona Kearns from Holland and I would like to tell you that I passed my exam with the use of exams4sure dumps. I got same questions in my exam that I prepared from your test engine software. I will recommend your site to all my friends for sure.

Romona Kearns Happy Customer
Money Back Guarantee

Our all material is important and it will be handy for you. If you have short time for exam so, we are sure with the use of it you will pass it easily with good marks. If you will not pass so, you could feel free to claim your refund. We will give 100% money back guarantee if our customers will not satisfy with our products.