Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When dealing with complex data relationships in a lakehouse, which entity-relationship model optimally supports both analytical queries and transactional updates?
A
A snowflake schema that balances normalization with query performance.
B
A flat table structure that replicates data across multiple dimensions for fast reads.
C
A fully normalized model to ensure data integrity and support transactional updates.
D
A denormalized model that reduces the need for joins during analytical queries.
