Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following statements about fact tables and dimension tables are true?
Select two responses.
A
Transactional guarantees and Delta Lake ensure that the newest version of a dimension table will be referenced each time a query is processed for incremental workloads.
B
Joined data cannot go unmatched because of Delta Lake's foreign key constraint.
C
Dimension tables contain a granular record of activities, while fact tables contain data that is updated or modified over time.
D
Modern guidelines suggest de-normalizing dimension and fact tables.
