無料提供中のPL-300試験問題集で（2024年最新のPDF問題集）信頼度の高いテストエンジン
PL-300のPDFで最近更新された問題です集試験点数を伸ばそう
Microsoft PL-300試験は、Power BIの専門知識を紹介したい個人にとって不可欠な認証です。この認定を取得することで、キャリアの見通しを強化し、データ分析とビジネスインテリジェンスの分野で新しい機会を開くことができます。この試験に合格することにより、候補者はPower BIを使用してビジネスの成功を促進する実用的な洞察にデータを変換する習熟度を証明できます。
試験では、データモデリング、データ準備、可視化開発、コラボレーションなど、さまざまなトピックがカバーされます。候補者は、DAXおよびM言語をしっかりと理解しており、Power Query、Power Pivot、その他のPower BIツールの経験も必要です。
質問 # 179
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.
正解：
解説：
質問 # 180
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
質問 # 181
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
正解：
解説：
Explanation:
Graphical user interface, text, application, email Description automatically generated
質問 # 182
You have a Power Bl report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to S. You need to formal the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.
Which three actions should you perform in sequence in Power B) Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
解説：
Explanation:
質問 # 183
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. 21318 Lasalle Street
- D. 1
正解：A
解説：
Example:
Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
質問 # 184
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
- A. Change the report theme.
- B. Edit the details of each tile.
- C. Create a custom CSS file.
- D. Change the dashboard theme.
正解：D
解説：
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#how-dashboard-themes-work
質問 # 185
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 186
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
The IOT ID columns are unique to each row in query.
You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
- A. No
- B. Yes
正解：A
質問 # 187
In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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.
正解：
解説：
質問 # 188
You have the dashboard shown in the following exhibit.
You need to modify the dashboard to display as shown in the following exhibit.
What should you do?
- A. Apply the Dark dashboard theme.
- B. Create and apply a custom dashboard theme.
- C. Change the colors of the visuals in the report.
- D. Upload a snapshot image of the dashboard.
正解：A
質問 # 189
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? 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-quick-measures
質問 # 190
DRAG DROP
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? 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.
正解：
解説：
質問 # 191
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
- A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
- B. Instruct each user to install Microsoft Office 2016.
- C. From the properties of each dashboard, modify the Share dashboard settings.
- D. From the Power BI Admin portal, modify the Privacy Settings.
正解：A
解説：
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
質問 # 192
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
- A. Use the Test as role option to view data as the Sales role.
- B. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
- C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
- D. Use the Test as role option to view data as the salesperson's user account.
正解：A
解説：
Validate the roles within Power BI Desktop
After you've created your roles, test the results of the roles within Power BI Desktop. From the Modeling tab, select View as.
Select a role you created, and then select OK to apply that role. The report renders the data relevant for that role.
Select OK. The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
質問 # 193
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
質問 # 194
Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)
You need to ensure that all the users can access the dashboards.
What should you do first?
- A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
- B. Instruct each user to install Microsoft Office 2016.
- C. From the properties of each dashboard, modify the Share dashboard settings.
- D. From the Power BI Admin portal, modify the Privacy Settings.
正解：A
解説：
Explanation
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
質問 # 195
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 Gateway connection settings.
3 - For each database, modify the Schule Refreash settings.
質問 # 196
You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.
You add a sheer named Country to each page of the report.
You need to configure the report to meet the following requirements:
* When a user selects a country on the first page, the report must filter the other pages.
* The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.Ther NOTE Each correct selection is worth one point.
正解：
解説：
Explanation
質問 # 197
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
- A. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
- B. Create a text box for each business question and insert a link.
- C. Create a button for each business question and set the action type to Bookmark.
正解：C
質問 # 198
You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles.
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.
正解：
解説：
1 - Import the data to Power BI Desktop.
2 - Create a role definition.
3 - Assign users to the role.
質問 # 199
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html
質問 # 200
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.
正解：
解説：
質問 # 201
You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 202
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
質問 # 203
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 measure that aggregates by using the COUNTROWS function.
- C. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
- D. Create one-to-many relationships between the tables.
正解：A、D
解説：
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.
質問 # 204
......
PL-300完全版問題集には無料PDF問題で合格させる：https://jp.fast2test.com/PL-300-premium-file.html
無料Microsoft Certified: Power BI Data Analyst Associate PL-300公式認定ガイドPDFダウンロード：https://drive.google.com/open?id=1U2HGI1XFtMJcdi21fURcvB-p8p2P9g67