QUESTION: 53 Exam Topic: Question Set 2

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

Create an inactive relationship between the tables and select Apply security filter in both directions.
Create an active relationship between the tables and select Apply security filter in both directions.
Create an inactive relationship between the tables and select Assume referential integrity.
Create an active relationship between the tables and select Assume referential integrity.

Answer(s): B

Explanation:

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

HOTSPOT (Drag and Drop is not supported)
You have a column named UnitsInStock as shown in the following exhibit.

UnitsInStock has 75 non-null values, of which 51 are unique.
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: 75 rows
Is nullable allows NULL values in the column.

Box 2: reduce

Reference:

https://blog.crossjoin.co.uk/2019/01/20/is-nullable-column-property-power-bi/

Reveal Solution Next Question

QUESTION: 55 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You have a Power BI report.
You have the following tables.

You have the following DAX measure.
Accounts :=
CALCULATE (
DISTINCTCOUNT (Balances[AccountID]),
LASTDATE ('Date'[Date])

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: No
It will show the total number of accounts that were live at the last day of the year only.
Note:
DISTINCTCOUNT counts the number of distinct values in a column.
LASTDATE returns the last date in the current context for the specified column of dates.

Box 2: No
It will show the total number of accounts that were live at the last day of the month only.

Box 3: Yes

Reference:

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

Reveal Solution Next Question

QUESTION: 56 Exam Topic: Question Set 2

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
-Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required.
-Minimize the data model size.

Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Create one-to-many relationships between the tables.
Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
Create a calculated table that contains Ad_id, Site_name, and Impression_date.
Create a calculated measure that aggregates by using the COUNTROWS function.

Answer(s): A,B

Explanation:

Incorrect:
Not C: A calculated table would increase the data model size.
Not D: Need Impression_date etc.

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 14)

QUESTION: 53 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 54 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 55 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 56 Exam Topic: Question Set 2

Explanation: