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

Pass PL-300 Exam Guide

Page: 8 / 17
Total 450 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 29

You have a Power Bl report that contains a page. The page contains the following:

• A shape named Shape 1

• A card named Sales Summary

• A clustered bar chart named Sales by Region

You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

Options:

A.

Tab order in the Selection pane

B.

Layer order in the Selection pane

C.

Maintain layer order in the General visual settings

D.

Vertical alignment in the Canvas settings

Question 30

You have a Power B1 report that contains a card. The card displays the value for year-to-date revenue.

You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.

What should you do?

Options:

A.

Populate the alt text by using conditional formatting with a DAX measure.

B.

Add the value to the chart title text.

C.

Convert the card into a text box.

D.

Populate the alt text with a static value.

Question 31

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

You need to shape the query to display the following three columns:

* Month

* Sales

* Year

‘What should you select in Power Query Editor?

Options:

A.

Pivot column

B.

Merge columns

C.

Unpivot columns.

D.

Transpose

Question 32

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

Does this meet the goal?

Options:

A.

Yes

B.

No

Page: 8 / 17
Total 450 questions