Module quiz: Concepts for data modeling :Data Modeling in Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Considering the nature of Fact tables, which type of data is most suitable for placement in a Fact table?

❌ Product Categories
✅ Sales Revenue
❌ Customer Information

Explanation:
Fact tables store quantitative, measurable data such as sales, revenue, and quantities. Product categories and customer information belong to dimension tables.

Question 2

How would you define data granularity?

❌ A filter direction associated with table relationships
❌ The nature of the relationship between two tables
✅ The level of detail that is represented in the dataset

Explanation:
Data granularity refers to how detailed or summarized the data is (for example, daily vs monthly sales).

Question 3

Each product can be stored in multiple warehouses, and each warehouse can have multiple products. What type of relationship exists?

❌ One-to-one
✅ Many-to-many
❌ One-to-many

Explanation:
When multiple records in both tables can relate to each other, the relationship is many-to-many.

Question 4

True or False: Fact tables in Power BI are denormalized to optimize query performance.

❌ True
✅ False

Explanation:
Dimension tables are typically denormalized. Fact tables usually contain transactional data with foreign keys.

Question 5

When establishing relationships between tables in Power BI, what can be used as the basis?
(Select all that apply)

✅ Unique identifiers
✅ Common fields or columns
✅ Primary keys and foreign keys

Explanation:
Relationships are built using matching keys or common columns between tables.

Question 6

Each ticket is assigned to one agent, and each agent can handle multiple tickets. What cross-filter direction should you select?

❌ None
❌ Both
✅ Single

Explanation:
A Single cross-filter direction (from dimension to fact) is recommended for performance and clarity.

Question 7

What is the impact of selecting the Both cross-filter direction?

✅ Filters applied to either table affect the other table
❌ A filter affects only one table
❌ Filters do not affect either table

Explanation:
With Both, filters flow in both directions between related tables.

Question 8

Which of the following is not a component of a Star schema?

❌ A denormalized table
❌ A Fact table
✅ A dimension table

Explanation:
A Star schema consists of one fact table and multiple dimension tables.
(Here, “a denormalized table” is incorrect because dimension tables are denormalized.)

Question 9

Which of the following are examples of dimension tables?
(Select all that apply)

❌ Sales
✅ Product
✅ Employees
✅ Customer

Explanation:
Dimension tables store descriptive attributes, while Sales is a fact table.

Question 10

Which tools can be used to configure table and column properties in Power BI?
(Select all that apply)

✅ Power BI Properties pane (Model view)
✅ Power Query Editor
❌ Power BI Visualization pane

Explanation:
Table and column properties are configured in Model view and Power Query, not in the Visualization pane.

🧾 Summary Table