Question 680
For a regulated healthcare organization, this issue must not recur: Operations increases warehouse size but sees no reduction in lock-like application-side queueing caused by upstream connection limits. Which review control fits best?
Explanation
Correct Answer
Correlate client-side timestamps with warehouse queued and execution metrics. This reduces recurrence of: Application connection pools can limit work before Snowflake warehouse execution begins. The verification should demonstrate: Telemetry identifies the actual bottleneck; warehouse resizing is avoided when queries never enter the engine.
Incorrect Answers
Document data consistency separately from performance cache behavior. That safeguard is aimed at ANOTHER risk: Analysts assume moving a query to another warehouse duplicates cached results and changes the source table. It is less targeted than the control for: Application connection pools can limit work before Snowflake warehouse execution begins.
Test scheduled automation after warehouse property changes. That safeguard is aimed at ANOTHER risk: A team changes AUTO_RESUME to FALSE on a suspended report warehouse and then schedules automatic queries without explicit starts. It is less targeted than the control for: Application connection pools can limit work before Snowflake warehouse execution begins.
Review churn and retention policies for frequently updated large tables. That safeguard is aimed at ANOTHER risk: A storage report shows unexpected historical bytes after frequent updates to a large permanent table. It is less targeted than the control for: Application connection pools can limit work before Snowflake warehouse execution begins.