[2024年最新] 高合格率な最新PL-300テストノートとPL-300高合格率な試験ガイドを試そう [Q218-Q239]

Share

[2024年最新] 高合格率な最新PL-300テストノートとPL-300高合格率な試験ガイドを試そう

PL-300実際の問題アンサーPDFには100%カバーリアル試験問題


マイクロソフトPL-300は、マイクロソフトパワーBIデータアナリストになりたいと思っている個人向けに設計された認定試験です。この試験は、マイクロソフトパワーBIを使用して解決策を設計、構築、展開する候補者の能力を測定します。この試験に合格することは、マイクロソフト認定:パワープラットフォームソリューションアーキテクトエキスパート認定を取得するための前提条件です。


Microsoftは、多くの年間ソフトウェア業界のリーディングプレーヤーの一つです。様々なソフトウェアアプリケーションやプラットフォームを開発する経験を豊富に持っているため、同社が認定試験で知られるようになったことは驚くことではありません。そのような試験の1つがMicrosoft PL-300(Microsoft Power BIデータアナリスト)試験です。この試験は、個人がPower BIと効果的に作業するために必要なスキルを検証するために特別に設計されています。

 

質問 # 218
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation
Graphical user interface, text, application Description automatically generated

Box 1: CALCULATE
Box 2: DATEADD
Box 3: DIVIDE
Example:
NET_SALES QoQ% =
IF(
ISFILTERED('Calendar'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_QUARTER = CALCULATE( SUM('research ra_qtr_template'[NET_SALES]), DATEADD('Calendar'[Date].[Date], -1, QUARTER) ) RETURN DIVIDE( SUM('research ra_qtr_template'[NET_SALES]) - __PREV_QUARTER,
__PREV_QUARTER
)
)
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054


質問 # 219
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
* Visualizations that include all measures in the data over time
* Year-over-year calculations for all the measures
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 order.

正解:

解説:

Explanation:
1. Use first row as header
2. Unpivot all columns other than "Measure"
3. Rename "Attribute" to "Year"
4. Change data type of "Year" to date (Date > Year)


質問 # 220
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

解説:

Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/


質問 # 221
You have the following table named Location.

The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.
What should you do?

  • A. Change the name of the Location table to Country.
  • B. Change the Default Summarization of the GeoCode column.
  • C. Replace the values in the GeoCode column with postal codes or zip codes.
  • D. Add a Geoportal column to the Location table.
  • E. Change the Data Type of the GeoCode column.
  • F. Change the name of the GeoCode column to Country.

正解:F

解説:
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks


質問 # 222
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. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID]))
  • B. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
    SAMEPERIODLASTYEAR('Date'[DateID])
  • C. (SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]),
    SAMEPERIODLASTYEAR('Date'[DateID])))
    / CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))
  • D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))

正解:C

解説:
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


質問 # 223
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 (personal).
2 - For each dataset, modify the Geteway Connection settings.
3 - For each dataset, modify the Schedule Refresh settings.


質問 # 224
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:


質問 # 225
You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

  • A. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
  • B. Add a measure to the visual that uses the following DAX expression.
    Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
  • C. Add a measure to the visual that uses the following DAX expression.
    Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40)
  • D. Create a horizontal line that has a fixed value of 24,000.

正解:A

解説:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart


Add percentile lines to monitor daily revenue


質問 # 226
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.

正解:

解説:


質問 # 227
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.

正解:

解説:

1 - Create a blank query as a data source.
2 - Specify the following query, then close and apply.,,,,,
3 - Create a visual for the query table.


質問 # 228
You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.
How should you complete the calculation? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.

正解:

解説:

Explanation:


質問 # 229
You have a Power Bl report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.
What should you do?

  • A. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
  • B. Add the Azure network security team as members of the RLS role.
  • C. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.
  • D. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

正解:A

解説:
Explanation
It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.


質問 # 230
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.

正解:

解説:
Explanation

Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional).
Note:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand


質問 # 231
You have a Power BI dashboard that monitors the quality of manufacturing processes.
The dashboard contains the following elements:
* A line chart that shows the number of defective products manufactured by day.
* A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds 3%.
What should you create?

  • A. a Q&A visual
  • B. a subscription
  • C. a smart narrative visual
  • D. an alert

正解:D


質問 # 232
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.

正解:

解説:

1 - From Power BI Desktope, import the data from Excel, and select Table1 and Table2
2 - From Power Query Editor, append Table2 to Table1.
3 - From power Query Editor, select Table1, and then select Remove duplicates.


質問 # 233
You have the Power Bl data model shown in the following exhibit.

You need to create a measure to count the number of product categories that had products sold during a selected period. 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.

正解:

解説:

Explanation


質問 # 234
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

  • A. 21319 Lasalle Street
  • B. 0
  • C. 1
  • D. 21318 Lasalle Street

正解:A

解説:
Explanation
Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue


質問 # 235
You have the following table named Location.

The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.
What should you do?

  • A. Change the name of the Location table to Country.
  • B. Change the Default Summarization of the GeoCode column.
  • C. Replace the values in the GeoCode column with postal codes or zip codes.
  • D. Add a Geoportal column to the Location table.
  • E. Change the Data Type of the GeoCode column.
  • F. Change the name of the GeoCode column to Country.

正解:F

解説:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks


質問 # 236
You have a report page that contains the visuals 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.

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions


質問 # 237
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

  • A. Transform the sales_amount column to replace negative values with 0.
  • B. Select the sales_amount column and apply a number filter.
  • C. Select Column distribution.
  • D. Select Column profile, and then select the sales_amount column.

正解:D

解説:
Topic 1, Litware, Inc.
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.


質問 # 238
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct 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.
NOTE: Each correct selection is worth one point.

正解:

解説:

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


質問 # 239
......


Microsoft Power BI Data Analyst Examとしても知られるMicrosoft PL-300試験は、データ分析とビジネスインテリジェンスを扱う専門家向けに設計された認定テストです。この認定は、Microsoft Power BIでデータモデルを設計および構築し、レポートと視覚化を作成し、データソースを管理するために必要なスキルと知識を検証します。この試験は、データの分析とビジネス上の意思決定をサポートするための洞察を作成する責任がある個人を対象としています。

 

PL-300試験問題とアンサー:https://www.goshiken.com/Microsoft/PL-300-mondaishu.html

合格できるPL-300試験情報と無料練習テスト:https://drive.google.com/open?id=1Gm2ZoERw5tUbXMvNrmtVAYHxBxITpTxw