What COPY INTO SQL command should be used to unload data into multiple files?

• A.SINGLE=TRUE
• B.MULTIPLE=TRUE
• C.MULTIPLE=FALSE
• D.SINGLE=FALSE

Comment: *

Name: *

Email: *

Verification: *

A Snowflake Marketplace listing has 50 subscribers accessing shared tables.
What determines the compute costs incurred by the subscribers?

• A.The total number of subscribers
• B.The size of the shared data
• C.Each subscriber's query execution using the subscriber's own virtual warehouses
• D.The provider's warehouse size used for the Marketplace listing

Comment: *

Name: *

Email: *

Verification: *

What should be considered before implementing a Data Clean Room?

• A.SQL queries can be run against the data in the clean room.
• B.Providers can only configure and share clean rooms with users in other Snowflake accounts.
• C.Consumers must be approved by a clean room administrator before they can be invited.
• D.All participating accounts must be in the same geographic region.

Comment: *

Name: *

Email: *

Verification: *

What is the MOST performant file format for loading data in Snowflake?

• A.CSV (Unzipped)
• B.Parquet
• C.CSV (Gzipped)
• D.ORC

Comment: *

Name: *

Email: *

Verification: *

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

• A.STRIP_NULL_VALUES
• B.SKIP_BYTE_ORDER_MARK
• C.REPLACE_INVALID_CHARACTERS
• D.VALIDATION_MODE

Comment: *

Name: *

Email: *

Verification: *