PL-300 Demo Exam | Skill Course

Question 1

What does DAX IF() do?

Split text Logical branching Optimize model Import data

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

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.

Question 4

Which Power Query steps handle missing values?

Fill Down Fill Up Remove Errors Replace Values

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

Question 6

In Power Query, what controls the order of “Applied Steps”?

Model size Data refresh speed Transformation sequence Visual updates

Question 7

A calculated table always refreshes dynamically with slicers.

TRUE FALSE

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.

Question 9

For what is DAX DISTINCTCOUNT used?

Rows Unique values All values Filtered values only

Question 10

What does “Detect Data Type” do?

Rename columns Automatically assign data types Remove duplicates Sort table