Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

Your Power BI data model includes a Date table with separate Year, Quarter, Month, and Day columns. Report users want to drill down from yearly totals to specific days within a single column chart, without manually adding columns in the visual. Which data-modeling feature should you configure to meet this requirement?

  • Apply row-level security based on the Date table

  • Write a DAX measure to return totals at different date levels

  • Create a hierarchy that contains the Year, Quarter, Month, and Day columns

  • Define a calculated column that concatenates Year, Quarter, Month, and Day

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