ADA-C01 Question 278
Single answerVisualize query results with SnowsightA Snowflake administrator is helping a finance team use Snowsight to review monthly warehouse spend. The team runs a query that returns three columns: MONTH_NAME, WAREHOUSE_NAME, and TOTAL_CREDITS. They want to quickly compare credit consumption trends across months for each warehouse directly in Snowsight without exporting the data. Which Snowsight visualization should the administrator recommend to best meet this requirement?
- A
Use a line chart with MONTH_NAME on the x-axis, TOTAL_CREDITS on the y-axis, and WAREHOUSE_NAME as the series grouping
- B
Use a KPI visualization because it is designed to compare multiple warehouses across time in one view
- C
Use a data preview only, because Snowsight does not support charting SQL query results directly
- D
Use a scatter plot with MONTH_NAME on the x-axis and WAREHOUSE_NAME on the y-axis, because categorical comparisons are best shown without a numeric measure
Show answer and explanation
Correct answer: A
Explanation
The best answer is the line chart because the scenario requires trend analysis over time for multiple warehouse groups. Snowsight supports visualizing query results directly, and administrators commonly guide users toward choosing chart types that match the shape of the data and the business question. For time-series analysis, line charts are typically the most effective when the result set includes a time dimension, a measure, and a grouping dimension. In Snowflake documentation for Snowsight worksheets and dashboards, charting query results is a supported workflow, allowing users to explore and present SQL results visually without external BI tools for basic use cases.
- A. Correct.
Correct. In Snowsight, query results can be visualized directly using charts. For a time-based comparison of a numeric measure across multiple categories, a line chart is the most appropriate choice. MONTH_NAME provides the time dimension, TOTAL_CREDITS is the quantitative metric, and WAREHOUSE_NAME can be used as separate series so the finance team can compare trends for each warehouse over time.
- B. Incorrect.
Incorrect. A KPI visualization is intended to emphasize one or a small number of headline values, not to show trends across multiple months and multiple warehouses. This option reflects a common misunderstanding that KPI tiles can replace trend analysis charts.
- C. Incorrect.
Incorrect. Snowsight does support visualizing query results directly from worksheets and dashboards. Users can create charts such as line, bar, and other visualizations from SQL output without exporting the data first. This option is based on an outdated or incorrect assumption about Snowsight capabilities.
- D. Incorrect.
Incorrect. A scatter plot is generally used to analyze relationships between numeric variables. Here, the goal is to show a numeric metric over time and compare category-based trends. Using WAREHOUSE_NAME on an axis without properly emphasizing TOTAL_CREDITS would not meet the finance team's requirement.