[Apr 10, 2025] Free Snowflake COF-R02 Exam Questions & Answer [Q77-Q91]

5/5 - (1 vote)

[Apr 10, 2025] Free Snowflake COF-R02 Exam Questions and Answer

Verified COF-R02 dumps Q&As Latest COF-R02 Download

NEW QUESTION 77
Which stage type can be altered and dropped?

Database stage

External stage

Table stage

User stage

Explanation
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

NEW QUESTION 78
Where would a Snowflake user find information about query activity from 90 days ago?

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema – query history_by_ses s i on view

NEW QUESTION 79
Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO

GET

WRITE

EXTRACT INTO

Explanation
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%2

NEW QUESTION 80
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

NEW QUESTION 81
Which of the following statements describes a schema in Snowflake?

A logical grouping of objects that belongs to a single database

A logical grouping of objects that belongs to multiple databases

A named Snowflake object that includes all the information required to share a database

A uniquely identified Snowflake account within a business entity

NEW QUESTION 82
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

Explanation
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

NEW QUESTION 83
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Local disk caching

Authentication and access control

Metadata management

Query processing

Database storage

NEW QUESTION 84
The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html

NEW QUESTION 85
What happens when a cloned table is replicated to a secondary database? (Select TWO)

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

Explanation
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%

NEW QUESTION 86
How often are the Account and Table master keys automatically rotated by Snowflake?

30 Days

60 Days

90 Days

365 Days.

NEW QUESTION 87
Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Execute a COPY command

Updating data

Snowpipe

AUTOMATIC__CLUSTERING

Scaling up a warehouse

NEW QUESTION 88
How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.

1 day

7 days

31 days

90 days

Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

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

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

NEW QUESTION 90
What SQL command would be used to view all roles that were granted to user.1?

show grants to user USER1;

show grants of user USER1;

describe user USER1;

show grants on user USER1;

NEW QUESTION 91
Which of the following objects are contained within a schema? (Choose two.)

Role

Stream

Warehouse

External table

User

Loading …

Use Real Dumps – 100% Free COF-R02 Exam Dumps: https://www.prepawaytest.com/Snowflake/COF-R02-practice-exam-dumps.html

Leave a Reply Cancel reply