Which formats does Snowflake store unstructured data in? (Choose two.)

Answer(s): B,D

A user is preparing to load data from an external stage.
Which practice will provide the MOST efficient loading performance?

Answer(s): A

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

The warehouse size does not change until all queries currently running in the warehouse have completed.
The warehouse size does not change until all queries currently in the warehouse queue have completed.
The warehouse size does not change until the warehouse is suspended and restarted.
It does not return from the command until the warehouse has finished changing its size.

Answer(s): D

Which of the following can be used when unloading data from Snowflake? (Choose two.)

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
Use the ENCODING file format option to change the encoding from the default UTF-8.
The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Answer(s): C,D

Free SnowPro Core Exam Braindumps (page: 87)