[2026年05月31日] 無料Microsoft PL-300試験問題と解答
検証済みPL-300問題集と解答は最新PL-300をダウンロード
Microsoft PL-300認定試験の準備には、データ分析と視覚化の概念、およびMicrosoft Power BIの実践的な経験を確実に理解する必要があります。候補者は、Microsoftやその他のプロバイダーが提供するトレーニングコースと練習試験を活用し、実際の環境でPower BIを操作する実践的な経験を積むことをお勧めします。
Microsoft Power BI Data Analystとして認定されるためには、個人はPL-300試験に合格する必要があります。この認定は、データ分析およびビジネスインテリジェンスの分野で働く専門家にとって貴重な資格です。これは、個人がPower BIを使用してデータを分析および可視化し、効果的なレポートとダッシュボードを作成する必要なスキルを持っていることを示しています。この認定は、個人がその分野での専門知識を示し、潜在的な雇用主に対して信頼性を高めることで、キャリアを進めるのに役立ちます。さらに、この認定は、Power BIを使用する必要なスキルを持ち、データに基づく意思決定を支援できる個人を組織が特定するのに役立ちます。
質問 # 88
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password tor the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
質問 # 89
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 add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
- A. Table.Distinct
- B. Table.RemoveMatchingRows
- C. Table.InDistinct
- D. Table.ReplaceMatchingRows
正解：A
解説：
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx
質問 # 90
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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.
正解：
解説：
質問 # 91
You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.
You have a table named Transaction Size that contains the following data.
正解：
解説：
質問 # 92
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?
- A. Add a description of "subscriber count" to the Customer Count measure.
- B. Add a description of "Subscriber" to the Customer table.
- C. Set Summarize By to None for the CustomerlD column.
- D. Add a synonym of "subscriber" to the Customer table.
正解：C
解説：
You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices
質問 # 93
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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.
正解：
解説：
質問 # 94
You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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 - Add a column named ProductName that contants,,,,,,,,
2 - Create a product hierarchy of ProductCategory,,,,,,,,,,
3 - Replace the use of ProductDescription in the report with the product hierarchy.
質問 # 95
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. From Power Query, merge the Order Line Items query and the Products query.
- D. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.
正解：C
解説：
https://www.sqlbi.com/articles/header-detail-vs-star-schema-models-in-tabular-and-power-bi/
質問 # 96
You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.
View2 contains the columns shown in the following table.
The views can be related based on the Class ID column.
Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID.
You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:
* The count of classes that occur by period
* The count of students in attendance by period by day
* The average number of students attending a class each month
In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
Teacher dimension
Class dimension
質問 # 97
You build a Power BI report that displays IoT temperature data streaming from a refrigerator.
You publish the report to the Power BI service.
You need to be notified when the temperature rises above four degrees Celsius.
What should you do?
- A. Pin a card visual to a dashboard and set an alert on the tile.
- B. Pin a report page to a dashboard and set an alert on the page.
- C. Pin a card visual to a dashboard and create a subscription.
- D. Set an alert on a KPI visual in the report.
正解：A
解説：
You can set alerts in dashboards only for gauge/card/KPI visuals and not for the entire report.
質問 # 98
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.
正解：
解説：
Explanation
質問 # 99
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
- A. Edit the details of each tile.
- B. Change the report theme.
- C. Change the dashboard theme.
- D. Create a custom CSS file.
正解：C
解説：
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#how-dashboard-themes- work
質問 # 100
Hotspot Question
You have a Power BI semantic model that contains two tables as 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.
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.
正解：
解説：
質問 # 101
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m 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:
From Power BI Desktop, select Get Data, and then select Folder.
From Power Query Editor, remove the Content column.
From Power Query Editor, expand the Attributes column.
質問 # 102
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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
- A. No
- B. Yes
正解：B
質問 # 103
You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?
- A. Configure a bi-directional relationship between Region and Sales.Region.
- B. Apply row-level security (RLS) to the Region table based on the sales manager username.
- C. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
- D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.
正解：C
質問 # 104
You are creating a Power 81 model to analyze inventory.
You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.
Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.
How should you complete the measure? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
正解：
解説：
Explanation:
質問 # 105
You have a Power Bl workspace that contains a single-page report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the 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 - Open Power BI Desktop
2 - Open the Sales report
3 - Pin the page
質問 # 106
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
正解：
解説：
質問 # 107
......
マイクロソフトPL-300認定試験は、様々な業界でデータを扱うプロフェッショナルにとって貴重な資格です。Power BIの強い理解と、効果的なデータ分析と可視化ソリューションを作成する能力を証明します。この試験は、技術的なスキルだけでなく、批判的思考力と問題解決能力も試験するように設計されています。試験に合格した個人は、データ駆動型の洞察を活用して、情報に基づくビジネス上の意思決定を行う組織が増えるにつれて、求人市場で高い需要があることが期待されます。
リアル問題集を使おう 100%無料PL-300試験問題集：https://www.goshiken.com/Microsoft/PL-300-mondaishu.html
更新された100%カバー率リアルPL-300試験問題で100%合格保証：https://drive.google.com/open?id=12ZVtEumpN6a4rF6QgB5Dvw8fNgF8z15K