exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 762 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 762
Topic #: 1
[All SnowPro Core Questions]

Which object-level parameters can be set to help control query processing and concurrency? (Choose two).

  • A. MAX_CONCURRENCY_LEVEL
  • B. DATA_RETENTION_TIME_IN_DAYS
  • C. MIN_DATA_RETENTION_TIME_IN_DAYS
  • D. STATEMENT_TIMEOUT_IN_SECONDS
  • E. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Heetec
Highly Voted 1 year, 2 months ago
Selected Answer: DE
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
upvoted 6 times
induna
8 months, 3 weeks ago
Thanks for providing the Direct quote; your comment should be at the top of the discussion.
upvoted 1 times
...
...
Shipra123
Most Recent 1 month ago
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
upvoted 1 times
...
Rameez1
5 months, 3 weeks ago
Selected Answer: DE
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
upvoted 1 times
...
ahadh7621
7 months ago
Selected Answer: AE
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.
upvoted 1 times
...
yaho5
8 months, 2 weeks ago
Selected Answer: AD
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
upvoted 2 times
...
Tejassv
9 months, 4 weeks ago
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
upvoted 2 times
...
nexerSnow
10 months ago
Selected Answer: DE
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.
upvoted 2 times
...
romega2
1 year, 2 months ago
Selected Answer: DE
correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago