最新のPL-300合格保証付き試験問題集の認定サンプル問題
最新PL-300テスト材料には有効なPL-300テストエンジン
Microsoft PL-300試験は、Microsoft Power BIスイートのツールを使用してデータから洞察力と価値を抽出する候補者の知識とスキルを試験する認定試験で、データモデル、レポート、ダッシュボードで作業するデータアナリスト、異なるソースからデータを分析および視覚化する必要がある人々を対象としています。
質問 # 167
You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard 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.
正解:
解説:
1 - From powerbi.com, upload Excel1.
2 - From powerbi.com, import Excel1 as a dataset.
3 - From powerbi.com, add a tile for the Excel1 dataset to DashboardA.
質問 # 168
You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
正解:
解説:
Explanation:
質問 # 169
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 Apply security filter in both directions.
- C. Create an active relationship between the tables and select Apply security filter in both directions.
- D. Create an inactive relationship between the tables and select Assume referential integrity.
正解: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/admin/service-admin-rls
質問 # 170
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
解説:
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
質問 # 171
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 # 172
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?
- A. Admin
- B. Member
- C. Contributor
- D. Viewer
正解:B
解説:
A Member can add members or others with lower permissions.
Note:
質問 # 173
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?
- A. No
- B. Yes
正解:B
解説:
Explanation
https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-apps
質問 # 174
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
- A. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
- B. Use the Test as role option to view data as the Sales role.
- C. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
- D. Use the Test as role option to view data as the salesperson's user account.
正解:B
解説:
Explanation
Validate the roles within Power BI Desktop
* After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.
A picture containing application Description automatically generatedThe View as roles window appears, where you see the roles you've created.Graphical user interface, text, application Description automatically generated

* Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.
* You can also select Other user and supply a given user.Graphical user interface, application Description automatically generated
* Select OK.The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
質問 # 175
You have a Power BI Desktop project that has the model shown in the exhibit. (Click the Exhibit tab.)
Customer Count is a measure that uses the CountRows function to calculate the number of customers.
You create a table visualization that displays ProductID, Product, and Customer Count.
When you view the table, you discover that Customer Count always displays the total number of customers instead of the number of customers who purchased the product.
You need to ensure that the table visualization displays the number of customers who purchased each product.
What should you do?
- A. Modify the Customer Count measure to use the COUNT function.
- B. Modify the Customer Count measure to use the COUNTX function.
- C. Modify the table relationship between the Products table and the Sales table to use a Cross filter direction of Both.
- D. Modify the table relationship between the Customers table and the Sales table to use a Cross filter direction of Both.
正解:D
解説:
https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
質問 # 176
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 # 177
You have a dataset that has the permissions 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.
正解:
解説:
質問 # 178
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a new column to the Product Subcategory table that uses the following formula.
=if [Subcategory] =null then "NA" else [Subcategory]
Which command should you use in Query Editor?
- A. Conditional Column
- B. Invoke Custom Function
- C. Custom Column
- D. Column From Examples
正解:A
解説:
References:
http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
質問 # 179
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Replace the slicers with visual-level filters.
- B. Replace the slicers with report-level filters.
- C. Replace the slicers with page-level filters.
- D. Create a bookmark for each slicer value.
- E. Sync the slicers across the pages.
正解:B、E
解説:
Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
質問 # 180
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.
正解:
解説:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
質問 # 181
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
- A. Add a play axis.
- B. Add a slicer for the year.
- C. From the Analytics pane, add an Average line.
- D. Create a DAX measure that calculates year-over-year growth.
正解:A
解説:
You can set up a date field in play axis, and then scatter chart will animate how measure values are compared to each other in each point of a time.
Reference:
https://radacad.com/storytelling-with-power-bi-scatter-chart
質問 # 182
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.
正解:
解説:
1 - Create a blank query as a data source.
2 - Specify the following query, then close and apply.,,,,,,,,
3 - Create a visual for the query table.
質問 # 183
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.
正解:
解説:
See the answer as below in explanation.
Explanation
Answer as below
A picture containing background pattern Description automatically generated
質問 # 184
Drag and Drop Question
You are modifying a Power BI model by using Power BI Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解:
解説:
Explanation:
FILTER needs to followed by table reference.
AND is needed to check the limits.
CALCULATE because needs to be followed by expression such as distinct in this case.
質問 # 185
......
PL-300サンプルには正確な更新された問題がこちら:https://www.goshiken.com/Microsoft/PL-300-mondaishu.html
PL-300更新された試験問題集で[2026年最新] 練習には有効な試験問題集:https://drive.google.com/open?id=1ou5Sf5yTI1PH5O5jMcm7Aib7AAzpqZvx