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

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 217

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

A.

Pipes

B.

Streams

C.

Tasks

D.

D. Procedures

Full Access
Question # 218

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A.

SCIM

B.

Federated authentication

C.

TLS 1.2

D.

Key-pair authentication

E.

OAuth

F.

OCSP authentication

Full Access
Question # 219

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

A.

ORC

B.

XML

C.

Avro

D.

Parquet

E.

JSON

Full Access
Question # 220

True or False: Fail-safe can be disabled within a Snowflake account.

A.

True

B.

False

Full Access
Question # 221

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A.

True

B.

False

Full Access
Question # 222

Which Snowflake feature is used for both querying and restoring data?

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Full Access
Question # 223

Which of the following can be executed/called with Snowpipe?

A.

A User Defined Function (UDF)

B.

A stored procedure

C.

A single copy_into statement

D.

A single insert__into statement

Full Access