Which object-level parameters can be set to help control query processing and concurrency? (Choose two).
Which object-level parameters can be set to help control query processing and concurrency? (Choose two).
The object-level parameters that help control query processing and concurrency are MAX_CONCURRENCY_LEVEL and STATEMENT_TIMEOUT_IN_SECONDS. MAX_CONCURRENCY_LEVEL limits the number of concurrent queries that can run in a warehouse, helping manage concurrency. STATEMENT_TIMEOUT_IN_SECONDS sets the maximum time a query can run before it is terminated, which is essential for controlling query processing.
D correct - Snowflake provides some object-level parameters that can be set to help control query processing and concurrency: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS STATEMENT_TIMEOUT_IN_SECONDS https://docs.snowflake.com/en/user-guide/warehouses-overview
Thanks for providing the Direct quote; your comment should be at the top of the discussion.
MAX_CONCURRENCY_LEVEL parameter to limit the number of concurrent queries running in a warehouse. Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. A,D
STATEMENT_TIMEOUT_IN_SECONDS: Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAX_CONCURRENCY_LEVEL parameter to ensure a warehouse is never backlogged.
correct
Snowflake provides some object-level parameters that can be set to help control query processing and concurrency: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS STATEMENT_TIMEOUT_IN_SECONDS
Statements A and E are correct: https://docs.snowflake.com/en/sql-reference/parameters#statement-queued-timeout-in-seconds STATEMENT_QUEUED_TIMEOUT_IN_SECONDS Amount of time, in seconds, a SQL statement (query, DDL, DML, etc.) remains queued for a warehouse before it is canceled by the system. This parameter can be used in conjunction with the MAX_CONCURRENCY_LEVEL parameter to ensure a warehouse is never backlogged.
In my opinion ADE are correct. The question should be more specific. If I had to choose, I would choose AD A for increasing/decreasing number of concurrent queries D for increasing the processing time