Microsoft PL-300 Practice Test - Questions Answers, Page 33

You have a Power BI data model that contains a table named Employees. The table has the following columns:

* Employee Name

* Email Address

* Start Date

* Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

* Users must see only their own employee data

* The DAX expression must work in both Power 81 Desktop and the Power BI service.

Which expression should you use?

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.

You need to create a Power BI report that connects to the project management app.

Which connector should you select?

HOTSPOT

You have a Power BI report that contains a page. The page contains the following visuals:

* A card

* A matrix

* A bar chart

You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix The card and the bar chart must change when a user selects a cell in the matrix.

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

HOTSPOT

You are creating a Power 81 model to analyze inventory.

You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.

Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

How should you complete the measure? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

HOTSPOT

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bl model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

You have a Power Bl model that contains two tables named Population and Date.

The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power Bl model contains two measures that have the following definitions.

Total Population = Sum ('Population'[Population Amount])

2023 Population = CALCULATE ([Total Population]'Date'[Year] = 2023)

You create a table visual that displays Date[Year] and [2023 Population].

What will the table visual show?

DRAG DROP

You use Power Query Editor to preview the data shown in the following exhibit

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

Which three actions should you perform in sequence? To answer move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

HOTSPOT

You have a query named All Sales that imports sales data into a Power BI model.

You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:

* Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.

* Minimize maintenance effort.

What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.