AWS Certified Data Analytics – Specialty — Question 118

A media company is using Amazon QuickSight dashboards to visualize its national sales data. The dashboard is using a dataset with these fields: ID, date, time_zone, city, state, country, longitude, latitude, sales_volume, and number_of_items.
To modify ongoing campaigns, the company wants an interactive and intuitive visualization of which states across the country recorded a significantly lower sales volume compared to the national average.
Which addition to the company's QuickSight dashboard will meet this requirement?

Answer options

• A. A geospatial color-coded chart of sales volume data across the country.
• B. A pivot table of sales volume data summed up at the state level.
• C. A drill-down layer for state-level sales volume data.
• D. A drill through to other dashboards containing state-level sales volume data.

Correct answer: A

Explanation

The correct option is A because a geospatial color-coded chart visually represents sales volume variations across different states, making it easy to identify low-performing areas. Options B and C provide different forms of data representation but do not offer the same visual impact needed for immediate insights. Option D involves navigating to other dashboards, which is less efficient for the requirement of quick identification of states with lower sales volumes.