A retailer is expanding globally and needs Amazon QuickSight to compute currency exchange rates for financial reports with four-decimal precision. The calculations must be precomputed and stored in SPICE for fast, parallel, in-memory access. Where should the engineer define the calculated field to satisfy these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Define and create the calculated field in the dataset..
Why this is the answer
Defining the calculated field in the dataset ensures that the currency exchange rate calculations are precomputed and stored in SPICE. This allows for fast, parallel, in-memory access across all analyses, visuals, and dashboards that use this dataset, meeting the performance and precision requirements. If the calculation were defined in the analysis, visual, or dashboard, it would be computed at query time for that specific context, not precomputed and stored in SPICE, which would negate the performance benefits and might lead to inconsistent results across different reports.
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