Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Searching for workable clues to ace the Snowflake COF-R02 Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s COF-R02 PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

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: