Associate-level certification covering preparing, modeling, visualizing, and analyzing data and deploying assets in Microsoft Power BI, with a worked explanation on every practice question.
Free sample questions
No account needed. Every question has a worked explanation, just like the full bank.
lock_openFree samplePrepare the Datamedium
An analyst uses Power BI dataflows in the service and also Power Query in Power BI Desktop. The Power Query Online experience and Power Query for Desktop expose almost the same user experience for shaping data in every scenario. Is this statement correct?
- AYescheck_circle Correct
- BNo
Power Query Online and Power Query Desktop deliver almost the same user experience for shaping data. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why A is correct: Correct. The Power Query overview explicitly notes that although two Power Query experiences exist, Online and Desktop, both provide almost the same user experience in every scenario.
Why B is wrong: The two experiences differ in a few features, such as fuzzy grouping being Online-only and Percentile and Count distinct values aggregations being Online-only, but the overall ribbon-driven shaping experience is parity-matched.
lock_openFree samplePrepare the Dataeasy
A report author wants Automatic Page Refresh on a page that uses an Import semantic model. Automatic Page Refresh in Power BI is supported on Import-mode pages. Is this statement correct?
- AYes
- BNocheck_circle Correct
Automatic Page Refresh works only on DirectQuery data sources, not Import. The documentation states Automatic Page Refresh is only available for DirectQuery data sources; the minimum refresh interval depends on workspace type and capacity admin settings.
Why A is wrong: Answering 'Yes' would be incorrect; per the documented behaviour, the keyed answer above is the only consistent reading of the scenario.
Why B is correct: Correct. The documentation states Automatic Page Refresh is only available for DirectQuery data sources; the minimum refresh interval depends on workspace type and capacity admin settings.
lock_openFree samplePrepare the Datamedium
An analyst wants to group sales rows by both Country and Sales Channel and produce a Sum of Units. The Group by dialog opens in Basic mode by default. Which step exposes the option to select multiple grouping columns at once?
- ASwitch the Group by dialog from Basic to Advanced, then use Add grouping to add the second column.check_circle Correct
- BOpen the Group by dialog twice in sequence, picking Country the first time and Sales Channel the second time.
- CHold the Ctrl key while selecting both column headings before clicking Group by on the Home tab.
- DUse the All rows operation, which automatically groups by every selected column in the table preview.
The Advanced option in Group by allows multiple grouping columns and multiple aggregations in one step. The Group by article walks through the multi-column case by switching the dialog to Advanced and using Add grouping to add Sales Channel after Country. Advanced mode exposes the multi-column grouping workflow.
Why A is correct: Correct. The Group by article walks through the multi-column case by switching the dialog to Advanced and using Add grouping to add Sales Channel after Country.
Why B is wrong: Each Group by step replaces the previous grouping. Running the dialog twice produces nested aggregations that do not match a single grouping on both columns.
Why C is wrong: Ctrl-select picks multiple columns but the dialog still opens in Basic mode with a single grouping field; Advanced is required to add the second grouping column properly.
Why D is wrong: All rows is an output aggregation that returns full grouped sub-tables; it does not control which columns drive the grouping.
Frequently asked questions
- How many questions are on the PL-300 exam?
- The Microsoft Power BI Data Analyst (PL-300) (PL-300) exam has Typically 40 to 60 questions questions and runs for 100 minutes. The format is multiple choice and multiple response, at a pearson vue testing center or online proctored.
- What score do I need to pass PL-300?
- The pass mark is 700 / 1000. Examworthy gives you a per-domain readiness score so you can see which domains are holding you back before you book.
- How much does the PL-300 exam cost?
- The exam costs 165 USD to sit. Practising on Examworthy is free to start, with a worked explanation on every question.
- How does Examworthy help me prepare for PL-300?
- Every practice question carries a worked explanation and a per-distractor rationale, mapped to the official blueprint domains. You learn why each answer is right or wrong, not just the letter.
- Is Examworthy affiliated with Microsoft?
- No. Examworthy is not affiliated with or endorsed by Microsoft. Our questions are original, blueprint-aligned practice material; we never reproduce live exam items.
Examworthy is not affiliated with or endorsed by Microsoft. All questions are original, blueprint-aligned practice material. We never reproduce live exam items. PL-300 and related marks belong to their respective owners.
