Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

• A.To accommodate more queries
• B.To accommodate more users
• C.To accommodate fluctuations in workload
• D.To accommodate a more complex workload

Comment: *

Name: *

Email: *

Verification: *

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

• A.It removes the last element of the outer array.
• B.It removes the outer array structure and loads the records into separate table rows,
• C.It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• D.It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Comment: *

Name: *

Email: *

Verification: *

What is the recommended file sizing for data loading using Snowpipe?

• A.A compressed file size greater than 100 MB, and up to 250 MB
• B.A compressed file size greater than 100 GB, and up to 250 GB
• C.A compressed file size greater than 10 MB, and up to 100 MB
• D.A compressed file size greater than 1 GB, and up to 2 GB

Comment: *

Name: *

Email: *

Verification: *

True or False: The COPY command must specify a File Format in order to execute.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake architectural layer is responsible for a query execution plan?

• A.Compute
• B.Data storage
• C.Cloud services
• D.Cloud provider

Comment: *

Name: *

Email: *

Verification: *