PL-300 Demo Exam | Skill Course

Question 1

RANKX() function provides?

Text Sum Average Ranking

Question 2

Which step preserves original data?

Duplicate Query Remove Rows Split Column Merge Columns

Question 3

When does query folding break?

When native SQL used When unsupported step added When rename column When filter applied

Question 4

To create a dynamic filter using user identity, we use _______ function.

SESSIONUSER() USERNAME() CURRENTUSER() USERPRINCIPALNAME()

Question 5

You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?

Edit the details of each tile. Change the report theme. Change the dashboard theme. Create a custom CSS file.

Question 6

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page,
the visuals are not updated on all the pages. You need to
recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this
goal?

Sync the slicers across the pages. Replace the slicers with report-level filters. Replace the slicers with page-level filters. Replace the slicers with visual-level filters.

Question 7

Scenario: Show revenue trend over time.

Line Chart Column Chart Area Chart Pie Chart

Question 8

When do we use cross-filter direction “Both”?

Always Complex models Simple models Never

Question 9

What is required for drill-through?

Primary metric Target page enabled Bookmarks Dataset refresh

Question 10

What is the use of “Replace Values” in Power Query?

Rename column Update specific values Change data type Sort rows