PL-300 Leak Questions

Page: 5 / 9

Question 20

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

Options:

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

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

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

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

Question 21

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 22

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Options:

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

Question 23

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:

• Customer ID

• Customer Name

• Phone

• Email Address

• Address ID

Address contains the following columns:

• Address ID

• Address Line 1

• Address Line 2

• City

• State/Region

• Country

• Postal Code

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?