Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
As a Microsoft Azure Data Engineer Associate, you are responsible for designing a data warehouse solution in Azure Synapse Analytics. What are some of the best practices to consider when designing a data warehouse schema?
A
Use a star or snowflake schema to optimize query performance and simplify data relationships.
B
Normalize the data to reduce data redundancy and improve data integrity.
C
Denormalize the data to improve query performance and reduce the complexity of joins.
D
All of the above.
