Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

You are building a Power BI data model that includes a FactSales table. Report users want a card visual that always shows the total sales amount based on the filters or slicers they apply at run time. Which data-modeling feature should you create to satisfy this requirement?

  • A calculated column that stores the SalesAmount total

  • An additional relationship between FactSales and the Date table

  • A measure that sums the SalesAmount column

  • A calculated table that aggregates sales by date

Microsoft Azure Data Fundamentals DP-900
Describe an analytics workload
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