QUESTION: 41 Exam Topic: Question Set 2

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

QUESTION: 42 Exam Topic: Question Set 2

DRAG DROP (Drag and Drop is not supported)
You create a data model in Power BI.
Report developers and users provide feedback that the data model is too complex.
The model contains the following tables.

The model has the following relationships:
-There is a one-to-one relationship between Sales_Region and Region_Manager.
-There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
-There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.

You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

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.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: Merge [Sales_Region] and [Sales_Manager] by using an inner join.
Inner Join: Returns the rows present in both Left and right table only if there is a match. Otherwise, it returns zero records.
Note: Sales_Region and Sales_manager
There is a one-to-one relationship between Sales_Region and Region_Manager.
There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.
Step 2: Merge [Region_Manager] and [Manager] by using inner join.
Only managers who are associated to a sales region must be included in the reports.
Note: Region_Manager and Manager.
There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
Step 3: Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager]

Reference:

https://www.tutorialgateway.org/joins-in-power-bi/

Reveal Solution Next Question

QUESTION: 43 Exam Topic: Question Set 2

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

Change any DAX measures to use iterator functions.
Enable visual interactions.
Replace the default visuals with AppSource visuals.
Split the visuals onto multiple pages.

Answer(s): D

Explanation:

One page with many visuals may also make your report loading slow. Please appropriately reduce the number of visualizations on one page.

Reference:

https://community.powerbi.com/t5/Desktop/Visuals-are-loading-extremely-slow/td-p/1565668

Reveal Solution Next Question

QUESTION: 44 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
Sales contains the data shown in the following table.

You are evaluating how to optimize the model.
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: Yes
Those two columns not need in the analysis.

Box 2: No
Can remove the surrogate key OrderDateKey from the analysis.

Box 3: No
Tax charged not relevant for the analysis.

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 11)

QUESTION: 41 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 42 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 43 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 44 Exam Topic: Question Set 2

Explanation: