Interactive Sample

Dimensional Data Modeling & DAX Calculations

Test your mastery over DAX filter context manipulation:

Domain 2: Model the Data Sample Question 1 of 1

A data analyst needs to calculate Year-to-Date (YTD) sales within a star schema model that has a 'Sales' fact table and a validated 'Date' dimension table. Which DAX expression accurately computes the YTD cumulative total adhering to report date filter contexts?

A

TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])

B

SUMX(Sales, Sales[Amount] * 12)

C

CALCULATE(SUM(Sales[Amount]), ALL('Date'))

D

EARLIER(SUM(Sales[Amount]))

✓ Official Explanation: (A) The TOTALYTD function evaluates the specified sum expression across dates starting from the beginning of the year up to the latest date present in the current filter context, leveraging the continuous date column of the designated Date dimension table.

Practice more questions for free in the simulator →

Official Exam Blueprint

Domain Breakdown & Weighting

The simulator strictly replicates official exam domain distributions:

Domain 1: Prepare the Data

25-30%

Connecting to data sources, Power Query transformations (unpivot, merge, type casting), and leveraging Query Folding for data source performance.

Domain 2: Model the Data

25-30%

Star schema design, 1-to-many relationships, cross-filter direction, core DAX calculations (CALCULATE, FILTER, ALL), and date tables.

Domain 3: Visualize & Analyze Data

25-30%

Visual selection, Bookmarks and Drill-through navigation, custom tooltips, conditional formatting, and report accessibility standards.

Domain 4: Deploy & Maintain Assets

15-20%

Workspaces, Power BI Apps, scheduled dataset refreshes with on-premise gateways, Row-Level Security (RLS), and sensitivity labeling.

Transparent Pricing

Simulator Access Plans

One-time payment in USD. Instant access. No recurring subscription surprises.

Express Plan

Intensive final review

$21 / 30 days

Complete updated question bank
Timed full mocks (100 min)
Practice mode with instant rationales
Full web & mobile access

Recommended Plan

Optimal prep (90 days)

$42 / 90 days

Everything in Express Plan
90 days of full access
Unlimited mocks with weak-area analytics
Progress tracking & readiness score
Completion certificate with QR verification

Professional Plan

Long-term corporate mastery

$75 / 180 days

Everything in Recommended Plan
6 full months access and question updates
All future bank updates included
Priority student support

Want to test the simulator before buying?

Register in 1 click and take a free diagnostic mock exam with no credit card required.

Start Free Trial →