SOL-C01 · Question #253
A data engineer is using Snowflake Notebooks to perform exploratory data analysis on a large dataset stored in a Snowflake table called 'ORDERS. They want to calculate the total order amount per day a
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #253. The question stem and answer options stay visible for context.
Question
A data engineer is using Snowflake Notebooks to perform exploratory data analysis on a large dataset stored in a Snowflake table called 'ORDERS. They want to calculate the total order amount per day and visualize the results as a line chart directly within the notebook. Which sequence of actions represents the MOST efficient and correct way to achieve this?
Options
- AWrite a SQL query within the notebook to calculate the total order amount per day, store the result
- BExport the 'ORDERS' table as a CSV file, load it into a separate Python environment, perform the
- CUse the SnowflakeUIto create a view that calculates the total order amount per day, then import
- DWrite a Javascript function within the Snowflake Notebook to fetch the data using fetch API and
- ECreate a stored procedure in Snowflake that calculates the total order amount per day and returns
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.