ExamworthyExamworthy
Open the appStart free

PL-300 - Prepare the Data - Section 1.1

Get data from data sources including files, databases, and cloud services.

Connect to files, relational databases, and cloud services using Power Query connectors, and choose between import and DirectQuery storage modes based on refresh and performance needs. Configure data source credentials and gateway connections to reach on-premises and cloud sources securely.

Power Query connectorsimport vs DirectQuerydataflowsgateway connectionsdata source credentials

Practice question for this objective

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.

See more PL-300 practice questions, answers explained.

More in this domain

Back to all Prepare the Data objectives, or the PL-300 cert hub.

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