Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-R02 - SnowPro Core Recertification Exam

COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Go to page:
Question # 4

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A.

True

B.

False

Full Access
Question # 5

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

A.

Via the Snowflake Web Interface (Ul)

B.

Via the data_share=true parameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Full Access
Question # 6

Which stage type can be altered and dropped?

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Full Access
Question # 7

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?

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;

Full Access
Question # 8

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

A.

Execute a COPY command

B.

Updating data

C.

Snowpipe

D.

AUTOMATIC__CLUSTERING

E.

Scaling up a warehouse

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps