Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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 8 out of 10 pages
Viewing questions 71-80 out of questions
Questions # 71:

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Options:

A.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.

When the data cache is full, the least-recently used data will be cleared to make room.

C.

A user can only access their own queries from the query result cache.

D.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Questions # 72:

In a Snowflake role hierarchy, what is the top-level role?

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Questions # 73:

Which feature allows a user the ability to control the organization of data in a micro-partition?

Options:

A.

Range Partitioning

B.

Search Optimization Service

C.

Automatic Clustering

D.

Horizontal Partitioning

Questions # 74:

What type of query benefits the MOST from search optimization?

Options:

A.

A query that uses only disjunction (i.e., OR) predicates

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Questions # 75:

Which of the following objects are contained within a schema? (Choose two.)

Options:

A.

Role

B.

Stream

C.

Warehouse

D.

External table

E.

User

F.

Share

Questions # 76:

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

Options:

A.

USERADMIN

B.

PUBLIC

C.

ORGADMIN

D.

SYSADMIN

Questions # 77:

How many resource monitors can be assigned at the account level?

Options:

A.

1

B.

2

C.

3

D.

4

Questions # 78:

Which statement is true about running tasks in Snowflake?

Options:

A.

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.

A task can be executed using a SELECT statement to run a predefined SQL command.

Questions # 79:

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Options:

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Questions # 80:

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

Viewing page 8 out of 10 pages
Viewing questions 71-80 out of questions
TOP CODES

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