Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bigdisc65

Download Full Version COF-R02 Snowflake Exam

Page: 9 / 12
Question 36

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

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 37

Where would a Snowflake user find information about query activity from 90 days ago?

Options:

A.

account__usage . query history view

B.

account__usage.query__history__archive View

C.

information__schema . cruery_history view

D.

information__schema - query history_by_ses s i on view

Question 38

Which of the following commands cannot be used within a reader account?

Options:

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Question 39

What tasks can be completed using the copy command? (Select TWO)

Options:

A.

Columns can be aggregated

B.

Columns can be joined with an existing table

C.

Columns can be reordered

D.

Columns can be omitted

E.

Data can be loaded without the need to spin up a virtual warehouse

Page: 9 / 12
Exam Code: COF-R02
Exam Name: SnowPro Core Recertification Exam
Last Update: May 2, 2024
Questions: 330
COF-R02 pdf

COF-R02 PDF

$28  $80
COF-R02 Engine

COF-R02 Testing Engine

$33.25  $95
COF-R02 PDF + Engine

COF-R02 PDF + Testing Engine

$45.5  $130