Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Selected PL-300 Microsoft Certified: Power BI Data Analyst Associate Questions Answers

Page: 9 / 17
Total 450 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 33

You have a Microsoft Excel file on a file server.

You create a Power BI report and import a table from the Excel file.

You publish the report.

You need to ensure that the data refreshes every four hours.

What should you do first?

Options:

A.

Upload the Excel file to a Power BI workspace.

B.

Create a subscription to the report.

C.

Deploy an on-premises data gateway.

D.

Edit the data source credentials.

Question 34

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.

scarterplot

B.

bar chart

C.

piechart

Question 35

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 36

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.

Page: 9 / 17
Total 450 questions