Question 340
A complex nightly transformation routinely spills to disk and needs more compute per individual query. What is the most appropriate next design or operational decision?
Explanation
Correct Answer
Scaling up adds resources to a cluster and can help a demanding single query. Success should be confirmed by this scenario-specific evidence: the representative transformation shows reduced spill or runtime at an acceptable cost.
Incorrect Answers
Iceberg tables use open table-format metadata and can integrate cloud storage with Snowflake query capabilities. In contrast, scaling up adds resources to a cluster and can help a demanding single query.
Name resolution depends on the current database and schema in the executing session. In contrast, scaling up adds resources to a cluster and can help a demanding single query.
Multi-cluster warehouse availability is edition-sensitive; higher compute demand alone does not add gated features to Standard Edition. In contrast, scaling up adds resources to a cluster and can help a demanding single query.





SnowPro Core COF-C03 Practice Tests