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: *

Which statement about billing applies to Snowflake credits?

• A.Credits are billed per-minute with a 60-minute minimum
• B.Credits are used to pay for cloud data storage usage
• C.Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D.Credits are consumed based on the warehouse size and the time the warehouse is running

Comment: *

Name: *

Email: *

Verification: *

Which semi-structured file format is a compressed, efficient, columnar data representation?

• A.Avro
• B.JSON
• C.TSV
• D.Parquet

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake objects can be defined with future grants? (Select TWO).

• A.Databases
• B.Virtual warehouses
• C.External functions
• D.Masking policies
• E.Schemas

Comment: *

Name: *

Email: *

Verification: *

While unloading data into a stage, how can the user ensure that the output will be a single file?

• A.Use the copy option files=single.
• B.Use the COPY Option SINGLE=TRUE .
• C.Use the get option SINGLE-TRUE.
• D.Use the GET option FILES-SINGLE.

Comment: *

Name: *

Email: *

Verification: *