Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are modeling a sales dataset in Power BI. The Sales fact table contains three date columns: OrderDate, ShipDate, and ReturnDate. Report creators must be able to build slicers and visuals for each of these dates without writing any DAX or switching relationships manually. To implement a role-playing date dimension while keeping refresh time and storage use low, what should you do?

  • Keep a single Date table and create a calculation group to let authors switch the date context between Order, Ship, and Return roles.

  • Add three reference copies of the Date table in Power Query, name them Order Date, Ship Date, and Return Date, and link each copy with an active relationship to its corresponding date column in Sales.

  • Create one Date table and manually change which relationship is active before authors build each report.

  • Create one Date table and set up three relationships to the Sales table, leaving two inactive; instruct authors to use the USERELATIONSHIP function in their measures.

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