Pre-Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

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

Exams4sure Dumps

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

COF-C02 PDF (Printable)
$43.75
$124.99

COF-C02 Testing Engine

COF-C02 PDF (Printable)
$50.75
$144.99

COF-C02 PDF + Testing Engine

COF-C02 PDF (Printable)
$63.7
$181.99
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:

A.  

PURGE

B.  

MODIFY

C.  

REMOVE

D.  

DELETE

Discussion 0
Question # 42

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

Options:

A.  

Use the DROP command after the load completes.

B.  

Specify the TEMPORARY option when creating the file format.

C.  

Specify the PURGE copy option in the COPY INTO

command.

D.  

Use the REMOVE command after the load completes.

E.  

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:

A.  

If the query contains a deterministic function

B.  

If the virtual warehouse has been suspended

C.  

If the referenced data in the table has changed

D.  

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:

A.  

Tri-Secret Secure

B.  

Time Travel

C.  

Fail-safe

D.  

Data encryption

E.  

External stages

Discussion 0
Question # 45

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

Options:

A.  

Reader

B.  

Consumer

C.  

Vendor

D.  

Standard

E.  

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:

A.  

PUT

B.  

GET

C.  

COPY

D.  

SELECT

Discussion 0
Question # 47

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

Options:

A.  

1 day

B.  

7 days

C.  

12 hours

D.  

0 days

Discussion 0
Question # 48

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

Options:

A.  

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

B.  

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

C.  

The ACCOUNTADMIN role must be granted to only one user.

D.  

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

E.  

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:

A.  

90 days

B.  

1 day

C.  

7 days

D.  

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:

A.  

Row level access policies

B.  

Data masking policies

C.  

Data encryption

D.  

Time Travel

E.  

External tokenization

Discussion 0
Question # 51

What is the purpose of multi-cluster virtual warehouses?

Options:

A.  

To create separate data warehouses to increase query optimization

B.  

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

C.  

To eliminate or reduce Queuing of concurrent queries

D.  

To allow the warehouse to resize automatically

Discussion 0
Question # 52

Which of the following describes a Snowflake stored procedure?

Options:

A.  

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

B.  

They can only access tables from a single database.

C.  

They can contain only a single SQL statement.

D.  

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:

A.  

The data is cloned into a historical object.

B.  

The data moves to Fail-safe

C.  

Time Travel on the historical data is dropped.

D.  

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:

A.  

Custom Edition

B.  

Virtual Private Snowflake

C.  

Business Critical Edition

D.  

Standard Edition

E.  

Enterprise Edition

Discussion 0
Question # 55

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

Options:

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

Discussion 0
Question # 56

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

Options:

A.  

Removing a column from the query SELECT list

B.  

Stopping the virtual warehouse that the query is running against

C.  

Clustering of the data used by the query

D.  

Executing the RESULTS_SCAN() table function

E.  

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:

A.  

Materialized view

B.  

Sequence

C.  

Secure view

D.  

Transient table

E.  

Clustered table

Discussion 0
Question # 58

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

Options:

A.  

Schema

B.  

View

C.  

Internal stage

D.  

Table

E.  

User

F.  

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:

A.  

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

B.  

The transient table version cannot be retrieved after 24 hours.

C.  

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

D.  

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:

A.  

SHOW GRANTS OF ROLE MY_ROLE

B.  

SHOW GRANTS TO ROLE MY_ROLE

C.  

SHOW GRANTS FOR ROLE MY_ROLE

D.  

SHOW GRANTS ON ROLE MY_ROLE

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

Free Exams Sample Questions

  • We Accept

    exams4sure payments accept


    Secure Site

    mcafee secure

    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.

    exams4sure customer reviews
    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.