Question No 1

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

Choose the Choices:

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Question No 2

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

Choose the Choices:

Question No 3

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

Choose the Choices:

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number. Answer: A Explanation: Scenario: Executives require a visual that shows sales by region. Need to change the sales_id column from Varchar to Whole Number (Integer).

Question No 4

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

Choose the Choices:

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

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

a measure that uses a formula of COUNTROWS (Sales)

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

Question No 5

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?

Choose the Choices:

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.

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

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.

Practice Microsoft PL-300 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

PL-300 Exam Features

PL-300 PDF Dumps