Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.