Analytics, Business Intelligence Platform, DP-900, Microsoft Certification, Power BI, Power Query

Practice Questions: Describe features of data models in Power BI (DP-900 Exam Prep)

Practice Questions

Question 1

What is the primary purpose of a data model in Power BI?

A. To store raw files
B. To define relationships and enable data analysis
C. To manage network connections
D. To create dashboards only

✅ Answer: B

Explanation:
A data model organizes data and defines relationships and calculations for analysis.

Question 2

Which component connects tables together in a Power BI data model?

A. Measures
B. Relationships
C. Dashboards
D. Queries

✅ Answer: B

Explanation:
Relationships define how tables interact and allow filtering across them.

Question 3

Which type of relationship is MOST common in Power BI models?

A. Many-to-many
B. One-to-many
C. One-to-one
D. No relationship

✅ Answer: B

Explanation:
The one-to-many (1:*) relationship is the most common in analytical models.

Question 4

In a star schema, which table typically contains numeric values used for analysis?

A. Dimension table
B. Lookup table
C. Fact table
D. Bridge table

✅ Answer: C

Explanation:
Fact tables store measurable data (e.g., sales, revenue).

Question 5

What is the role of a dimension table in a data model?

A. Store raw transaction data
B. Store aggregated values only
C. Provide descriptive attributes for filtering and grouping
D. Execute calculations

✅ Answer: C

Explanation:
Dimension tables contain descriptive data like customer or product details.

Question 6

Which type of calculation is evaluated at query time in Power BI?

A. Calculated column
B. Measure
C. Table relationship
D. Data type

✅ Answer: B

Explanation:
Measures are calculated dynamically during query execution.

Question 7

Which language is used to create measures and calculated columns in Power BI?

A. SQL
B. Python
C. DAX
D. Java

✅ Answer: C

Explanation:
DAX (Data Analysis Expressions) is used for calculations in Power BI.

Question 8

What is the benefit of using a star schema in Power BI?

A. Increased data duplication
B. Simplified relationships and improved performance
C. Elimination of fact tables
D. Reduced data types

✅ Answer: B

Explanation:
Star schema improves performance and usability by simplifying relationships.

Question 9

What happens when you create a relationship between two tables?

A. Data is duplicated
B. Tables are merged into one
C. Filters can propagate between tables
D. Data types are changed

✅ Answer: C

Explanation:
Relationships allow filtering across related tables.

Question 10

Which feature allows users to drill down through levels such as Year → Month → Day?

A. Measures
B. Hierarchies
C. Relationships
D. Dashboards

✅ Answer: B

Explanation:
Hierarchies enable drill-down analysis in reports.

✅ Quick Exam Takeaways

✔ Data model components:

  • Tables
  • Relationships
  • Measures & calculated columns

✔ Key concepts:

  • Fact table → numeric data
  • Dimension table → descriptive data
  • Relationships → connect tables

✔ Calculations:

  • Measures → dynamic
  • Calculated columns → stored

✔ Design best practice:

  • Use star schema

✔ Exam tip:
👉 Measure = calculated at query time
👉 Calculated column = stored in table
👉 Fact = numbers, Dimension = descriptions

Go to the DP-900 Exam Prep Hub main page.

Leave a comment