In a dimensional model, which statement correctly describes the role of a fact table?

It stores only aggregated data and cannot contain foreign keys to other tables.

It is used to store slowly changing dimension attributes for historical tracking.

It contains the quantitative measures and foreign keys that link to dimension tables, representing business events.

It stores descriptive attributes about business entities such as customers and products.

Why are aggregate tables commonly created in a dimensional model?

To enforce referential integrity between fact and dimension tables.

To store raw transactional data for detailed analysis.

To pre-compute summaries at higher levels of granularity to speed up common queries.

To replace the need for dimension tables in queries.

A large fact table in a Databricks lakehouse is frequently filtered by a 'sale_date' column and joined to a 'product' dimension. Queries that filter on a specific date range are slow. Which optimization is most effective for this scenario?

Partition the fact table by sale_date

Bucket the fact table by product_id

Increase the number of worker nodes only for the dimension table

Create a view that selects all columns

What does the 'grain' of a fact table represent?

The frequency at which the fact table is refreshed.

The physical size of the fact table in bytes.

The level of detail captured by each row in the fact table.

The number of foreign keys in the fact table.

DatabricksCertified Data Engineer Professional

Domain 10Objective 4

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

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 16–20

16foundation · easy
In a dimensional model, which statement correctly describes the role of a fact table?
Select an answer first
17foundation · easy
Why are aggregate tables commonly created in a dimensional model?
Select an answer first
18application · medium
A large fact table in a Databricks lakehouse is frequently filtered by a 'sale_date' column and joined to a 'product' dimension. Queries that filter on a specific date range are slow. Which optimization is most effective for this scenario?
Select an answer first
19application · medium
A company's product dimension includes a 'category' attribute that occasionally changes. Analysts need to report historical sales by the category that was current at the time of the sale. Which slowly changing dimension (SCD) type should be used for the category attribute?
Select an answer first
20foundation · easy
What does the 'grain' of a fact table represent?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.