PL-300 Demo Exam | Skill Course

Question 1

What is the use of CALCULATE + ALLSELECTED?

Remove all filters Keep report-level filters Keep page filters only Force hierarchy

Question 2

Which DAX expression should you use to get the ending balances in the balance sheet reports?

CALCULATE (SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] )) CALCULATE (SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] )) FIRSTNONBLANK ( 'Date' [Date]SUM( BalanceSheet[BalanceAmount] )) CALCULATE (MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ))

Question 3

Scenario: You want to apply transformations across multiple datasets.

Power Query only Dataflow Report level Visual level

Question 4

Which service roles allow editing?

Admin Member Contributor Viewer

Question 5

What is the main use of CALCULATE + FILTER combination?

New visuals Grouping Context override Import data

Question 6

Power BI Service allows sharing reports with external users using RLS.

FALSE TRUE

Question 7

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?

Bar chart Scatterplot Pie chart Donut chart

Question 8

Scenario: Show cumulative sales month-over-month.

CALCULATE SUMX TOTALYTD FILTER

Question 9

Why is it necessary to mark a Date table?

Visual themes Performance boost Enables time-intelligence functions Gateway required

Question 10

Scenario: You want to combine two tables vertically.

Append Merge Pivot Unpivot