Question 220
A BI warehouse has many concurrently queued dashboards even though individual queries are already reasonably fast. After implementing the approach, which observation best demonstrates the required outcome?
Explanation
Correct Answer
Queue duration decreases as additional clusters serve peak dashboard requests. This demonstrates the outcome for the stated requirement rather than just a saved configuration.
Incorrect Answers
The account can configure the required multi-cluster scaling mode without an edition error. That measures a different outcome: an organization compares Snowflake editions before adopting a multi-cluster warehouse for a crowded BI workload. In this case, verify that queue duration decreases as additional clusters serve peak dashboard requests.
The UDF can be called in a SELECT expression and the procedure handles its control flow. That measures a different outcome: A SQL query requires a reusable scalar calculation while a maintenance workflow must execute several SQL statements. In this case, verify that queue duration decreases as additional clusters serve peak dashboard requests.
A CI job invokes the intended CLI command and records its deployment result. That measures a different outcome: an engineer wants to automate Snowflake project deployments from a version-controlled terminal workflow. In this case, verify that queue duration decreases as additional clusters serve peak dashboard requests.





SnowPro Core COF-C03 Practice Tests