A data engineer is building a QuickSight dashboard to show company revenue across multiple AWS Regions. The visual should always display the total revenue for a Region regardless of the current drill-down level. Which QuickSight calculation accomplishes this?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a level-aware calculation - aggregate (LAC-A) function..
Why this is the answer
A level-aware calculation - aggregate (LAC-A) function is the correct choice because it allows you to perform aggregations at a specific level of detail, independent of the visual's current drill-down level. This ensures the total revenue for a Region is always displayed, even when other dimensions are drilled down. A simple calculated field performs calculations row-wise or based on the current visual context, which would change with drill-downs. A table calculation operates on the visual's displayed data after aggregation, making it dependent on the drill-down level. A LAC-W (window) function performs calculations over a specific window of rows within a partition, which is not designed for fixed-level aggregations across drill-downs.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed