AWS Certified Data Engineer – Associate (DEA-C01) — Question 181

A data engineer is using Amazon QuickSight to build a dashboard to report a company’s revenue in multiple AWS Regions. The data engineer wants the dashboard to display the total revenue for a Region, regardless of the drill-down levels shown in the visual.

Which solution will meet these requirements?

Answer options

• A. Create a table calculation.
• B. Create a simple calculated field.
• C. Create a level-aware calculation - aggregate (LAC-A) function.
• D. Create a level-aware calculation - window (LAC-W) function.

Correct answer: C

Explanation

The correct answer is C because the level-aware calculation - aggregate (LAC-A) function is specifically designed to calculate totals at a specified level of granularity, regardless of drill-downs. The other options, while they may perform calculations, do not provide the same capability to maintain the total across different levels of detail in the visual.