Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

Snowflake COF-R02 SnowPro Core Recertification Exam Exam Practice Test

Page: 1 / 33
Total 330 questions

SnowPro Core Recertification Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

What is the minimum Snowflake edition required to create a materialized view?

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 2

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

Options:

A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Question 3

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

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Question 4

What is the default File Format used in the COPY command if one is not specified?

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Question 5

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Options:

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Question 6

When is the result set cache no longer available? (Select TWO)

Options:

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Question 7

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Options:

A.

Yes, because a table owner has full control and can unset masking policies.

B.

Yes, because masking policies only apply to cloned tables.

C.

No, because masking policies must always reference specific access roles.

D.

No, because ownership of a table does not include the ability to change masking policies

Question 8

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Question 9

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

Options:

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Question 10

Which data type can be used to store geospatial data in Snowflake?

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Question 11

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

A.

Time Travel - 1 day. Fail-safe - 1 day

B.

Time Travel - 0 days. Fail-safe - 1 day

C.

Time Travel - 1 day. Fail-safe - 0 days

D.

Transient tables are retained in neither Fail-safe nor Time Travel

Question 12

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Question 13

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Options:

A.

True

B.

False

Question 14

True or False: Fail-safe can be disabled within a Snowflake account.

Options:

A.

True

B.

False

Question 15

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

Options:

A.

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Question 16

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Options:

A.

It removes the last element of the outer array.

B.

It removes the outer array structure and loads the records into separate table rows,

C.

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D.

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records