Databricks Certified Data Engineer - Professional

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)