QuestionQ92

Performance, Cost, and Resource Optimization

When using the STATEMENT_TIMEOUT_IN_SECONDS parameter for cost control, at which levels should this parameter be defined?

Choose three
Explanation

STATEMENT_TIMEOUT_IN_SECONDS is used to cap query runtime for cost control. As a governance/default setting it is defined at the Account level (B), the User level (A), and on the Virtual warehouse object (F), where the lowest applicable value wins. It is not an Organization- or Schema-level parameter, ruling out C and D. It can technically also be overridden per Session (E), but Session is a transient runtime override rather than a level where you 'define' the control, so the three intended answers are Account, User, and Virtual warehouse (A, B, F).

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!