PL-300試験無料問題集「Microsoft Power BI Data Analyst 認定」
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.
You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：A,E
解答を投票する
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
正解：D
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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:
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 dataset performance.
Solution: You split the loT 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 dataset performance.
Solution: You split the loT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
正解：A
解答を投票する
You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
正解：
Explanation:
You have a Power Bl query named Sates that imports the columns shown in the following table.
Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.
Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.
正解：C,D
解答を投票する
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.
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:
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
正解：C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
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 an average line by using the Salary measure.
Does this meet the goal?
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 an average line by using the Salary measure.
Does this meet the goal?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You are profiting data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
正解：
Explanation:
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.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
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 change the IOT DateTime column to the Date data type.
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 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 change the IOT DateTime column to the Date data type.
Does this meet the goal?
正解：B
解答を投票する