PL-300 Demo
Progress
0/10
Exit
Question 1
What does DAX IF() do?
Split text
Logical branching
Optimize model
Import data
Save & Next
Question 2
What is the minimum number of datasets and storage modes required to support the reports?
Two imported datasets
A single DirectQuery dataset
Two DirectQuery datasets
A single imported dataset
Save & Next
Question 3
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI
visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Add the same slicer to each page and configure Sync slicers.
Edit the interactions of the KPI visualization.
Configure a page-level filter.
Edit the interactions of the slicer that is on the same page as the KPI visualization.
Save & Next
Question 4
Which Power Query steps handle missing values?
Fill Down
Fill Up
Remove Errors
Replace Values
Save & Next
Question 5
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type
of tile should you add?
Video
Custom streaming data
Text box
Web content
Save & Next
Question 6
In Power Query, what controls the order of “Applied Steps”?
Model size
Data refresh speed
Transformation sequence
Visual updates
Save & Next
Question 7
A calculated table always refreshes dynamically with slicers.
TRUE
FALSE
Save & Next
Question 8
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from
powerbi.com.
Which should you do?
Create a JSON file that contains the database server name
Import the JSON file to the dataset.
Create a parameter and update the queries to use the parameter.
Create a query for each database server and hide the development tables.
Save & Next
Question 9
For what is DAX DISTINCTCOUNT used?
Rows
Unique values
All values
Filtered values only
Save & Next
Question 10
What does “Detect Data Type” do?
Rename columns
Automatically assign data types
Remove duplicates
Sort table
Save & Next
Review all answers before submitting
Submit Exam
Question Navigator
1
2
3
4
5
6
7
8
9
10