PL-300 Demo Exam | Skill Course

Question 1

multiple choice tetsing 1

1 2 3 4

Question 2

Scenario: Export report securely to selected users.

Publish to web Share via workspace Export PDF Download PBIX

Question 3

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00
and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance
of the report.
What should you recommend?

Replace the default visuals with custom visuals. Implement row-level security (RLS). Split the visuals onto multiple pages. Increase the number of times that the dataset is refreshed.

Question 4

What does CALCULATETABLE return?

String Number Table Blank only

Question 5

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
A line chart that shows the number of defective products manufactured by day.
A KPI visual that shows the current daily percentage of defective products manufactured. You need to be notified when the daily percentage of defective products
manufactured exceeds 3%. What should you create?

A Q&A visual A subscription A smart narrative visual An alert

Question 6

Scenario: You want to fill nulls in a column from above. Power Query step?

Fill Down Fill Up Remove Duplicates Replace Values

Question 7

Scenario: Show cumulative sales month-over-month.

CALCULATE SUMX TOTALYTD FILTER

Question 8

What does “Group By” do in Power Query?

Joins Aggregation Pivot Hierarchy

Question 9

For what is DAX DISTINCTCOUNT used?

Rows Unique values All values Filtered values only

Question 10

To split a text column by delimiter, use _______ step.

Split Column Merge Columns Extract Text Replace Values