Data Analyst Power BI (PL-300) practice questions
10 free questions with answers and explanations. Try each one, then tap “Show answer”.
- 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.
- 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.
- 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.
- 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%.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
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 TelegramMore Data Analyst practice
About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.