CertsTopics Logo

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

Pass PL-300 Exam Guide

Page: 8 / 9
Total 342 questions
Get PL-300 Full Access Download PL-300 PDF

Microsoft Power BI Data Analyst Questions and Answers

Question 29

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 30

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 31

What should you create to meet the reporting requirements of the sales department?

Options:

A.

a measure that uses a formula of SUM (Sales [sales_id])

B.

a calculated column that use a formula of COUNTA(sales [sales_id])

C.

a measure that uses a formula of COUNTROWS (Sales)

D.

a calculated column that uses a formula of SUM (Sales [sales_id])

Question 32

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

Options:

A.

Apply row-level security (RLS) to the Region table based on the sales manager username.

B.

Configure a bi-directional relationship between Region and Sales.Region.

C.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Page: 8 / 9
Total 342 questions
Get PL-300 Full Access Download PL-300 PDF