Home Simulators Courses Free Trial Contact Aula Virtual
⚡ PL-300 EXAM • MICROSOFT POWER BI DATA ANALYST

Power BI Data Analyst
(PL-300) Exam Simulator

Transform enterprise data into actionable business insight: dimensional star schema modeling, advanced DAX formulas, Row-Level Security (RLS), and Power BI Service governance.

View Plans from $21 USD Try Free Demo
500+ PL-300 Questions
700 / 1000 Passing Score
100 min 55-Question Mock
14 Days 14-Day free trial
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

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 →