Answer-first summary for fast verification
Answer: 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.
Type 2 SCD is the most suitable approach for this scenario as it allows for tracking the history of changes over time without losing historical data, which is crucial for compliance reporting. By adding a new record for each change and including a timestamp and status column, you can maintain a comprehensive historical record of the data. This method supports scalability and ensures data integrity, making it the best choice for projects requiring detailed historical data tracking.
Author: LeetQuiz Editorial Team
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.
No comments yet.