Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Architect · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
When the parameter like STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set for both a warehouse and a session, the lowest non-zero value is enforced therefore A is not correct. D is my answer
Session parameters not always override Virtual Warehouse parameters, see i.e. here: https://docs.snowflake.com/sql-reference/parameters#statement-timeout-in-seconds Only account->database->schema->table always keeps hierarchy of parameters
Answer is A and is validated