SOL-C01 · Question #305
SOL-C01 Question #305: Real Exam Question with Answer & Explanation
The correct answer is B: The code will execute successfully and display a scatter plot of 'sales' vs. 'profit', but any DML. Snowflake Notebooks allow data visualization using libraries like matplotlib, but these libraries are not preinstalled so they need to be installed first. The snowflake.connector is designed for data interaction and not the visualization itself, and a separate commit command is r
Question
You are using Snowflake Notebooks to create a visualization based on data retrieved from a Snowflake table. You have the following code in a cell:
Options
- AThe code will execute successfully, display a scatter plot of 'sales' vs. 'profit', and automatically
- BThe code will execute successfully and display a scatter plot of 'sales' vs. 'profit', but any DML
- CThe code will fail because the `snowflake.connector' library is not designed for data visualization
- DThe code will execute successfully and display a scatter plot, but the changes to the 'SALES
- EThe code will fail because the visualization libraries (e.g., matplotlib) are not pre-installed in
Explanation
Snowflake Notebooks allow data visualization using libraries like matplotlib, but these libraries are not preinstalled so they need to be installed first. The snowflake.connector is designed for data interaction and not the visualization itself, and a separate commit command is required to persist any DML changes to the database, therefore Option B and E is correct.
Topics
Community Discussion
No community discussion yet for this question.