Power BI 778 Data Modeling in Power BI

Question 1

What type of schema uses a single fact table connected to multiple dimension tables in Power BI?

Accepted Answer

Star schema

Answer

A star schema uses one central fact table directly connected to dimension tables, optimizing query performance in Power BI.

Question 2

Which cardinality setting should you use when one row in Table A matches exactly one row in Table B?

Accepted Answer

One-to-one

Answer

A one-to-one relationship means each row in Table A has exactly one corresponding row in Table B.

Question 3

What is the default storage mode for tables in Power BI Desktop?

Accepted Answer

Import

Answer

Import mode is the default storage mode, which loads data into Power BI's in-memory engine (VertiPaq).

Question 4

In Power BI, which relationship filter direction allows filters to propagate in both directions between two tables?

Accepted Answer

Bidirectional

Answer

Bidirectional cross-filter direction allows filters to flow from either table to the other in a relationship.

Question 5

What tool in Power BI Desktop helps you visualize all table relationships at once?

Accepted Answer

Model view

Answer

Model view displays all tables and their relationships visually, allowing you to manage the data model.

Power BI 778 Practice Test