Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are designing a Power BI semantic model that contains a Sales fact table with two date keys: OrderDateKey and ShipDateKey. Report authors must be able to build visuals that simultaneously compare order volume by order date and shipping performance by ship date, without writing custom DAX to activate relationships. Row-level security will also be applied. Which modeling approach should you implement?

  • Duplicate the Date table so there is a Date table and a Ship Date table, and create an active one-to-many relationship from each table to its corresponding date key in Sales.

  • Create a many-to-many relationship between the Date table and the Sales table, with cross-filter direction set to Both.

  • Create two inactive relationships from the existing Date table to the Sales table and require measures to use USERELATIONSHIP when needed.

  • Keep a single active relationship on OrderDateKey and set its cross-filter direction to Both so it implicitly filters ShipDateKey.

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