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

Complete COF-C02 Snowflake Materials

Page: 29 / 45
Total 605 questions

SnowPro Core Certification Exam (COF-C02) Questions and Answers

Question 113

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Options:

A.

The reader account will automatically use the Standard edition of Snowflake.

B.

The reader account compute will be billed to the provider account.

C.

The reader account can clone data the provider has shared, but cannot re-share it.

D.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Question 114

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Options:

A.

Swift

B.

JavaScript

C.

Python

D.

SQL

Question 115

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Options:

A.

10

B.

50

C.

64

D.

256

Question 116

Which Snowflake object can be accessed in he FROM clause of a query, returning a set of rows having one or more columns?

Options:

A.

A User-Defined Table Function (UDTF)

B.

A Scalar User Function (UDF)

C.

A stored procedure

D.

A task

Page: 29 / 45
Total 605 questions