PL-300 domain - 24% of the exam

Prepare the Data

Prepare the Data is 24% of the Microsoft Power BI Data Analyst (PL-300) (PL-300) exam. These are the objectives it covers, each with practice questions and worked explanations.

Objectives in this domain

Sample question from this domain

Free 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?

  • AYes 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.

Other domains in this exam

See also the PL-300 cert hub, the study guide, and the cheat sheet.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.