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

Pearson PL-300 New Attempt

Page: 13 / 15
Total 459 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 49

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Options:

A.

Merge queries

B.

Append queries

C.

Combine files

Question 50

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.

Question 51

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 52

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])

Page: 13 / 15
Total 459 questions