PL-300認定の有効な試験問題集解答学習ガイド!(最新の349問題)
PL-300問題集で時間限定!無料アクセスせよ
Microsoft PL-300試験は、Power BIの専門知識を紹介したい個人にとって不可欠な認証です。この認定を取得することで、キャリアの見通しを強化し、データ分析とビジネスインテリジェンスの分野で新しい機会を開くことができます。この試験に合格することにより、候補者はPower BIを使用してビジネスの成功を促進する実用的な洞察にデータを変換する習熟度を証明できます。
質問 # 135
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
解説:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
質問 # 136
You import a Power Bl dataset that contains the following tables:
* Date
* Product
* Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
- A. Remove MovementDate.
- B. Change the data type of UnitCost to Integer.
- C. Remove the relationship between Date and Product Inventory.
- D. Change Summarization for DateKey to Don't Summarize.
正解:A
質問 # 137
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?
- A. From Power BI Desktop, configure the Report settings for the current file.
- B. From Power BI Desktop, modify the data source permissions.
- C. From Power BI Desktop, configure the Data Load settings for the current file.
- D. From the Power BI service, configure the dataset permissions.
正解:D
質問 # 138
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four 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
正解:
解説:
Explanation:
質問 # 139
You are creating a Power Bl report by using Power Bi Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
- A. Q&A
- B. decomposition tree
- C. key influencers
- D. smart narrative
正解:D
質問 # 140
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.
正解:
解説:
Explanation:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%20Distin
質問 # 141
You have a Power Bl report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 # 142
Exhibit:
You need to create a report that meets the requirements:
* Visualizes the Sales value over a period of years and months
* Adds a Slicer for the month
* Adds a Slicer for the year
Which three actions Should you perform in sequence?
正解:
解説:
1 - Select Transpose.
2 - Select the Month and...
3 - Select Unpoivot other columns.
質問 # 143
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
- A. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
- B. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
- C. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- D. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
- E. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
正解:E
質問 # 144
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
- A. Set the Command timeout in minutes setting.
- B. Set Data Connectivity mode to Import.
- C. Set Data Connectivity mode to DirectQuery.
- D. Add a SQL statement.
正解:C
解説:
Explanation
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
質問 # 145
You have the visual shown in the Original exhibit. {Click the Original tab.)
You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)
What should you add to the visual?
- A. an Average line
- B. a measure
- C. a trendline
- D. a forecast
正解:D
解説:
Explanation
Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.
Timeline Description automatically generated with low confidence
Reference:
https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/
質問 # 146
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
* Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
* Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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:
質問 # 147
A user creates a Power B1 report named ReportA that uses a custom theme You create a dashboard named DashboardA.
You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Publish ReportA to the Microsoft Power B1 Community theme gallery.
- B. From DashboardA upload a JSON theme.
- C. From ReportA save the current theme.
- D. From DashboardA create a custom theme.
- E. Publish ReportA to Power Bl.
正解:B、E
質問 # 148
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured 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 solution is worth one point
正解:
解説:
質問 # 149
You have a report in Power BI Desktop.
You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)
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.
正解:
解説:
質問 # 150
You need to create a relationship in the dataset for RLS.
What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 # 151
......
Microsoft PL-300試験実践テスト問題:https://www.goshiken.com/Microsoft/PL-300-mondaishu.html
PL-300問題集で2024年最新のMicrosoft PL-300試験問題:https://drive.google.com/open?id=1k-WJKSCiGjwJtX6yERjMz9FXIxtvoWJv