In a star schema for a sales analysis, the sales fact table contains a `product_id` foreign key. Analysts want to filter by product category and brand. Where should this information be stored?

In a separate fact table for product attributes

In the sales fact table as additional columns

A logistics company tracks shipments. Each shipment can have multiple packages, and each package has a weight and delivery status. Analysts need to calculate total weight per shipment and per route. Which fact table grain should they choose?

One row per package, with shipment and route as foreign keys

One row per route, with total weight aggregated

One row per delivery status, with count of packages

One row per shipment, with total weight and route as attributes

A financial services company needs to load data from multiple source systems into a data warehouse. They require full auditability of historical changes and the ability to add new source systems without redesigning existing tables. Which modeling approach best fits these requirements?

A single fact table with all measures and dimensions

Data vault schema with hubs, links, and satellites

Star schema with conformed dimensions

Snowflake schema with normalized dimensions

What is the primary role of dimension tables in a star schema?

To store historical snapshots of all measures.

To enforce referential integrity between fact tables.

To provide descriptive context and attributes for the facts.

To store quantitative measures for analysis.

Which schema is generally best for query performance in analytical workloads?

All schemas perform equally well.

DatabricksCertified Data Analyst Associate

Domain 8Objective 1

Apply Industry-Standard Data Modeling Techniques, Such as Star, Snowflake, and Data Vault Schemas, to Analytical Workloads. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

Part of the Section 8: Data Modeling with Databricks SQL domain, which makes up ~5% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~2–3 in this domain), expect 1–2 from this objective — we provide 21 practice questions to prepare you well beyond it. (estimate)

21questions here

5free pages

7concepts

Questions 11–15

11application · medium
In a star schema for a sales analysis, the sales fact table contains a `product_id` foreign key. Analysts want to filter by product category and brand. Where should this information be stored?
Select an answer first
12application · medium
A logistics company tracks shipments. Each shipment can have multiple packages, and each package has a weight and delivery status. Analysts need to calculate total weight per shipment and per route. Which fact table grain should they choose?
Select an answer first
13application · medium
A financial services company needs to load data from multiple source systems into a data warehouse. They require full auditability of historical changes and the ability to add new source systems without redesigning existing tables. Which modeling approach best fits these requirements?
Select an answer first
14foundation · easy
What is the primary role of dimension tables in a star schema?
Select an answer first
15foundation · easy
Which schema is generally best for query performance in analytical workloads?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

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-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.