PL-300 mock exam: 25 free practice questions

Q1 / 25

Why might pages for different audiences be separated into different reports?

1. APages cannot be secured or published independently
2. BPages cannot contain different combinations of visuals
3. CPages cannot use predefined or custom dimensions
4. DPages cannot be renamed after the report is saved

Q2 / 25

Which combination operation adds rows from one query to another?

1. ADuplicate
2. BAppend
3. CMerge
4. DReference

Q3 / 25

What date range does `DATESBETWEEN` return?

1. ADates for one full year chosen automatically
2. BDates from a given start through a given end
3. CDates shifted exactly one year backward
4. DDates from period end to the last nonblank result

Q4 / 25

A reset button must restore two slicers without changing a chart's drill depth. Which bookmark configuration fits?

1. ACurrent page state with both slicers hidden
2. BData state with Selected visuals scope for the slicers
3. CDisplay state with Current page disabled
4. DData state with All visuals scope for the page

Q5 / 25

In Column Distribution, what does the unique count represent?

1. AOnly values classified as errors
2. BAll different values present, including duplicates and nulls
3. CEvery row, including repeated values
4. DValues that occur once, excluding nulls

Q6 / 25

Which cost is documented for calculated tables in an Import model?

1. AMore model storage and potentially longer refresh
2. BNo storage change but slower visual formatting
3. CNo refresh change but fewer source columns
4. DSmaller storage and potentially shorter refresh

Q7 / 25

A required transaction is not stored in the host semantic model. Why can paginated output still present it?

1. AIt can connect directly to source databases
2. BIt recreates missing rows from report bookmarks
3. CIt changes Import tables into calculated tables
4. DIt converts visual formatting into source records

Q8 / 25

When should you choose Transform Data instead of Load in Navigator?

1. AWhen the selected data needs review or preparation in Power Query
2. BWhen the selected data must load immediately in its current state
3. CWhen an Analysis Services model must retain a live connection
4. DWhen the source requires a server address before authentication

Q9 / 25

What does horizontal filtering remove from a semantic model?

1. ARelationship paths that propagate filters in both directions
2. BDistinct timestamp values by converting them to dates
3. CUnused model columns
4. DRows that are outside the required reporting scope

Q10 / 25

Before a modified semantic model replaces the published one, what does the confirmation message report?

1. AHow many people currently hold build permissions on the semantic model
2. BHow many scheduled refreshes the semantic model has run this month
3. CHow many workspaces, reports, and dashboards are potentially impacted
4. DHow many sharing links point at the reports built on the semantic model

Q11 / 25

An author wants Copilot to recolor every chart while preserving its fields. What should the author conclude?

1. ACopilot supports recoloring after disabling implicit measures
2. BCopilot supports recoloring only for imported custom visuals
3. CCopilot does not support styling or formatting changes
4. DCopilot supports recoloring after switching to Reading view

Q12 / 25

Which maintenance action removes saved permission information for an existing connection?

1. AChange Source
2. BEdit permissions
3. CClear Permissions
4. DClose and Apply

Q13 / 25

Product has unique ProductKey values, while Sales contains repeated ProductKey values. Which relationship cardinality should be set from Product to Sales?

1. AMany-to-one from Product to Sales
2. BOne-to-one
3. COne-to-many
4. DMany-to-many

Q14 / 25

Hundreds of salespeople change regions frequently, and an Employees table stores each sign-in email with the current region. Which design minimizes continuing role maintenance?

1. AOne Write assignment for every salesperson without role membership
2. BOne ruleless role that grants every salesperson all table rows
3. COne fixed-value role for every region, republished after each personnel change
4. DOne dynamic role that compares USERPRINCIPALNAME with the stored email

Q15 / 25

Which set consists of documented destinations for the export command on a Paginated report visual?

1. AExcel, PDF, CSV, PowerPoint, Word, MHTML, and XML
2. BPBIX, PBIT, BIM, TMDL, and Power Query M
3. CPNG, JPEG, GIF, TIFF, BMP, and SVG
4. DParquet, Delta, Avro, ORC, and database backup

Q16 / 25

What does a dimension table primarily describe?

1. AA list of report pages and visual bookmarks
2. BA join result containing unmatched source rows
3. CA business entity such as a product or place
4. DA set of transaction amounts at event grain

Q17 / 25

How can a prior-year revenue measure reuse the existing `[Revenue]` measure?

1. AUse `CALCULATE` with dates from `SAMEPERIODLASTYEAR`
2. BStore `[Revenue]` in a calculated column at refresh
3. CUse `COUNTROWS` to count every date in the current reporting year
4. DUse `SUM` on the measure name without a filter

Q18 / 25

A colleague already has report permission. You need to send the report URL without granting access or adding Reshare and Build rights. Which link should you send?

1. AA People in your organization link with Build disabled
2. BSend a People with existing access report link
3. CA Specific people link with Reshare disabled
4. DA Specific people link with both optional rights enabled

Q19 / 25

A portrait phone page needs a compact slicer that reveals more options when widened. Which configuration fits?

1. AUse report personalization as the slicer orientation
2. BUse a responsive slicer in horizontal orientation
3. CUse alt text to resize the slicer automatically
4. DUse a vertical slicer with responsiveness enabled

Q20 / 25

A helper query supplies data to a final query but also appears as an unwanted table in the report field list. What should the analyst change?

1. AChange the helper key columns to unrelated values
2. BDelete the helper query and its contribution
3. CClear Enable load on the final query
4. DClear Enable load on the helper query

Q21 / 25

What does the argument in `CALENDARAUTO(6)` specify?

1. AJune as the financial year-end month
2. BJune becomes the first calendar month
3. CSix missing dates are permitted
4. DSix date columns are generated

Q22 / 25

Which report link type supplies a URL without granting new access?

1. APeople with existing access
2. BMicrosoft Entra B2B guests
3. CSpecific people
4. DPeople in your organization

Q23 / 25

A segmentation analysis must find similarity patterns across four measures. Which setup supports that clustering requirement?

1. AAdd four constant lines and treat each line as a cluster
2. BConvert the four measures into one set of equal-sized bins
3. CPlace two measures in a scatter chart and ignore the other measures
4. DPlace the measures in a table and run the clustering algorithm

Q24 / 25

An imported CSV date column was detected as Text, preventing a time-based calculation. Which correction should be applied before loading the model?

1. ARename the query without changing the column type
2. BReplace every date with the numeric value zero
3. CChange the column to Date in Power Query Editor
4. DRemove duplicate dates until the calculation succeeds

Q25 / 25

When does Power BI evaluate an explicit measure?

1. AAt file save time without report filters
2. BAt relationship creation before data loads
3. CAt query time under the current filters
4. DAt refresh time once for every model row