PL-300 試験問題を無料オンラインアクセス
| 試験コード: | PL-300 |
| 試験名称: | Microsoft Power BI Data Analyst |
| 認定資格: | Microsoft |
| 無料問題数: | 515 |
| 更新日: | 2026-08-05 |
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on- premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Hotspot Question
You have a Power BI semantic model named Model1 that contains a table named Sales.
Sales contains 10 million records and the following data.
The related report displays the weekly sales per region.
You need to minimize the size of Model1.
How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
- Executives require a visual that shows sales by region.
- Regional managers require a visual to analyze weekly sales and
returns.
- Sales managers must be able to see the sales data of their respective region only.
- The sales managers require a visual to analyze sales performance
versus sales targets.
- The sale department requires reports that contain the number of sales transactions.
- Users must be able to see the month in reports as shown in the
following example: Feb 2020.
- The customer service department requires a visual that can be
filtered by both sales month and ship month independently.
- The maximum allowed latency to include transactions in reports is
five minutes.
Hotspot Question
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
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?
Case Study 4 - Contoso Ltd 2
Overview
Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including balance sheets and profit and loss statements for each of the company's four business units.
Existing Environment
Data and Sources
Data for the reports comes from the sources shown in the following table.
The balance sheet data is unrelated to the profit and loss results other than they both relate to dates.
Balance Sheet Data
The balance sheet data is imported and includes the final monthly balances of each account in the format shown in the following table.
The balance sheet data always includes a row for each account for each month.
Product Catalog Data
The product catalog shows how products roll up to product categories, which roll up to the business units. The product list is provided in the format shown in the following table.
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.
Requirements
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Power BI.
The company wants to reduce how long it takes to populate the reports to less than two days.
The company wants to create common logic for the business units, products, and departments.
The logic will 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 minimum manual effort.
The company wants to provide the board with a single package of reports that will contain 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. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Contoso identifies the following security requirements for analyst access:
- Analysts must be able to access all balance sheet and product catalog data.
- Analysts must be able to access only the profit and loss data of their respective business unit.
- Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.
- Analysts must NOT be able to share the quarterly reports with anyone.
- Analysts must NOT be able to make new reports by using the balance sheet data.
Report Requirements
You plan to relate the balance sheet table to a date table in Power BI 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.
The date table will contain the columns shown in the following table.
The definitions and attributes for the products, departments, and business units must be consistent across all the reports.
The board must be able to get the following information from the quarterly reports:
- Revenue trends over time
- The ending balances of each account
- Changes in long-term liabilities from the previous quarter
- The percent of total revenue contributed by each product category
- A comparison of quarterly revenue versus the same quarter from the previous year
- The reports must be updated with the latest data by 5 AM each day.
You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.
What should you set as the relationship cardinality?