PL-300 無料問題集「Microsoft Power BI Data Analyst」
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 a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From the Power BI service, get the data from SharePoint Online, and then click Connect Does this meet the goal?
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 a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From the Power BI service, get the data from SharePoint Online, and then click Connect Does this meet the goal?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正解：A、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
The tables have the following relationships.
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the CityID column from the Sales table.
Does this meet the goal?
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the CityID column from the Sales table.
Does this meet the goal?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You use Power BI Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
正解：A、B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.
File1 Is moved to a different folder.
When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.
You need to ensure that the data in File1 refreshes properly.
What should you do?
File1 Is moved to a different folder.
When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.
You need to ensure that the data in File1 refreshes properly.
What should you do?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
The data model must support the following analysis:
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.
正解：
Explanation:
The scenario establishes that the data model must support the following analysis: Total sales by product by month in which the order was placed Quantities sold by product by day on which the order was. The selections in the retained answer exhibit are the verified configuration. The relationship must carry filters from the descriptive table to the transaction table through matching keys. Bidirectional filtering is reserved for a demonstrated need because it can introduce multiple active paths. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. The current PL-300 study guide places this under the objective " Define a relationship ' s cardinality and cross-filter direction " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop- relationships-understand | PL-300 objective: " Define a relationship ' s cardinality and cross-filter direction "
| Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
You are creating reports in Power BI Desktop. The model has the following tables.
There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the semantic model that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the semantic model that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
The selections in the retained answer exhibit are the verified configuration. The relationship must carry filters from the descriptive table to the transaction table through matching keys. Bidirectional filtering is reserved for a demonstrated need because it can introduce multiple active paths. What determines the answer is the need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the semantic model that is published. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. For exam alignment, this is assessed under " Define a relationship ' s cardinality and cross-filter direction " in the current study guide.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop- relationships-understand | PL-300 objective: " Define a relationship ' s cardinality and cross-filter direction "
| Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
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.
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.
正解：
Explanation:
The M transformation belongs in the query pipeline, where source values can be cleaned, split, filled, renamed, or typed consistently. A report visual or DAX measure would operate too late in the process. Use the selections preserved in the answer exhibit as the supported configuration. The relevant context is that 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. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This rationale is anchored to the PL-300 objective " Evaluate data, including data statistics and column properties "
.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Evaluate data, including data statistics and column properties " | Study guide: https://learn.microsoft.com/en- us/credentials/certifications/resources/study-guides/pl-300
Each employee has one manager as shown in the ParentEmployeelD column,
All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
Which DAX expression should you use?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You use Power Query Editor to preview customer feedback data.
You need to use AI Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
; What the customers most often provide feedback about
; Whether the customers like your company's product
; The language of the feedback
Which AI Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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.
You need to use AI Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
; What the customers most often provide feedback about
; Whether the customers like your company's product
; The language of the feedback
Which AI Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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:
The retained answer-area mapping contains the correct selections. The scenario is asking for a way to apply AI Insights services that extract recurring topics, sentiment, and language from customer feedback. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. This is a shaping operation in Power Query. Performing it in the applied steps produces correctly typed, named, and structured columns before loading, which keeps report and model logic focused on analysis. In Microsoft ' s current exam outline, the corresponding objective is " Create and transform columns " . This keeps the query output reproducible at refresh and leaves the semantic model with the grain and schema required by the report.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Create and transform columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications
/resources/study-guides/pl-300
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 GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve semantic model performance.
Solution: You split the IoT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
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 GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve semantic model performance.
Solution: You split the IoT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a Power BI semantic model.
You discover that he semantic model contains values that display as errors.
You need to use data profiling feature in Power Query to preview the date and identify the issues.
What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
You discover that he semantic model contains values that display as errors.
You need to use data profiling feature in Power Query to preview the date and identify the issues.
What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
正解：
Explanation:
What determines the answer is the need to use data profiling feature in Power Query to preview the date and identify the issues. The selections in the retained answer exhibit are the verified configuration. Column profile and column distribution expose value frequency, distinct and unique counts, errors, empty values, and statistics for the selected field. Those diagnostics answer a data-quality question without changing the source values. A transformation that replaces, removes, or filters values would change the data before the analyst has quantified the problem; profiling is the diagnostic step. The current PL-300 study guide places this under the objective " Resolve data import errors " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/data-profiling-tools | PL-300 objective: " Resolve data import errors " | Study guide: https://learn.microsoft.com/en-us/credentials
/certifications/resources/study-guides/pl-300
You have two CSV files named Products and Categories.
The Products file contains the following columns:
ProductID
ProductName
SupplierID
CategoryID
The Categories file contains the following columns:
CategoryID
CategoryName
CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI semantic model that will contain a single table named Product. The Product will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The Products file contains the following columns:
ProductID
ProductName
SupplierID
CategoryID
The Categories file contains the following columns:
CategoryID
CategoryName
CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI semantic model that will contain a single table named Product. The Product will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
The key constraint is to create a Power BI semantic model that will contain a single table named Product. The Product will table includes the following columns: ProductID ProductName SupplierID. The completed mapping shown in the answer area is correct. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. The M transformation belongs in the query pipeline, where source values can be cleaned, split, filled, renamed, or typed consistently. A report visual or DAX measure would operate too late in the process. The current skills outline describes this competency as " Create and transform columns " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Create and transform columns " | Study guide: https://learn.microsoft.com/en-us/credentials/certifications
/resources/study-guides/pl-300
From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Datasource.Error: could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正解：A、B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have the following table named Location.
The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit.
You need to ensure that the map displays the country locations.
What should you do?
The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit.
You need to ensure that the map displays the country locations.
What should you do?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)