Snowflake
SOL-C01 · Question #296
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 a
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #296. The question stem and answer options stay visible for context.
Querying and Performance
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
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Snowflake Notebooks#Performance Tuning#Virtual Warehouse Sizing#SQL Optimization