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

Snowflake schema

Answer

Galaxy schema

Answer

Flat schema

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

Many-to-many

Answer

One-to-many

Answer

Many-to-one

Question 3

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

Accepted Answer

Import

Answer

DirectQuery

Answer

Live Connection

Answer

Dual

Question 4

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

Accepted Answer

Bidirectional

Answer

Single

Answer

Unidirectional

Answer

Cross-filter

Question 5

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

Accepted Answer

Model view

Answer

Data view

Answer

Report view

Answer

Query editor

Question 6

Which storage mode in Power BI sends queries directly to the source database without caching data?

Accepted Answer

DirectQuery

Answer

Import

Answer

Dual

Answer

Composite