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

A materialized view should be created when which of the following occurs? (Choose two.)

Options :

A : There is minimal cost associated with running the query.

B : The query consumes many compute resources every time it runs.

C : The base table gets updated frequently.

D : The query is highly optimized and does not consume many compute resources.

E : The results of the query do not change often and are used frequently.

Answer: A,C

Question 3

During periods of warehouse contention which parameter controls the maximum length of time a warehouse

will hold a query for processing?

Options :

A : STATEMENT_TIMEOUT__IN__SECONDS

B : STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C : MAX_CONCURRENCY__LEVEL

D : QUERY_TIMEOUT_IN_SECONDS

Answer: B

Question 4

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options :

A : The Pipe load history is reset to empty.

B : The REFRESH command is executed.

C : The stage will be purged.

D : The destination table is truncated.

Answer: B

Question 5

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

Higher Test Marks with Free Online COF-R02 Exam Practice

Buying Options: