究極のガイド準備問題PL-300には正確なPDF解答[2023年11月17日]
合格できるMicrosoftの試験問題集
質問 # 190
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.
正解：
解説：
質問 # 191
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
- A. From Model view, set the Subject and Body columns to Hidden.
- B. Remove the Subject and Body columns during the import.
- C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
正解：B
質問 # 192
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
- A. 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]
- 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 Weekly_Returns[week_id]
- E. 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]
正解：A
解説：
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
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.
質問 # 193
You have a Power BI report that contains four pages.
All the pages contain a slicer for a field named Country,
You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?
- A. Sync the Country slicer on page 1, page 2, and page 3,
- B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
- C. Move the Country slicer from page 2 and page 3 to page 1.
- D. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
正解：A
質問 # 194
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? 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-scatter
質問 # 195
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
* The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
* Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point
正解：
解説：
質問 # 196
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A. Column profile
- B. Show whitespace
- C. Column distribution
- D. Column quality
- E. Monospace
正解：A、C
質問 # 197
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
質問 # 198
You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.
There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.
The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce toad times.
Which two actions will reduce the toad times? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Remove the rows in Posts m which Post [Publish Date] is in the last seven days.
- B. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
- C. Remove Posts [Full Text] and Posts [Summary].
- D. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''
- E. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"
正解：C、D
質問 # 199
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
- A. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- B. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- C. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
- D. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
正解：B
質問 # 200
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.
正解：
解説：
質問 # 201
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
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 - Select Use Header as First Row.
2 - Select Department and Product and Unpivot Other Columns.
3 - Rename the Attribute column to Year and the Value column to Revenue.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
質問 # 202
You have the data lineage 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.
正解：
解説：
質問 # 203
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.
正解：
解説：
Explanation
Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/
質問 # 204
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.
正解：
解説：
質問 # 205
......
Microsoft PL-300認定試験は、データアナリストがPower BIでスキルと知識を紹介する優れた方法です。試験に合格することにより、個人はデータモデルの作成と管理、データの視覚化、レポートとダッシュボードの作成、およびデータソースの管理に習熟することができます。この認定は、データアナリストがキャリアを前進させ、収益の可能性を高めるのに役立ちます。
最新PL-300試験問題集で有効で最新の問題集：https://jp.fast2test.com/PL-300-premium-file.html
完全版で最新のPL-300問題集で100%カバー率問題と解答があなたをリアル試験で合格させる：https://drive.google.com/open?id=1xLeVePiDUbWPHbXzbY6T4bTzuwZkeFmG