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 10 out of 10 pages
Viewing questions 91-100 out of questions
Questions # 91:

How does Snowflake Fail-safe protect data in a permanent table?

Options:
A.

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.

Fail-safe makes data available for 7 days, recoverable by user operations.

C.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Expert Solution
Questions # 92:

What is cached during a query on a virtual warehouse?

Options:
A.

All columns in a micro-partition

B.

Any columns accessed during the query

C.

The columns in the result set of the query

D.

All rows accessed during the query

Expert Solution
Questions # 93:

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Options:
A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

Expert Solution
Questions # 94:

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:
A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Expert Solution
Questions # 95:

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Options:
A.

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 30 days.

Fail Safe retention time is 1 day.

B.

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 365 days.

Fail Safe retention time is 7 days.

C.

Default Time Travel Retention is set to 0 days.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

D.

Default Time Travel Retention is set to 1 day.

Maximum Time Travel Retention is 90 days.

Fail Safe retention time is 7 days.

E.

Default Time Travel Retention is set to 7 days.

Maximum Time Travel Retention is 1 day.

Fail Safe retention time is 90 days.

F.

Default Time Travel Retention is set to 90 days.

Maximum Time Travel Retention is 7 days.

Fail Safe retention time is 356 days.

Expert Solution
Questions # 96:

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Options:
A.

STRIP_NULL_VALUES

B.

SKIP_BYTE_ORDER_MARK

C.

REPLACE_INVALID_CHARACTERS

D.

VALIDATION_MODE

Expert Solution
Questions # 97:

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Options:
A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Expert Solution
Questions # 98:

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Options:
A.

Use auto-ingest Snowpipes to load large files in a serverless model.

B.

Produce the largest files possible, reducing the overall number of files to process.

C.

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

D.

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Expert Solution
Questions # 99:

Which formats does Snowflake store unstructured data in? (Choose two.)

Options:
A.

GeoJSON

B.

Array

C.

XML

D.

Object

E.

BLOB

Expert Solution
Viewing page 10 out of 10 pages
Viewing questions 91-100 out of questions