Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Your Power BI semantic model contains a Sales fact table with OrderDateKey, ShipDateKey, and DueDateKey foreign keys. You must let report authors filter visuals by order date, ship date, or due date without increasing the model's storage footprint. What should you do to implement the required role-playing date dimensions?

  • Enable bidirectional cross-filtering on the existing date relationships and rely on visual-level filters to choose the required date context at runtime.

  • Create a single Date table, create one active and two inactive relationships from it to the three date key columns, and use CALCULATE with USERELATIONSHIP in measures to invoke the needed relationship.

  • Add three calculated date columns to the Sales table and apply DAX time-intelligence functions directly on those columns in visuals.

  • Create three duplicate copies of the Date table and relate each copy to one of the date key columns in Sales.

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