QUESTION: 37 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You create a Power BI 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.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Cost Center
The Row label field value is used in Excel so users can easily identify the row. It appears as the cell value for a linked cell, in the Data Selector pane, and in the
Information card.

Box 2: ID
The Key column field value provides the unique ID for the row. This value enables Excel to link a cell to a specific row in the table.

Box 3: Yes
In the Data Types Gallery in Excel, your users can find data from featured tables in your Power BI datasets.

Reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-excel-featured-tables

Reveal Solution Next Question

QUESTION: 38 Exam Topic: Question Set 2

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

Explanation:

A: You can take advantage of the DAX functions username() or userprincipalname() within your dataset. You can use them within expressions in Power BI
Desktop. When you publish your model, it will be used within the Power BI service.
Note: To define security roles, follow these steps.
Import data into your Power BI Desktop report, or configure a DirectQuery connection.
1. From the Modeling tab, select Manage Roles.
2. From the Manage roles window, select Create.
3. Under Roles, provide a name for the role.
4. Under Tables, select the table to which you want to apply a DAX rule.
5. 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
6. After you've created the DAX expression, select the checkmark above the expression box to validate the expression.
Note: You can use username() within this expression.
7. Select Save.
C: By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

Reference:

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

Reveal Solution Next Question

QUESTION: 39 Exam Topic: Question Set 2

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: 40 Exam Topic: Question Set 2

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

Microsoft Power BI Data Analyst PL-300 Exam

QUESTION: 37 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 38 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 39 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 40 Exam Topic: Question Set 2

Explanation:

Reference:

Microsoft Power BI Data Analyst
PL-300 Exam