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
Explanation:
Explanation:
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.