Question 310
A team's unrelated ad-hoc notebooks repeatedly compete with a critical production API's queries. What is the most appropriate next design or operational decision?
Explanation
Correct Answer
Separate warehouses provide compute isolation and independent concurrency controls over shared data. Success should be confirmed by this scenario-specific evidence: notebook spikes no longer appear as API query queuing on the production warehouse.
Incorrect Answers
Metadata about partitions and objects helps the service plan work without reading every data byte. In contrast, separate warehouses provide compute isolation and independent concurrency controls over shared data.
Clustering can reduce partition overlap and improve pruning for consistent selective predicates. In contrast, separate warehouses provide compute isolation and independent concurrency controls over shared data.
Result-cache reuse can hide the cost of operators the team is trying to optimize. In contrast, separate warehouses provide compute isolation and independent concurrency controls over shared data.





SnowPro Core COF-C03 Practice Tests