PL-300 practice questionsMicrosoft certification practice
← Interview & exam prep
Microsoft certification practice

PL-300 practice questions

12 exam-style questions for PL-300 — Power BI Data Analyst, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.

12 questionsBeginner 6 · Intermediate 6Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Beginner 6 questions

1In Power BI Desktop, where do you shape and clean data before it loads?

  1. The Power BI Service
  2. DAX editor
  3. Power Query Editor
  4. Report view
  5. Model view
Show answerHide answer

C · Power Query Editor Data transformation happens in the Power Query Editor before load.

2Where do you create a relationship between two tables in Power BI Desktop?

  1. Model view (Manage relationships)
  2. A slicer
  3. A DAX measure
  4. Bookmarks
  5. Power Query
Show answerHide answer

A · Model view (Manage relationships) Relationships are created and managed in Model view.

3For a total that recalculates when users filter with slicers, you build a…

  1. Measure
  2. Calculated column
  3. Group
  4. Calculated table
  5. Parameter
Show answerHide answer

A · Measure Measures respond to filter context; calculated columns are fixed at refresh.

4To limit which rows a given user can see in a report, you configure…

  1. A slicer
  2. A sensitivity label
  3. Object-level security only
  4. A bookmark
  5. Row-level security (RLS) roles
Show answerHide answer

E · Row-level security (RLS) roles RLS roles filter the data a user is allowed to see.

5To share a report so colleagues can consume it in the Service, you publish it to a…

  1. Local file
  2. Gateway
  3. Email attachment
  4. Workspace
  5. OneDrive folder
Show answerHide answer

D · Workspace Reports are published to a workspace in the Power BI Service.

6The visual best suited to a single value versus a target is a…

  1. Scatter chart
  2. Matrix
  3. Map
  4. Slicer
  5. KPI or card with a target
Show answerHide answer

E · KPI or card with a target KPI/card visuals surface one headline value against a goal.

Intermediate 6 questions

7To reduce model size and speed up a Power BI model, a good step is to…

  1. Remove unused columns and use a star schema with proper types
  2. Add more visuals per page
  3. Import every column just in case
  4. Add many calculated columns
  5. Disable relationships
Show answerHide answer

A · Remove unused columns and use a star schema with proper types Trim unused data and model as a star schema for performance.

8To let authors reuse a governed model instead of copying the PBIX, they should…

  1. Export to Excel
  2. Connect to a shared/certified semantic model
  3. Use a gateway
  4. Rebuild the model
  5. Screenshot the report
Show answerHide answer

B · Connect to a shared/certified semantic model Live-connect to a shared, endorsed semantic model.

9Incremental refresh in Power BI requires…

  1. A slicer
  2. Import mode with no parameters
  3. Publish to web
  4. RangeStart/RangeEnd parameters over a foldable source
  5. A calculated table
Show answerHide answer

D · RangeStart/RangeEnd parameters over a foldable source The RangeStart/RangeEnd datetime parameters define the refreshed partitions.

10To group ages into bands for analysis, you can create…

  1. A measure
  2. A bookmark
  3. A gateway
  4. A calculated column or a grouping/bin
  5. Row-level security
Show answerHide answer

D · A calculated column or a grouping/bin Binning/grouping or a calculated column creates the age bands.

11Deployment pipelines help a team…

  1. Promote content across Development, Test and Production
  2. Author visuals
  3. Publish to web
  4. Apply RLS
  5. Schedule refresh
Show answerHide answer

A · Promote content across Development, Test and Production Pipelines move content through Dev → Test → Prod stages.

12A DirectQuery report is slow. A valid tactic is to…

  1. Add calculated columns in the model
  2. Publish to web
  3. Add more slicers
  4. Do nothing
  5. Use aggregations and reduce the number of visuals/queries per page
Show answerHide answer

E · Use aggregations and reduce the number of visuals/queries per page Aggregations and fewer visual queries cut the load on the source.

What changed lately? Latest DAX news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More microsoft certification practice