DAA-C01 Question 205
Single answerPerform exploratory ad-hoc analyses using Notebooks and worksheets to describe dataA retail analytics team is investigating a sudden drop in weekly online revenue. An analyst needs to perform exploratory ad-hoc analysis in Snowflake, quickly profile the SALES table, compare trends by product category, and share the investigation with teammates who may want to rerun and extend the analysis. The analyst wants to combine SQL results with narrative comments and simple visualizations in a single interactive environment. Which Snowflake feature is the best fit for this requirement?
- A
Use a Snowflake Notebook so the analyst can run SQL in cells, add explanatory text, visualize result sets, and keep the exploratory workflow in one shareable document
- B
Use a standard worksheet only, because worksheets are the only Snowflake interface designed for ad-hoc SQL exploration and charting with team collaboration
- C
Create a dynamic table to automatically profile the SALES table and document findings for teammates in the same object
- D
Build a permanent semantic model first, because ad-hoc exploratory analysis in Snowflake requires a governed semantic layer before visualizing data
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use a Snowflake Notebook. In this scenario, the analyst needs an environment for exploratory ad-hoc analysis that supports SQL execution, descriptive commentary, visual output, and easy sharing so others can rerun or extend the work. Snowflake Notebooks are designed for this style of iterative analysis and documentation. Worksheets remain valuable for quick SQL queries and result inspection, but they are less aligned with the requirement to capture the full analytical narrative and workflow in a single interactive artifact. Dynamic tables are transformation objects rather than exploratory tools, and a semantic model is helpful for governed analytics but not required for descriptive ad-hoc investigation. This aligns with Snowflake best practices of using the right interface for the task: worksheets for quick query execution and notebooks for richer exploratory analysis, documentation, and collaboration.
- A. Correct.
Correct. Snowflake Notebooks are well suited for exploratory ad-hoc analysis because they let analysts combine executable cells, such as SQL, with markdown-style narrative and visual outputs in one interactive document. This supports profiling data, comparing trends, documenting findings, and sharing a repeatable investigation with teammates. The scenario specifically calls for combining analysis, comments, and visuals in a single environment, which aligns directly with Notebook capabilities.
- B. Incorrect.
Incorrect. Worksheets are useful for ad-hoc SQL analysis and can display results and basic charts, but the statement is too restrictive and inaccurate because worksheets are not the only Snowflake interface for ad-hoc exploration. The scenario also emphasizes combining narrative commentary, interactive analysis, and shareable investigative context in one document, which is a stronger match for Notebooks than a worksheet alone.
- C. Incorrect.
Incorrect. Dynamic tables are used for declarative pipeline-style data transformation and incremental refresh patterns, not for documenting exploratory analysis in an interactive, shareable notebook-style workflow. A dynamic table does not provide narrative cells, exploratory charting context, or collaborative investigation notes in the way the scenario requires.
- D. Incorrect.
Incorrect. A semantic model can be useful for governed business metrics and consistent definitions, but it is not a prerequisite for ad-hoc exploratory analysis in Snowflake. Requiring a semantic model first would add unnecessary setup and does not address the immediate need to quickly profile data, test hypotheses, and annotate findings during investigation.