QUESTION: 57

You have the Power BI model shown in the following exhibit.
A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
-The managers must only see the data of their respective country.
-The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
Create one role for each country.
For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 58

HOTSPOT (Drag and Drop is not supported)
You have a Power BI imported dataset that contains the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Assume Referential Integrity
When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery.
Note: The following requirements are necessary for Assume referential integrity to work properly:
Data in the From column in the relationship is never Null or blank
For each value in the From column, there is a corresponding value in the To column
Box 2: Star schema
Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.
Generally, dimension tables contain a relatively small number of rows. Fact tables, on the other hand, can contain a very large number of rows and continue to grow over time.
Example:

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Reveal Solution Next Question

QUESTION: 59

HOTSPOT (Drag and Drop is not supported)
You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.
You need to create a measure that calculates the total sales from the equivalent month of the previous year.
How should you complete the calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: CALCULATE
Box 2: PARALLELPERIOD
PARALLELPERIOD returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time.
Syntax: PARALLELPERIOD(<dates>,<number_of_intervals>,<interval>) dates: A column that contains dates. interval: The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month.
Incorrect:
SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
Syntax: SAMEPERIODLASTYEAR(<dates>)
DATESMTD returns a table that contains a column of the dates for the month to date, in the current context.
Syntax: DATESMTD(<dates>)
Box 3: 'DATE' [Month]

Reference:

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

Reveal Solution Next Question

QUESTION: 60

DRAG DROP (Drag and Drop is not supported)
You plan to create a report that will display sales data from the last year for multiple regions.
You need to restrict access to individual rows of the data on a per region-basis by using roles.
Which four 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.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.
To define security roles, follow these steps.
1. Import data into your Power BI Desktop report (Step 1)
2. From the Modeling tab, select Manage Roles.
3. From the Manage roles window, select Create. (Step 2)
4. Under Roles, provide a name for the role.
5. Under Tables, select the table to which you want to apply a DAX rule.
6. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ג€Valueג€(Step 3)
7. After you've created the DAX expression, select the checkmark above the expression box to validate the expression.
8. Select Save.
Step 3: Assign Users to the role.
You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service.
After you've created your roles, test the results of the roles within Power BI Desktop.
Step 4: Publish the report.
Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service.

Reference:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 16)

QUESTION: 57

QUESTION: 58

Explanation:

Reference:

QUESTION: 59

Explanation:

Reference:

QUESTION: 60

Explanation:

Reference:

PL-300 Exam Discussions & Posts