Answer: 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., Modern guidelines suggest de-normalizing dimension and fact tables.

## Explanation **Correct Answers: A and D** **Option A is correct** because Delta Lake's transactional guarantees ensure that when processing incremental workloads, queries will always reference the latest version of dimension tables, maintaining data consistency and freshness. **Option D is correct** because modern data warehousing guidelines do indeed suggest de-normalizing dimension and fact tables to improve query performance and simplify data models, especially in data lakehouse architectures. **Option B is incorrect** because Delta Lake does not enforce foreign key constraints like traditional relational databases. Joined data can potentially go unmatched if referential integrity is not maintained through other means. **Option C is incorrect** because this statement reverses the standard definitions: - **Fact tables** contain granular records of activities/transactions (e.g., sales transactions) - **Dimension tables** contain descriptive attributes that are updated or modified over time (e.g., customer information, product details)

Author: LeetQuiz .