Microsoft Power BI Data Analyst: PL-300

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:

1.

Date[Month] in the mmyyyy format

2.

Date[Date_ID] in the ddmmyyyy format

3.

Date[Date_name] in the mm/dd/yyyy format

4.

Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Order table and the Store table on the Store_ID column.

What should you do before you create the relationship?

A. In the Order table query, use the Table.TrasformRows function.

B. In the Store table query, use the Table.TrasformRows function.

C. In the Store table query, use the Table.TrasformColumnTypes function.

D. In the Order table query, use the Table.TrasformColumnTypes function.

You have the Power Bl model shown in the following exhibit.

There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only.

What should you do?

A. Create a row-level security (RLS) role for each department, and then define the membership of the role.

B. Create a DepartmentID parameter to filter the Departments table.

C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

D. Create a slicer that filters Departments based on DepartmentID.

HOTSPOT

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

Hot Area: