PL-300 Demo Exam | Skill Course

Question 1

The DAX function to calculate a sum iterating row by row is _______.

CALCULATE SUM SUMX FILTER

Question 2

Which Power Query steps handle missing values?

Fill Down Fill Up Remove Errors Replace Values

Question 3

When should Many-to-Many cross-filtering be used?

Always Avoid unless needed Only on measures Only in visuals

Question 4

What does USERPRINCIPALNAME() return?

Username (email) Dataset name Gateway URL

Question 5

What does “Format as Text” do?

Remove column Change data type to text Sort values Create custom column

Question 6

What does CALCULATETABLE return?

String Number Table Blank only

Question 7

What is a tooltip page used for?

Extra information popup Refresh setup Data cleaning Security

Question 8

You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

Create a horizontal line that has a fixed value of 24,000. Add a measure to the visual that uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) Add a new percentile line that uses Total Sales as the measure and 40% as the percentile. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Question 9

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has
the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?

Add a description of "subscriber count" to the Customer Count measure. Set Summarize By to None for the CustomerlD column. Add a description of "Subscriber" to the Customer table. Add a synonym of "subscriber" to the Customer table.

Question 10

DirectQuery mode imports data into the Power BI model.

FALSE TRUE