Câu 9: C-HAMOD-2404: SAP Certified Associate - Data Engineer - SAP HANA

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?

1. A. Combine the transaction tables using an aggregation node in a CUBE calculation view. Use a star join node to join the DIMENSIONS to the resulting fact table fact table. — đáp án hiện tại
2. B. Combine the transaction tables using a join node in a CUBE calculation view. Use a star join node to join the DIMENSIONS to the resulting fact table.
3. C. Combine the transaction tables using a join node in a CUBE calculation view.Combine the DIMENSIONS using another join node. Use a star join node to combine both resulting fact and dimension tables.
4. D. Combine the transaction tables using a star join node in a CUBE calculation view. Use a join node to join the DIMENSIONS to the resulting fact table.