Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Which of the following statements about fact tables and dimension tables are true?
Select two responses.
Exam-Like
Community
LLeetQuiz
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.
Explanation:
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)
Comments
Loading comments...