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?

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

Correct Answer: D

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/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.

The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce toad times.
Which two actions will reduce the toad times? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''
• B.Remove the rows in Traffic in which Traffic [Referring URL] does not start with "/"
• C.Remove the rows in Posts in which Post [Publish Date] is in the last seven days.
• D.Remove Posts [Full Text] and Posts [Summary].
• E.Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

Comment: *

Name: *

Email: *

Verification: *

You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *

You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Comment: *

Name: *

Email: *

Verification: *

You are building a Power Bl report that uses data from an Azure SQL database named erp1.
You Import the following tables.

You need to perform the following analyses:
* Orders sold over time that include a measure of the total order value
* Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?

• A.From Power Query, merge the Orders query and the Order Line Hems query.
• B.Calculate the count of orders per product by using a DAX function.
• C.Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.
• D.From Power Query, merge the Order Line Items query and the Products query.

Comment: *

Name: *

Email: *

Verification: *