CertifyDeckCargando contenido…
PL-300 · Sample questions
10 real questions from the CertifyDeck PL-300 bank, spread across the domains of the official Power BI Data Analyst skills outline, with the correct answer and a full explanation of why the other options are wrong. They are original questions written from the public syllabus, not exam dumps, and they are the same style you will find in the practice tests and mock exams.
Correct answer: A. Pie chart
A pie chart is intended for showing proportions of a whole at a single snapshot, which fits five brands sharing one market. A line chart (B) is for trends over a continuous axis, not proportions. A scatter chart (C) plots two numeric measures against each other to find correlation, not part-to-whole relationships. A ribbon chart (D) shows part-to-whole changes ranked over time, which is unnecessary complexity for a single point in time.
Correct answer: A. Scatter chart with size encoding
A scatter chart plots two numeric axes (cost vs distance) and supports a third dimension via bubble size (weight), making it ideal for correlation analysis with three variables. A stacked bar chart (B) compares categorical totals and parts, not continuous correlation between two measures. A treemap (C) shows hierarchical part-to-whole proportions via area, not correlation. A funnel chart (D) shows sequential stage drop-off, unrelated to correlation analysis.
Correct answer: A. Configuring a dedicated capacity (Premium or Fabric) assigned to the workspace with the capacity provisioned in the target region
Workspace data residency is controlled by the capacity (Premium/Fabric) that hosts the workspace; provisioning that capacity in the desired Azure region places the workspace's storage and compute there (multi-geo support). Renaming the workspace has no effect on where data is stored. The contact list setting only defines who is notified about workspace issues, not where data resides. Personal (My Workspace) workspaces use the default tenant region and cannot be reassigned to Premium capacity for regional control in the same way as standard workspaces.
Correct answer: A. Manage roles
"Manage roles" is the specific dialog for creating, naming, and defining DAX filter expressions for RLS roles. B is false; "Manage relationships" configures table relationships, unrelated to security roles. C is false; "New measure" creates DAX calculations for analysis, not security filters. D is false; "Mark as date table" configures time intelligence behavior, unrelated to RLS.
Correct answer: A. DirectQuery
DirectQuery sends a query straight to the source database every time a visual is rendered, so users always see the current state of the data with no import lag, which matches a zero-staleness requirement. Import (plain, scheduled every 15 minutes, or incremental) always stores a snapshot copy that is only as fresh as the last refresh, so there would always be some staleness window, however small — it cannot guarantee true real-time freshness the way DirectQuery can.
Correct answer: A. Confidential
The four standard privacy level options in Power Query are None, Public, Organizational, and Private. 'Confidential' is not one of the built-in named levels — it does not appear as a selectable option in the Data source settings dialog. Public, Organizational, and Private are all real, selectable privacy levels.
Correct answer: A. Compare the row count shown at the bottom-left status bar before and after selecting that step in Applied Steps
Power Query Editor's status bar shows the current row count for whichever step is selected in Applied Steps, so clicking the step before and the step after a filtering/dedup operation and comparing the two counts directly reveals how many rows that specific step removed. Data source settings has nothing to do with row counts — it manages credentials and privacy. The query group folder is purely organizational and carries no row-count information. The Relationships pane in Model view shows table relationships in the data model, not step-by-step row counts within Power Query.
Correct answer: A. Blank rows are excluded from both the sum and the row count used in the average
AVERAGE in DAX ignores blank values entirely, both for the numerator (sum) and denominator (row count) of the calculation, so it computes the mean only over rows with an actual value. It does not treat blanks as zero, which would incorrectly lower the average. It does not error out on blanks, unlike some strict aggregation contexts. It does not substitute blanks with the column average, which is not a behavior DAX performs automatically.
Correct answer: A. The column returns BLANK() for that row
RELATED looks up the single related row on the "one" side of the relationship; if no matching row exists (an orphan key), there is nothing to return, so RELATED evaluates to BLANK() for that specific row only, while all other rows with valid matches compute normally. It does not cause the whole column to fail across the table. It has nothing to do with circular references, which is an unrelated error category (e.g., ambiguous or looping relationships). It never deletes rows from the source table; row removal is not something a calculated column can do.
Correct answer: A. Select the quick measure in the Fields pane and open it in the formula bar, where the generated DAX can be edited like any other measure
A quick measure is simply a regular measure whose DAX was generated for you; once created, it appears in the Fields pane like any other measure and its formula can be opened and edited in the formula bar, making it a great learning tool for DAX. B is wrong because quick measures remain fully editable after creation. C is wrong because Power Query operates on data transformations (M language) before load, not on DAX measures. D is wrong because quick measures do have real, inspectable DAX behind them.
Answer each question before opening the explanation, and write down why you discarded the other options. On PL-300, most mistakes come from choosing an option that is technically possible but does not meet every requirement in the scenario.
These 10 questions are a taste of the format, not a diagnostic. To know which domains you fail, practice by domain for free and take a timed mock exam that mirrors the official weights and duration.
Start for free, no sign-up or card. Every question includes an explanation like the ones above, and the mock exam reproduces the official PL-300 format.