あなたを余裕でPL-300試験合格させます！100%試験高合格率保証 [2023]
PL-300問題集本日限定！無料アクセスが可能に！fromFast2test
PL-300認定試験は40-60の複数選択の質問で構成されており、候補者は試験を完了するのに2時間あります。試験に合格するには、候補者は1000ポイントのうち少なくとも700点を獲得する必要があります。この試験は、英語、フランス語、ドイツ語、日本、韓国語、ポルトガル語、スペイン語など、複数の言語で利用できます。
Microsoft PL-300 認定試験には、ビジネス要件の理解、データモデルの作成、Power BI によるデータの可視化、Power BI コンテンツの共有と協働など、様々なトピックが含まれています。この認定を受けるためには、データ分析、データモデリング、データ可視化の基礎的な理解が必要です。加えて、候補者は、Power BI サービスについて、その様々な機能と能力を知っている必要があります。
質問 # 64
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
質問 # 65
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.
正解：
解説：
Explanation
Graphical user interface, text, application, email Description automatically generated
References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
質問 # 66
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 following 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.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?
- A. Change the data type of the Logged column to Date.
- B. Apply a transform to extract the first 11 characters of the Logged column.
- C. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
正解：D
質問 # 67
You are building a data model for a Power Bl report. You have data formatted as shown in the following table.
You need to create a clustered bar chart as shown in the following exhibit.
What should you do?
- A. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
- B. In a DAX function, create two calculated columns named Machine and User by using the substitute function.
- C. From Power Query Editor, split the Machine-User column by using a delimiter.
- D. in a DAX function, create two measures named Machine and User by using the substitute function.
正解：C
質問 # 68
You have a report in Power BI Desktop 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 selection is worth one point.
正解：
解説：
Explanation
Graphical user interface, text Description automatically generated with medium confidence
質問 # 69
You have a report in Power Bl named report1 that is based on a shared dataset.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?
- A. Apply row-level security (RLS) to the shared dataset.
- B. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
- C. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
- D. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.
正解：D
質問 # 70
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? 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/visuals/power-bi-visualization-kpi
質問 # 71
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.
正解：
解説：
Explanation
Diagram, table Description automatically generated
References:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
質問 # 72
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.
正解：
解説：
質問 # 73
HOTSPOT
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
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.
正解：
解説：
質問 # 74
You have the following three versions of an Azure SQL database:
* Test
* Production
* Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
- A. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
- B. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
- C. Create a query for each database server and hide the development tables.
- D. Create a parameter and update the queries to use the parameter.
正解：D
解説：
Explanation
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-st
質問 # 75
You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?
- A. Q&A
- B. funnel chart
- C. key influencers
- D. decomposition tree
正解：D
解説：
Explanation
The key influencers visual is a great choice if you want to:
See which factors affect the metric being analyzed.
Contrast the relative importance of these factors. For example, do short-term contracts affect churn more than long-term contracts?
Note: The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
質問 # 76
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
- A. Transpose.
- B. Split the model into multiple models.
- C. Hide unused columns in the model.
- D. Merge tables by using Power Query.
正解：D
解説：
Explanation
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you'd like to add to another query, you merge the queries.
Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
質問 # 77
You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.)
You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit.
(Click the Mobile tab.) What should you do?
To answer, select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 78
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])
- B. (SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])))
/ CALCULATE(SUM('Sales'[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])) - C. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]))
- D. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID]))
正解：B
解説：
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
質問 # 79
You have a Power Bl model that contains two tables named Population and Date.
The Population table contains two columns named Population Amount and Date Key.
DateKey contains date values that represent the first day of a year and are used to create a many-to The Power Bl model contains two measures that have the following definitions.
Total Population = Sum ('Population'[Population Amount])
2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
- A. one row per year that contains blank values for every year except 2023
- B. one row per date that contains the population value for the corresponding year repeated in each row
- C. a single row for the year 2023 that contains the related population value
- D. one row per year that contains the same value repeated for each year
正解：C
質問 # 80
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
質問 # 81
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. Create a horizontal line that has a fixed value of 24,000.
- B. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40) - C. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
- D. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
正解：D
解説：
Explanation
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
質問 # 82
You have a column named UnitslnStock as shown in the following exhibit
正解：
解説：
質問 # 83
......
マイクロソフトのPL-300試験、別名マイクロソフトパワーBIデータアナリスト試験は、Microsoft Power BIを使用したデータ分析スキルを証明したい個人を対象としています。この試験は、データ分析者やビジネスインテリジェンスプロフェッショナルが、データ可視化、レポート作成、データ分析にPower BIを使用している場合に適しています。この試験は、Power Apps開発者試験、パワープラットフォーム機能コンサルタント試験など、他の試験も含まれるマイクロソフトパワープラットフォーム認定プログラムの一部です。
学習材料は有効なPL-300効率的問題集：https://jp.fast2test.com/PL-300-premium-file.html
最新Microsoft Certified: Power BI Data Analyst Associate PL-300実際の無料試験解答：https://drive.google.com/open?id=1xLeVePiDUbWPHbXzbY6T4bTzuwZkeFmG