Which fact table type is best suited for tracking the current status of a business process that has a defined start and end, such as order fulfillment?

Accumulating snapshot fact table

In a star schema, how are dimension tables typically structured?

Denormalized, with each dimension stored as a single table containing all its descriptive attributes.

Partitioned by date with one table per month for each dimension.

Fully normalized into multiple related tables to eliminate redundancy.

Stored as views over operational source tables to avoid data duplication.

What is the primary purpose of dimension tables in a dimensional model?

To provide descriptive context and attributes that allow analysts to filter, group, and label fact data.

To hold the primary keys of fact tables for referential integrity.

To store raw transactional logs that are later transformed into facts.

To store the numeric measures that are aggregated in analytical queries.

A bank wants to analyze the total number of transactions and the total dollar amount per account per day. They also need to track the account balance at the end of each day. Which combination of fact tables is most appropriate?

A transactional fact table for transactions and a periodic snapshot fact table for daily balances

A single accumulating snapshot fact table for both transactions and balances

A single transactional fact table that includes both transactions and balances

A periodic snapshot fact table for transactions and a transactional fact table for balances

DatabricksCertified Data Engineer Professional

Domain 10Objective 4

Design Dimensional Models for Analytical Workloads, Ensuring Efficient Querying and Aggregation. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

Part of the Data Modeling domain, which accounts for 6% of the DATA-ENGINEER-PROFESSIONAL exam. Databricks does not publish an official question count, but from its 120-minute exam (~50–80 total, ~3–5 in this domain), expect 1–1 from this objective — we provide 24 practice questions to prepare you well beyond it. (estimate)

24questions here

5free pages

7concepts

6%of the exam

Questions 21–24

21foundation · easy
Which fact table type is best suited for tracking the current status of a business process that has a defined start and end, such as order fulfillment?
Select an answer first
22foundation · easy
In a star schema, how are dimension tables typically structured?
Select an answer first
23foundation · easy
What is the primary purpose of dimension tables in a dimensional model?
Select an answer first
24application · medium
A bank wants to analyze the total number of transactions and the total dollar amount per account per day. They also need to track the account balance at the end of each day. Which combination of fact tables is most appropriate?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DATA-ENGINEER-PROFESSIONAL

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-PROFESSIONAL” is a trademark of its owner, used for identification only.