1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-R02
  5. SnowPro Core Recertification Exam Questions and Answers

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

 Snowflake Exams      Go to Exam Detail      Get Premium Access
Viewing page 9 out of 10 pages
Viewing questions 81-90 out of questions
Questions # 81:

Which of the following describes the Snowflake Cloud Services layer?

Options:
A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Expert Solution
Questions # 82:

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Options:
A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Expert Solution
Questions # 83:

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.

Expert Solution
Questions # 84:

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

Expert Solution
Questions # 85:

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Options:
A.

Roles

B.

Databases

C.

Warehouses

D.

Users

E.

Accounts

Expert Solution
Questions # 86:

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

Options:
A.

The clone always stays in sync with the original table.

B.

The clone has better query performance.

C.

The clone is created almost instantly.

D.

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

E.

The clone saves space by not duplicating storage.

Expert Solution
Questions # 87:

Which TABLE function helps to convert semi-structured data to a relational representation?

Options:
A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

Expert Solution
Questions # 88:

How can a row access policy be applied to a table or a view? (Choose two.)

Options:
A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;

Expert Solution
Questions # 89:

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

Expert Solution
Questions # 90:

What COPY INTO SQL command should be used to unload data into multiple files?

Options:
A.

SINGLE=TRUE

B.

MULTIPLE=TRUE

C.

MULTIPLE=FALSE

D.

SINGLE=FALSE

Expert Solution
Viewing page 9 out of 10 pages
Viewing questions 81-90 out of questions