1
Single choice~90s
A dataset must combine data from a SQL Server database, an Excel workbook, and a SharePoint list. Where does a Power BI analyst connect to and shape all of these sources?
Power BI Data Analyst
MS_PL_300Ready to test yourself?
A timed, blueprint-proportional exam drawn fresh from this bank — with a per-domain score report.
🔓 Free preview: showing 10 of 50 questions. Unlock the full bank — every question, explanation, and reference.
Unlock all 50 questions →10 questions across 4 topics. Choose an answer for each question, then check it to see the correct answer and explanation.
Filter by topic
8 questions in Prepare the Data
PREPARE_DATA
Prepare the Data
8 questions in topicGetting data, storage modes, Power Query transformations, profiling, and performance.
2
Single choice~110s
A compliance rule states report data may never be persisted inside the PBIX/model — every visual interaction must query the source database directly. Which storage mode satisfies this?
3
Single choice~100s
Before modeling, an analyst wants to check a column for empty values, errors, and the distribution of distinct values across the full dataset. Which Power Query settings enable this check on more than the default sample?
4
Single choice~110s
A query against a data warehouse applies Filter Rows, then Remove Columns, then a custom M function that cannot fold. How should the analyst order the steps for best performance?
5
Single choice~100s
Regional sales files with identical columns arrive monthly into one folder. The analyst wants Power BI to automatically combine ALL current and future files in that folder into a single table. Which approach fits?
6
Single choice~100s
A source column mixes customer names like 'john SMITH' with inconsistent casing, plus leading spaces. Which Power Query transformations clean it?
7
Single choice~110s
During refresh setup, a 500M-row fact table must load only new and changed recent data instead of everything, using RangeStart and RangeEnd parameters. Which feature is being configured?
8
Single choice~100s
Multiple teams' datasets need the same cleansed 'Product Catalog' table, prepared once in the cloud with Power Query and reused everywhere. Which Power BI service item should be created?