Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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
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
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Heetec
Highly Voted 6 months, 3 weeks agoinduna
4 weeks agoyaho5
Most Recent 3 weeks agoTejassv
2 months agonexerSnow
2 months, 1 week agoromega2
6 months, 3 weeks ago