
Ultimate access to all questions.
You are designing a semantic model for a financial services company that requires a robust star schema implementation. Describe the steps you would take to ensure the star schema is optimized for query performance and data integrity, including the handling of slowly changing dimensions.
A
Implement a star schema without considering slowly changing dimensions.
B
Design the star schema focusing only on query performance.
C
Balance the design between query performance and data integrity, including strategies for managing slowly changing dimensions.
D
Ignore data integrity to prioritize query performance.