Free PL-300 Exam Braindumps

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

  1. FORMAT('Date'[date], "MMM YYYY")
  2. FORMAT('Date' [date], "M YY")
  3. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
  4. FORMAT('Date' [date_id], "MMM YYYY")

Answer(s): A



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

  1. a measure that uses a formula of SUM (Sales [sales_id])
  2. a calculated column that use a formula of COUNTA(sales [sales_id])
  3. a measure that uses a formula of COUNTROWS (Sales)
  4. a calculated column that uses a formula of SUM (Sales [sales_id])

Answer(s): C

Explanation:

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.


Reference:

https://docs.microsoft.com/en-us/dax/countrows-function-dax



You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

  1. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
  2. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
  3. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one- to-many relationship from Date[date_id] to Weekly_Returns[week_id]
  4. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to- many
    relationship from Sales[sales_ship_date_id] to Date[date_id]
  5. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one- to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Answer(s): A

Explanation:

Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.


Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships- understand



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

  1. Change the data type of Sales[region_id] to Whole Number.
  2. In the Sales table, add a measure for sum(sales_amount).
  3. Change the data type of sales[sales_id] to Text.
  4. Change the data type of sales [region_id] to Decimal Number.

Answer(s): 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).



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

What should you include in the solution?

  1. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
  2. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
  3. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
  4. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Answer(s): A


Reference:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row- level-security/