Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Online PL-300 Questions Video

Page: 3 / 16
Total 422 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 9

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Options:

Question 10

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

Options:

A.

Create a shared dataset for each standardized entity.

B.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.

For every report, create and use a single shared dataset that contains the standardized data.

D.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Question 11

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

Options:

A.

One to one

B.

Many to one

C.

One to many

D.

Many to many

Question 12

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?

Options:

A.

bar chart

B.

scatterplot

C.

pie chart

Page: 3 / 16
Total 422 questions