DAA-C01 Question 267
Single answerCustomize data presentations using filtering and editing techniquesA data analyst is building a Snowsight dashboard for regional sales managers. The source worksheet returns detailed order-level data, including ORDER_DATE, REGION, SALES_REP, PRODUCT_CATEGORY, and REVENUE. Managers want a cleaner presentation that lets them quickly focus on their own region and current-quarter results without changing the underlying SQL each time they review the dashboard. Which approach best meets this requirement?
- A
Create dashboard filters for REGION and ORDER_DATE so viewers can interactively narrow the displayed results without editing the worksheet query.
- B
Duplicate the worksheet for each region and hard-code a WHERE clause in each SQL statement so managers only see their own region.
- C
Convert the worksheet into a static exported CSV and ask managers to filter the file locally in a spreadsheet application.
- D
Replace the detailed results with a single aggregated KPI tile, because dashboard viewers cannot filter tabular results interactively in Snowsight.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use dashboard filters in Snowsight. This approach supports interactive customization of data presentation while preserving a single underlying worksheet/query definition. It aligns with dashboard best practices: minimize duplicated logic, let consumers refine views through filters, and keep transformations or business logic in the query while using the dashboard layer for presentation and exploration. Snowflake Snowsight documentation describes dashboards and filters as tools for enabling consumers to narrow and customize displayed results without rewriting SQL. This makes dashboard filters the most practical and maintainable solution for filtering and editing how data is presented.
- A. Correct.
Correct. In Snowsight, dashboard filters are designed to customize how data is presented to viewers without requiring them to modify the underlying SQL. Applying filters such as REGION and ORDER_DATE allows regional managers to interactively refine what is shown, which is exactly the requirement in this scenario: cleaner presentation, reusable dashboard design, and no need to edit the query each time.
- B. Incorrect.
Incorrect. Although duplicating worksheets with hard-coded WHERE clauses could technically produce region-specific views, it does not scale well and creates unnecessary maintenance overhead. It also fails the stated requirement to avoid changing or managing separate SQL definitions for each review scenario. This is a common misconception when users rely on query duplication instead of presentation-layer filtering.
- C. Incorrect.
Incorrect. Exporting to CSV removes the interactivity and governance benefits of Snowsight dashboards. It shifts filtering responsibility outside Snowflake and creates version-control and usability issues. While spreadsheet filtering is possible, it is not the best approach for customizing data presentation within Snowflake for business users.
- D. Incorrect.
Incorrect. Snowsight dashboards support interactive filtering, including filtering content displayed to viewers. Replacing detailed results with a single KPI tile would reduce analytical usefulness and does not address the requirement to let managers focus on region and current-quarter records in the presented data.