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 7 out of 10 pages

Viewing questions 61-70 out of questions

Questions # 61:

Which of the following are benefits of micro-partitioning? (Select TWO)

Options:

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

Answer

A, D

Explanation

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Questions # 62:

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

Options:

Informatica

Power Bl

Adobe

Data Robot

Answer

Explanation

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

Questions # 63:

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Options:

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

Answer

A, C

Questions # 64:

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Options:

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

Answer

C, E

Explanation

Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.

Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):

Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.

Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.

https://docs.snowflake.com/en/user-guide/data-availability.html

Questions # 65:

A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?

Options:

list @file__stage

show @file__stage

view @file__stage

verify @file__stage

Answer

Questions # 66:

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Options:

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

Answer

A, E

Questions # 67:

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options:

USAGE

OPERATE

MONITOR

MODIFY

Answer

Explanation

[Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege, ]

Questions # 68:

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options:

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

Allows a user to import the files in a sequential order

Increases the latency staging and accuracy when loading the data

Allows optimization of parallel operations

Answer

Questions # 69:

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Options:

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Answer

B, C, E

Questions # 70:

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

Options:

view @my_stage

list @my_stage

show @my_stage

display @my_stage

Answer

Viewing page 7 out of 10 pages

Viewing questions 61-70 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25

ADM-201

Agentforce-Specialist

CMMC-CCP

Data-Cloud-Consultant

PDI

PSE-Strata-Pro-24

Secure-Software-Design

Sharing-and-Visibility-Architect

Workday-Pro-Integrations

ZDTA