（2025)PL-300問題集と練習テスト（388問題)
ガイド（2025年最新)リアルなMicrosoft PL-300試験問題
Microsoft PL-300試験は、データモデリング、データ準備、可視化、およびコラボレーションに関連する様々なトピックをカバーしています。候補者は、データ分析と可視化の概念をよく理解し、Power BI環境でそれらを効果的に適用できることが期待されています。さらに、候補者はPower BIツールでの作業経験があり、インタラクティブなレポートやダッシュボードを作成できる能力が必要です。
質問 # 62
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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
- A. No
- B. Yes
正解：B
解説：
Explanation
The WHERE clause has its effects before the data is imported.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
質問 # 63
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:
質問 # 64
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.
正解：
解説：
Explanation:
Answer as selected.
質問 # 65
ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A. Round the Longitude column two decimal places.
- B. Disable the Power Query load.
- C. Change the data type of the TempCelsius column to Integer
- D. Split the DateTime column into separate date and time columns.
正解：B
解説：
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query- query-load
質問 # 66
You have a Power B1 data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content NOTE: Each correct selection is worth one point
正解：
解説：
Explanation:
質問 # 67
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
解説：
Explanation:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions
質問 # 68
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
- A. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.
- B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
- C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
- D. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
正解：A
解説：
Only one relationship can be active.
Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
質問 # 69
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.
正解：
解説：
質問 # 70
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
正解：
解説：
Explanation
Table Description automatically generated
Box 1: Hide
Optimize data by hiding fields and sorting visualization data
Box 2: Delete
The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
質問 # 71
You have a Power BI imported dataset that contains the data model 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.
正解：
解説：
Explanation:
- cross filter direction
- star schema
質問 # 72
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? 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/create-reports/desktop-conditional-table-formatting
質問 # 73
You have a Power 31 data model that contains a table named Stores. The table has the following columns:
* Store Name
* Open Date
* Status
* State
* City
You need to create a calculated column named Active Store Name that meets the following requirements:
正解：
解説：
see the explanation for answer.
Explanation:
Answer is as below
質問 # 74
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.
From Power Query Editor, you profile the data shown in the following exhibit.
The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
- A. No
- B. Yes
正解：A
質問 # 75
You have a report page that contains the visuals 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.
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
質問 # 76
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
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.
正解：
解説：
1 - Transpose the table
2 - Unpivot all the columns other than Measure
3 - Rename the Measure column as Year
4 - Change the data type oh the Year column to Date
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
質問 # 77
You have the Power Bl data model shown in the following exhibit.
You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
質問 # 78
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
- A. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
- B. Add a Top N filter to the visual.
- C. Configure the Sales Profit measure to use the RANKX function.
- D. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the
正解：B
解説：
calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D
Explanation:
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
Select the Column you want to display the Top Sales Profit
Then change the Filter Type of that Column to Top N
Fill in Top / Bottom number field
And lastly drag to the By Value filed your Sales Profit
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
質問 # 79
......
PL-300試験問題集パスできる2025年最新の認証された試験問題：https://jp.fast2test.com/PL-300-premium-file.html
PL-300試験問題リアルな最新問題PDF：https://drive.google.com/open?id=1xLeVePiDUbWPHbXzbY6T4bTzuwZkeFmG