[2023年12月] 最新のMicrosoft PL-300認定練習テスト問題 [Q195-Q220]

[2023年12月] 最新のMicrosoft PL-300認定練習テスト問題

確認済みPL-300問題集と解答で一年間無料最速更新

Microsoft PL-300認定試験に合格すると、候補者がMicrosoft Power BIを使用してデータを分析し、視覚化を作成するスキルと知識を持っていることが示されています。この認定は、データ分析とビジネスインテリジェンスの分野での専門知識の印として世界中の雇用主によって認識されており、新しいキャリアの機会とより高い給与につながる可能性があります。

Microsoft PL-300試験は、候補者がパワーBIの概念と能力を深く理解する必要がある挑戦的なテストです。試験に合格するには、候補者はPower BIツールと機能を使用してデータを分析し、視覚化を作成し、他の人と洞察を共有する能力を実証する必要があります。この試験では、AzureやSharePointなどのクラウドベースのソリューションなど、さまざまなデータソースを使用する候補者の能力も評価します。

Microsoft PL-300 試験に備えるためには、候補者は Power BI プラットフォームをよく理解し、レポートや可視化を作成するためにデータを扱うことに慣れている必要があります。オンラインコース、学習ガイド、模擬試験など、試験に備えるための多くのリソースがあります。これらのリソースを活用することで、候補者は試験に合格し、Microsoft PL-300 認定を取得する可能性を高めることができます。

質問 # 195
The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

A. Option B
B. Option A
C. Option C
D. Option D

正解：B、D

解説：
Answer as.

You publish a dataset lhat 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

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?

質問 # 196
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled.
No anomalies ate detected
You need to increase the likelihood that anomaly detection will identify anomalies in the report.
What should you do?

A. Increase the Expected range transparency setting,
B. Add a data field to the Secondary values field weft
C. Increase the Sensitivity setting.
D. Add a data field to the Legend field well

正解：A

解説：
If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly. reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

質問 # 197
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax

質問 # 198
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?

A. Yes
B. No

正解：B

質問 # 199
You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

A. Feedback
B. Comments
C. Mark as favorite
D. Subscribe

正解：B

解説：
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

質問 # 200
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the virtualizations in the dashboard are updated daily.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

正解：

解説：

1 - Download and install an on-premises data gateway.
2 - For each dataset, modify the Gatewat Connection settings.
3 - For each dataset, modify the Schedule Refresh settings.

質問 # 201
You need to create a visualization to meet the reporting requirements of the sales managers.
HOW Should create the Visualization? TO answer, select the appropriate options in the answer are a.

正解：

解説：

質問 # 202
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

正解：

解説：
see the explanation for the answer.
Explanation
Answer as selected

質問 # 203
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? 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-query/append-queries
https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

質問 # 204
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.
The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:
* Only show single-value visuals.
* Minimize scrolling.
What should you do?

A. Decrease the size of the card visuals. Remove the map and bar chart visuals.
B. Remove the card visual, increase the size of the map and bar chart visuals
C. Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.
D. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.

正解：A

質問 # 205
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

質問 # 206
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format:
2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Create a column by example that starts with 2018-12-31.
C. split the Logged column by using at as the delimiter.
D. Apply a transformation to extract the first 11 characters of the Logged column.

正解：D

解説：
Explanation
According to Microsoft Certified: Power BI Data Analyst Associate , Power Query Editor is a tool that lets you connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop2.
One of the transformations you can perform in Power Query Editor is extract date from text, which creates a date value from a textual representation . For example, given a text column like this:
Logged
2018-12-31 at 08:59
2019-01-01 at 09:15
You can extract the date part by using the Date.FromText function with a specific format4. The result will be:
Logged
Date
2018-12-31 at 08:59
2018-12-31
2019-01-01 at 09:15
2019-01-01
This makes it possible to use a built-in date hierarchy for analysis.

質問 # 207
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

質問 # 208
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value 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.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

質問 # 209
You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

A. (SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])))
/ CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))
B. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID]))
C. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DateID])
D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))

正解：A

解説：
Explanation
SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
Reference:
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

質問 # 210
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

A. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
B. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
C. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

正解：B

解説：
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

質問 # 211
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
* Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
* Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function.
B. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
C. Create a calculated measure that aggregates by using the COUNTROWS function.
D. Create one-to-many relationships between the tables.

正解：A、D

解説：
Explanation
Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

質問 # 212
You need to create a measure that will return the percentage of late orders.
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.

正解：

解説：

質問 # 213
You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.

View2 contains the columns shown in the following table.

正解：

解説：

質問 # 214
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address 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.

正解：

解説：

質問 # 215
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

質問 # 216
You need to create a measure that will return the percentage of late orders.
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.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax

質問 # 217
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation

質問 # 218
You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled.
No anomalies ate detected
You need to increase the likelihood that anomaly detection will identify anomalies in the report.
What should you do?

A. Increase the Expected range transparency setting,
B. Add a data field to the Secondary values field weft
C. Increase the Sensitivity setting.
D. Add a data field to the Legend field well

正解：A

質問 # 219
You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value 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.