12,900+ practice questions · 144 exams · new questions added every week
Practice questions › Data Analyst › Power BI (PL-300)

Data Analyst Power BI (PL-300) practice questions

10 free questions with answers and explanations. Try each one, then tap “Show answer”.

  1. Performance

    1. Which tool records how long each visual's DAX query takes?

    • A. Quick insights
    • B. Sync slicers
    • C. Performance analyzer
    • D. Q&A
    Show answer

    Answer: C. Performance analyzer

    Use it to find slow visuals.

  2. Visuals

    2. Which visual best shows a trend over time?

    • A. Table
    • B. Line chart
    • C. Pie chart
    • D. Card
    Show answer

    Answer: B. Line chart

    Use bar or column charts for comparing categories.

  3. Security

    3. Row-level security (RLS) is used to

    • A. hide whole reports
    • B. encrypt the file
    • C. restrict which rows of data each user can see
    • D. speed up refresh
    Show answer

    Answer: C. restrict which rows of data each user can see

    Roles use DAX filter expressions.

  4. DAX results

    4. Sales: Region | Category | Amount | Units North | Food | 150 | 3 East | Home | 150 | 1 North | Toys | 400 | 5 North | Home | 500 | 8 East | Toys | 100 | 9 South | Home | 150 | 7 In a table visual, the row for Region = North shows this measure as a percentage. What value appears? DIVIDE(SUM(Sales[Amount]), CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region])))

    • A. 72.4%
    • B. 262.5%
    • C. 100%
    • D. 33.3%
    Show answer

    Answer: A. 72.4%

    ALL removes the region filter from the denominator: 1050 ÷ 1450 = 72.4%.

  5. DAX results

    5. Sales: Region | Category | Amount | Units North | Toys | 100 | 1 East | Home | 200 | 1 East | Home | 100 | 1 East | Home | 250 | 6 North | Home | 500 | 4 East | Toys | 300 | 5 Filtered to Region = East, what does this measure return? DIVIDE(SUM(Sales[Amount]), SUM(Sales[Units]))

    • A. 13
    • B. 850
    • C. 72.38
    • D. 65.38
    Show answer

    Answer: D. 65.38

    850 ÷ 13 = 65.38.

  6. Service

    6. Scheduled refresh in the Power BI service is configured on the

    • A. dashboard tile
    • B. semantic model (dataset)
    • C. visual
    • D. report page
    Show answer

    Answer: B. semantic model (dataset)

    Pro licences allow up to 8 refreshes a day.

  7. Visuals

    7. Drillthrough lets users

    • A. right-click a data point to open a detail page filtered to it
    • B. edit the data model
    • C. export to Excel only
    • D. change the theme
    Show answer

    Answer: A. right-click a data point to open a detail page filtered to it

    Set drillthrough fields on the target page.

  8. DAX

    8. Which function returns the value of a column when exactly one value is selected?

    • A. DISTINCT
    • B. VALUES
    • C. EARLIER
    • D. SELECTEDVALUE
    Show answer

    Answer: D. SELECTEDVALUE

    It returns BLANK (or an alternate) when there are several.

  9. DAX

    9. ALL() in DAX is used to

    • A. add filters
    • B. sort data
    • C. remove filters from a table or column
    • D. create relationships
    Show answer

    Answer: C. remove filters from a table or column

    Useful for percentage-of-total calculations.

  10. Power Query

    10. Which Power Query feature creates a profile of column values, errors and empties?

    • A. Drillthrough
    • B. Bookmarks
    • C. Quick measures
    • D. Column quality and column distribution (data profiling)
    Show answer

    Answer: D. Column quality and column distribution (data profiling)

    Found on the View tab.

Want more Data Analyst Power BI (PL-300) questions?

Get fresh questions every day, focused on your weak topics, plus timed mock tests. Free to start.

Practise free in the web app Practise on Telegram

More Data Analyst practice

About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.