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.

Explanation:
The completed mapping shown in the answer area is correct. The key constraint is to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. A merge joins columns from related tables by matching key values. That is the appropriate operation when one output row must contain attributes from both sources; append would stack rows instead. This directly matches the current study-guide objective " Merge and append queries " . Append stacks records vertically and therefore cannot bring related attributes onto the same row; that requires a key-based merge. The join type also preserves the inclusion rule stated in the scenario while avoiding an unrelated increase in table grain.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/merge-queries-overview | PL-300 objective: " Merge and append queries " | Study guide: https://learn.microsoft.com/en-us/credentials
/certifications/resources/study-guides/pl-300

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.
You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.
What should you do?

• A. Select the donut chart and set the column chart interaction to None.
• B. Select the column chart and set the donut chart interaction to None.
• C. Select the column chart and set the donut chart interaction to Filter.
• D. Select the donut chart and set the column chart interaction to Filter.

說明：（僅 Fast2test 成員可見）

You have a column named UnitslnStock 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.

Explanation:

The scenario establishes that you have a column named unitslnstock 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. The selections in the retained answer exhibit are the verified configuration. Power Query should resolve this requirement before the data enters the semantic model. The chosen transformation preserves the required rows and grain while converting the source layout into an analysis-ready table. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. The current PL-300 study guide places this under the objective " Resolve inconsistencies, unexpected or null values, and data quality issues " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Resolve inconsistencies, unexpected or null values, and data quality issues " | Study guide: https://learn.
microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300

You create a Power BI report named RPT1 that contains sales data. The data contains 10 million rows. RPT1 contains 15 different visuals.
Users state that RPT1 is slow to load.
You need to investigate the cause of the issue.
What should you use?

• A. Performance analyzer
• B. Query Diagnostics
• C. DAX query view
• D. Power Query Editor

說明：（僅 Fast2test 成員可見）

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group.
Does this meet the goal?

• A. No
• B. Yes

說明：（僅 Fast2test 成員可見）