Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

• A.Java
• B.Javascript
• C.Scala
• D.Python
• E.SQL

Comment: *

Name: *

Email: *

Verification: *

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?

• 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...

Comment: *

Name: *

Email: *

Verification: *

Which command should be used to unload all the rows from a table into one or more files in a named stage?

• A.COPY INTO
• B.GET
• C.INSERT INTO
• D.PUT

Comment: *

Name: *

Email: *

Verification: *

What does the LATERAL modifier for the FLATTEN function do?

• A.Casts the values of the flattened data
• B.Extracts the path of the flattened data
• C.Joins information outside the object with the flattened data
• D.Retrieves a single instance of a repeating element in the flattened data

Comment: *

Name: *

Email: *

Verification: *

What is the only supported character set for loading and unloading data from all supported file formats?

• A.UTF-8
• B.WINDOWS-1253
• C.UTF-16
• D.ISO-8859-1

Comment: *

Name: *

Email: *

Verification: *