Question 210
After the approved change, engineers revisit: An application connects with the correct account but receives a warehouse-not-found error because it selects an unapproved default warehouse. Which result establishes the intended state?
Explanation
Correct Answer
The session executes on the approved warehouse without account admin grants. This validates the relevant action: Set the intended connection warehouse and verify the active role has usage privileges. The underlying Snowflake behavior is: Connection parameters and warehouse privileges jointly determine whether a SQL session can run compute queries.
Incorrect Answers
An authorized production test object produces a corresponding pipe load-history event. This evidence tests a DIFFERENT situation: A cloud storage event notification invokes Snowpipe from a test bucket, but production bucket events point to a stale integration identifier. The correction required in this case is: Set the intended connection warehouse and verify the active role has usage privileges.
The updated client establishes an authorized session and runs the same controlled query. This evidence tests a DIFFERENT situation: A BI tool connects using an outdated driver and sees unsupported authentication failures after a platform security update. The correction required in this case is: Set the intended connection warehouse and verify the active role has usage privileges.
The validation identifies a deliberately malformed fixture without modifying production data. This evidence tests a DIFFERENT situation: A data engineer needs to inspect malformed rows before committing a bulk load into the finance table. The correction required in this case is: Set the intended connection warehouse and verify the active role has usage privileges.