Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Snowflake
SnowPro Core Certification
COF-R02
SnowPro Core Recertification Exam Questions and Answers

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam COF-R02 Premium Access

View all detail and faqs for the COF-R02 exam

Go to Exam

715 Students Passed

91% Average Score

92% Same Questions

Viewing page 10 out of 10 pages

Viewing questions 91-100 out of questions

Questions # 91:

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Options:

The clone always stays in sync with the original table.

The clone has better query performance.

The clone is created almost instantly.

The clone will have time travel history from the original table.

The clone saves space by not duplicating storage.

Answer

C, E

Questions # 92:

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Options:

1 second

60 seconds

5 minutes

60 minutes

Answer

Questions # 93:

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Options:

Whether or not it is also a secure view

How often the underlying base table is queried

How often the base table changes

Whether the materialized view has a cluster key defined

How often the materialized view is queried

Answer

D, E

Questions # 94:

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Options:

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

Answer

Questions # 95:

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Options:

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

Answer

Questions # 96:

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Options:

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Answer

Questions # 97:

A materialized view should be created when which of the following occurs? (Choose two.)

Options:

There is minimal cost associated with running the query.

The query consumes many compute resources every time it runs.

The base table gets updated frequently.

The query is highly optimized and does not consume many compute resources.

The results of the query do not change often and are used frequently.

Answer

C, E

Questions # 98:

What is true about sharing data in Snowflake? (Choose two.)

Options:

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

Answer

B, C

Questions # 99:

Where is Snowflake metadata stored?

Options:

Within the data files

In the virtual warehouse layer

In the cloud services layer

In the remote storage layer

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/querying-metadata.html#:~:text=Snowflake%20automatically%20generates%20metadata%20for,using%20a%20standard%20SELECT%20statement, ]

Viewing page 10 out of 10 pages

Viewing questions 91-100 out of questions