Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are designing a Power BI model with a FactSales table containing millions of rows and a DimProduct table containing 50 000 rows. The current relationship between FactSales[ProductKey] and DimProduct[ProductKey] is set to Many-to-Many with bi-directional filtering. Report users say that slicers by product category do not properly restrict FactSales values. You need to fix the model while avoiding unnecessary bi-directional filters or ambiguous paths. What should you do?

  • Change the relationship to Many-to-One and set the filter direction to Both.

  • Delete the existing relationship and recreate it using a bidirectional bridge table to connect the two tables.

  • Change the relationship to Many-to-One and keep the filter direction set to single (DimProduct filters FactSales).

  • Keep the Many-to-Many cardinality but change the filter direction to single.

Microsoft Power BI Data Analyst
Model the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot