Free Microsoft PL-300 Demo Questions

Question #1 (Topic: demo questions)

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

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 Salestable 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-tomany relationship to Weekly_Return.

Correct Answer: A

Explanation:

Scenario: Region managersrequire a visual to analyze weekly sales and returns.

Question #2 (Topic: demo questions)

Whatshould you create to meet the reporting requirements of the sales department?

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

Correct Answer: C

Explanation:

The sale department requires reports that contain the number ofsalestransactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

Question #3 (Topic: demo questions)

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

Explanation not available for this question.

Question #4 (Topic: demo questions)

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

Explanation not available for this question.

Microsoft PL-300 - Microsoft Power BI Data Analyst Certification Exam

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

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 Salestable by using related DAX functions.

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

Correct Answer: A

Scenario: Region managersrequire a visual to analyze weekly sales and returns.

Whatshould you create to meet the reporting requirements of the sales department?

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

Correct Answer: C

The sale department requires reports that contain the number ofsalestransactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

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

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.

Correct Answer: C

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

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

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

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

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

Correct Answer: A