PL-300試験無料問題集「Microsoft Power BI Data Analyst 認定」
You have a Power Bi report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?
正解: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 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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
- Due Date
- Order Date
- Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
- Due Date
- Order Date
- Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?
正解:B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the tabular model?
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the tabular model?
正解:A
解答を投票する
Case Study 2 - Contoso Ltd
Overview
Existing Environment
Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.
Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance sheet data is not related to the profit and loss results, other than they both relate to dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.
Net Income Projection Data
Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.

Revenue projections are set at the monthly level and summed to show projections for the quarter.
Balance Sheet Data
The balance sheet data is imported with final balances for each account per month in the format shown in the following table.

There is always a row for each account for each month in the balance sheet data.
Dynamics 365 Business Central Data
Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimal manual effort The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Report Requirements
You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.

The relationships between products and departments to business units must be consistent across all reports.
The board must be able to get the following information from the quarterly reports:
- Revenue trends over time
- Ending balances for each account
- A comparison of expenses versus projections by quarter
- Changes in long-term liabilities from the previous quarter
- A comparison of quarterly revenue versus the same quarter during the
prior year
Which DAX expression should you use to get the ending balances in the balance sheet reports?
CALCULATE (
Overview
Existing Environment
Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.
Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central. The balance sheet data is not related to the profit and loss results, other than they both relate to dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.
Net Income Projection Data
Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.

Revenue projections are set at the monthly level and summed to show projections for the quarter.
Balance Sheet Data
The balance sheet data is imported with final balances for each account per month in the format shown in the following table.

There is always a row for each account for each month in the balance sheet data.
Dynamics 365 Business Central Data
Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimal manual effort The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Report Requirements
You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.

The relationships between products and departments to business units must be consistent across all reports.
The board must be able to get the following information from the quarterly reports:
- Revenue trends over time
- Ending balances for each account
- A comparison of expenses versus projections by quarter
- Changes in long-term liabilities from the previous quarter
- A comparison of quarterly revenue versus the same quarter during the
prior year
Which DAX expression should you use to get the ending balances in the balance sheet reports?
CALCULATE (
正解: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 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 Bl service.
Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload.
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 Bl service.
Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload.
Does this meet the goal?
正解:A
解答を投票する
Hotspot Question
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

Explanation:
Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). For Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
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.

You need to ensure that all the users can access the dashboards.
What should you do first?

You need to ensure that all the users can access the dashboards.
What should you do first?
正解:A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
Hotspot Question
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.

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:
The icons on the tables aren't for DirectQuery mode tables, and Assuming referential integrity is only possible for DirectQuery tables. The cross filter direction should be reviewed, in fact made single for the star schema model design.
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 an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You create aggregations to summarize results.
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 an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You create aggregations to summarize results.
Does this meet the goal?
正解:B
解答を投票する
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 the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
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 the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
正解:B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?
正解:B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have a Power BI report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.
You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.
What should you do?

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.
You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.
What should you do?
正解:B
解答を投票する
Drag and Drop Question
You use Power Query Editor to load two queries named Query1 and Query2.
Query1 results in the following error.

Query2 results in the following error.

Which type of error occurred for each query? To answer, drag the appropriate error types to the correct queries. Each error 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.

You use Power Query Editor to load two queries named Query1 and Query2.
Query1 results in the following error.

Query2 results in the following error.

Which type of error occurred for each query? To answer, drag the appropriate error types to the correct queries. Each error 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.

正解:

Explanation:
Step-level Error: a step-level error prevents the query from loading and displays the error components in a yellow pane Cell-level Error: a cell-level error won't prevent the query from loading but displays error values as Error in the cell.
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year.
You grant users access to the dashboard by using the viewer role on the workspace.
A user wants to receive daily notifications of the number shown on the card visual.
You need to automate the notifications.
What should you do?
You grant users access to the dashboard by using the viewer role on the workspace.
A user wants to receive daily notifications of the number shown on the card visual.
You need to automate the notifications.
What should you do?
正解:B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You have more than 100 published datasets.
Ten of the datasets were verified to meet your corporate quality standards.
You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.
What should you do?
Ten of the datasets were verified to meet your corporate quality standards.
You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.
What should you do?
正解:C
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)