Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer working on a data warehouse project, you are tasked with implementing a star schema that includes slowly changing dimensions (SCD). The project requires maintaining historical data accuracy for compliance reporting, while also ensuring the solution is scalable and cost-effective. Considering these requirements, which approach would you choose to handle SCD in this schema? (Choose one correct option)
A
Create a separate table for each dimension and update the records in these tables whenever there is a change, ensuring minimal storage costs.
B
Create a single table for all dimensions and use a flag to indicate whether a record is Type 1 or Type 2, simplifying data management.
C
Implement Type 1 SCD by overwriting the existing records with the new values whenever there is a change, to reduce complexity.
D
Implement Type 2 SCD by adding a new record for each change, including a timestamp and a status column to indicate the validity of the record, ensuring historical data integrity.