SOL-C01 Question #296: Real Exam Question with Answer & Explanation

Question

You have a Snowflake Notebook that performs several complex data transformations. The notebook is taking longer than expected to run, and you need to optimize its performance. Which of the following actions would likely improve the notebook's execution speed the most?

Options

• AUpgrade the Snowflake virtual warehouse to a larger size while the notebook is running.
• BRe-order the notebook cells so that SQL cells are grouped together and Python cells are grouped
• CUse the `LIMIT clause in your SQL queries to only process a subset of the data during
• DExplicitly commit transactions after each SQL cell execution.
• EOptimize SQL queries for performance using techniques such as clustering, partitioning, and

Explanation

Options A and E are correct. Option A: Upgrading the warehouse size provides more resources (CPU, memory) for the notebook's computations. Option E: Optimized SQL queries are fundamental for performance in Snowflake; correct use of clustering, partitioning and efficient joins drastically reduces execution time. Option B has a minimal impact. Option C is only useful during development, not for production performance. Option D is unnecessary in most cases as Snowflake typically autocommits; explicitly committing will likely degrade performance, not

No community discussion yet for this question.