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

A retail company is expanding its operations globally. The company needs to use Amazon QuickSight to accurately calculate currency exchange rates for financial reports. The company has an existing dashboard that includes a visual that is based on an analysis of a dataset that contains global currency values and exchange rates.

A data engineer needs to ensure that exchange rates are calculated with a precision of four decimal places. The calculations must be precomputed. The data engineer must materialize results in QuickSight super-fast, parallel, in-memory calculation engine (SPICE).

Which solution will meet these requirements?

Answer options

• A. Define and create the calculated field in the dataset.
• B. Define and create the calculated field in the analysis.
• C. Define and create the calculated field in the visual.
• D. Define and create the calculated field in the dashboard.

Correct answer: A

Explanation

The correct answer is A because defining the calculated field in the dataset allows for the precision required and enables precomputation needed for SPICE. Options B, C, and D do not provide the same level of performance and precision since they pertain to the analysis, visual, or dashboard level, which do not support the needed precomputation effectively.