Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 5

Questions 41

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

PL-300 Question 41

Options:
Microsoft PL-300 Premium Access
Questions 42

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

Options:
A.

Filter out discontinued products while importing the Products table.

B.

Group the Categories table by the CategorylD column.

C.

Change the OrderlD column in the Orders table to the Text data type.

D.

Remove the QuantityPerUnit column from the Products table.

Questions 43

You need to create the dataset. Which dataset mode should you use?

Options:
A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

Questions 44

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Options:
A.

Merge queries

B.

Append queries

C.

Combine files

Questions 45

You have a report in Power BI Desktop as shown in the following exhibit.

PL-300 Question 45

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

Note: Each correct selection is worth one point.

PL-300 Question 45

Options:
Questions 46

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE; Each correct selection is worth one point.

PL-300 Question 46

Options: