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.
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.
correct
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.
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
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
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
Query processing and concurrency¶ The number of queries that a warehouse can concurrently process is determined by the size and complexity of each query. As queries are submitted, the warehouse calculates and reserves the compute resources needed to process each query. If the warehouse does not have enough remaining resources to process a query, the query is queued, pending resources that become available as other running queries complete. 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
The information about the object-level parameters that can be set to help control query processing and concurrency in Snowflake can be found in the Snowflake documentation. Specifically, the MAX_CONCURRENCY_LEVEL and STATEMENT_QUEUED_TIMEOUT_IN_SECONDS parameters are used to manage query processing and concurrency.
Sorry, but this time, Heetec is absolutely right: I identified the questions body and the phrase he mentioned, exactly in the docs.snowflake, at the link he sent to us