CertsTopics Logo

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

Free COF-C02 Questions Attempt

Page: 34 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 133

How can a Snowflake user traverse semi-structured data?

Options:

A.

Insert a colon (:) between the VARIANT column name and any first-level element.

B.

Insert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

C.

Insert a double colon (: :) between the VARIANT column name and any second-level element.

Question 134

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Options:

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 135

Which Snowflake object does not consume any storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Question 136

Which Snowflake function will parse a JSON-null into a SQL-null?

Options:

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Page: 34 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF