Question 1

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Options :

A : True

B : False

Answer: B

Question 2

Which type of table corresponds to a single Snowflake session?

Options :

A : Temporary

B : Translent

C : Provisional

D : Permanent

Answer: A

Question 3

Which TABLE function helps to convert semi-structured data to a relational representation?

Options :

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Question 4

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Options :

A : The validation_mode option is used when creating an Internal Stage

B : validation_mode=return_all_errors is a parameter of the copy command

C : The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D : The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: D

Question 5

How would you determine the size of the virtual warehouse used for a task?

Options :

A : Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B : Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C : If using the stored procedure to execute multiple SQL statements, it-s best to test run the stored procedure separately to size the compute resource first

D : Since task infrastructure is based on running the task body on schedule, it-s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer: C