← 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
Beginner 6 questions
1In Power BI Desktop, where do you shape and clean data before it loads?
- The Power BI Service
- DAX editor
- Power Query Editor
- Report view
- 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?
- Model view (Manage relationships)
- A slicer
- A DAX measure
- Bookmarks
- 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…
- Measure
- Calculated column
- Group
- Calculated table
- 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…
- A slicer
- A sensitivity label
- Object-level security only
- A bookmark
- 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…
- Local file
- Gateway
- Email attachment
- Workspace
- 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…
- Scatter chart
- Matrix
- Map
- Slicer
- 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…
- Remove unused columns and use a star schema with proper types
- Add more visuals per page
- Import every column just in case
- Add many calculated columns
- 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…
- Export to Excel
- Connect to a shared/certified semantic model
- Use a gateway
- Rebuild the model
- 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…
- A slicer
- Import mode with no parameters
- Publish to web
- RangeStart/RangeEnd parameters over a foldable source
- 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…
- A measure
- A bookmark
- A gateway
- A calculated column or a grouping/bin
- 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…
- Promote content across Development, Test and Production
- Author visuals
- Publish to web
- Apply RLS
- 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…
- Add calculated columns in the model
- Publish to web
- Add more slicers
- Do nothing
- 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 →
More microsoft certification practice