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

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

Page: 9 / 11
Total 434 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 33

You a-e using Power Bl Desktop 10 profile data in Power Query Editor.

You need to review the percentage of errors and the maximum value of each column.

Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Options:

Question 34

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Options:

A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

Question 35

You publish the dataset to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Question 36

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

Options:

A.

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

B.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

C.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Page: 9 / 11
Total 434 questions