ADA-C01 Question 279
Single answerVisualize query results with SnowsightA data platform administrator is helping finance analysts use Snowsight to review monthly cloud spending. The analysts run a SQL query that returns three columns: BILLING_MONTH, SERVICE_TYPE, and TOTAL_COST. They want to quickly compare costs by service across months without exporting the results. Which Snowsight visualization should the administrator recommend to best support this requirement?
- A
Create a bar chart using BILLING_MONTH as the category, SERVICE_TYPE as the series, and TOTAL_COST as the value
- B
Create a scorecard visualization using TOTAL_COST only, because scorecards are best for comparing trends across multiple months and services
- C
Create a detail view, because Snowsight detail visualizations automatically show grouped comparisons by month and service
- D
Create a line chart using TOTAL_COST as the category and BILLING_MONTH as the value, because Snowsight infers the service breakdown automatically
Show answer and explanation
Correct answer: A
Explanation
In Snowsight, query results can be visualized directly as charts and other visual formats, which is useful for exploratory analysis and operational reporting without leaving the worksheet. For a result set containing a time-related category, a grouping dimension, and a numeric measure, a bar chart is a strong choice when the goal is side-by-side comparison across categories. Here, BILLING_MONTH serves as the category, SERVICE_TYPE as the series, and TOTAL_COST as the aggregated value. This aligns with Snowsight best practices for visualizing grouped comparisons. Scorecards are better suited for single KPI-style metrics, while detail views are tabular rather than comparative visualizations. Candidates should know how to select an appropriate Snowsight visualization based on the shape of the query result and the business question being asked.
- A. Correct.
Correct. A bar chart is an appropriate Snowsight visualization for comparing aggregated values across categories and subcategories. In this scenario, BILLING_MONTH is the primary category on one axis, SERVICE_TYPE is the grouping or series, and TOTAL_COST is the numeric measure. This lets analysts compare costs by service within each month directly in Snowsight without exporting data.
- B. Incorrect.
Incorrect. A scorecard is designed to highlight one or a small number of key metrics, not to compare multiple categories and grouped series over time. Using only TOTAL_COST would collapse the dimensional breakdown and would not help analysts compare SERVICE_TYPE across BILLING_MONTH values.
- C. Incorrect.
Incorrect. A detail view displays tabular query results and can be useful for inspection, but it does not provide the visual grouped comparison the analysts asked for. Choosing a table-like display instead of a chart is a common mistake when the requirement is to compare categories quickly.
- D. Incorrect.
Incorrect. In Snowsight charting, the numeric measure should be used as the value, not as the category axis. Also, Snowsight does not automatically infer a service breakdown if fields are assigned incorrectly. This option reverses the expected roles of dimensions and measures, producing an ineffective or invalid visualization.