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

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Searching for workable clues to ace the Snowflake COF-C02 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-C02 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 # 177

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Full Access
Question # 178

A user has unloaded data from a Snowflake table to an external stage.

Which command can be used to verify if data has been uploaded to the external stage named my_stage?

A.

view @my_stage

B.

list @my_stage

C.

show @my_stage

D.

display @my_stage

Full Access
Question # 179

What are supported file formats for unloading data from Snowflake? (Choose three.)

A.

XML

B.

JSON

C.

Parquet

D.

ORC

E.

AVRO

F.

CSV

Full Access
Question # 180

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Full Access
Question # 181

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A.

Reader

B.

Consumer

C.

Vendor

D.

Standard

E.

Personalized

Full Access
Question # 182

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

A.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

C.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

D.

A user cannot specify a default warehouse when using the ODBC driver.

E.

The default virtual warehouse size can be changed at any time.

Full Access
Question # 183

What kind of authentication do Snowpipe REST endpoints use?

A.

OAuth

B.

Key-based

C.

Username and password

D.

Single Sign-On (SSO)

Full Access
Question # 184

What will be the result of this command?

SELECT value FROM LATERAL FLATTEN(input => parse_json('[1, 2, 3]'));

A.

It will return a single row with three columns with values 1, 2, and 3.

B.

It will return a single row with the values 1, 2, and 3 concatenated.

C.

It will return a single row with the array [1, 2, 3].

D.

It will return three rows with the values 1, 2, and 3.

Full Access
Go to page: