DEA-C01 Question #172: Real Exam Question with Answer & Explanation

Question

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?

Options

• ADefine and create the calculated field in the dataset.
• BDefine and create the calculated field in the analysis.
• CDefine and create the calculated field in the visual.
• DDefine and create the calculated field in the dashboard.

Explanation

Defining and creating the calculated field in the dataset ensures that the exchange rate calculations are precomputed before being stored in SPICE (QuickSight's super-fast, parallel, in- memory calculation engine). This allows the calculation to be materialized and reused across different analyses and visuals, ensuring that the precision is maintained and the performance is Creating the calculated field in the analysis would compute the result at the analysis level, not within the dataset. This approach doesn't guarantee precomputation within SPICE and may increase the calculation overhead for each analysis. Defining the field in the visual means the calculation is performed dynamically every time the visual is rendered, which does not leverage SPICE's precomputation benefits and can result in slower performance. Creating the calculated field at the dashboard level is similar to doing it at the visual level, meaning the calculations are not precomputed and stored in SPICE, leading to potential performance issues and less reuse of the calculation across different analyses or visuals.

No community discussion yet for this question.