Demo Microsoft PL-300 Exam Questions

Demo practice questions for guest users.

Section: Practice Mode 5 Questions

Demo Practice

Back To Exam

Question 1

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

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.

Correct Answer: C

Question 2

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

A

FORMAT('Date'[date], "MMM YYYY")

B

FORMAT('Date' [date], "M YY"

C

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D

FORMAT('Date' [date_id], "MMM YYYY")

Correct Answer: A

‹
1
2

Demo Practice Mode

You are viewing only the questions marked as Demo.