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

Complete PL-300 Microsoft Materials

Page: 16 / 16
Total 422 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 61

You have a Microsoft SharePoint Online site that contains several document libraries.

One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

What should you do?

Options:

A.

Get data from a SharePoint folder, enter the site URL and then select Combine & Load

B.

Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

C.

Get data from a SharePoint list enter the site URL and then select Combine & Load

D.

Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

Question 62

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

    First name

    Last name

    Email address

    State/Region

    Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Open the Advanced Editor.

B.

Select Column quality.

C.

Enable Column profiling based on entire dataset.

D.

Select Column distribution.

E.

Select Column profile.

Question 63

You attempt to use power Query Editor to create a custom column and receive the error message shown in the following exhibit.

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.

Options:

Question 64

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?

Options:

A.

Feedback

B.

Subscribe

C.

Comments

D.

Mark as favorite

Page: 16 / 16
Total 422 questions