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

Viewing questions 31-40 out of questions

Questions # 31:

Which of the following roles is recommended to be used to create and manage users and roles?

Options:

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

Answer

Explanation

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

"Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

Questions # 32:

Which of the following objects is not covered by Time Travel?

Options:

Tables

Schemas

Databases

Stages

Answer

Explanation

[Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html, , ]

Questions # 33:

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Options:

True

False

Answer

Questions # 34:

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

Answer

C, D

Questions # 35:

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

Options:

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Answer

Explanation

Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support

https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support .

Questions # 36:

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

Options:

show grants to user USER1;

show grants of user USER1;

describe user USER1;

show grants on user USER1;

Answer

Questions # 37:

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Options:

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Answer

Questions # 38:

What feature can be used to reorganize a very large table on one or more columns?

Options:

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

Answer

Explanation

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

Questions # 39:

Which Snowflake technique can be used to improve the performance of a query?

Options:

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

Answer

Explanation

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

Questions # 40:

What are value types that a VARIANT column can store? (Select TWO)

Options:

STRUCT

OBJECT

BINARY

ARRAY

CLOB

Answer

B, D

Explanation

Characteristics of a VARIANT

A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB .

Viewing page 4 out of 10 pages

Viewing questions 31-40 out of questions