最新のPL-300実際の無料試験問題更新された424問あります
無料で使えるPL-300試験ブレーン問題集認定ガイドの問題と解答
質問 # 167
In Power BI Desktop, you are creating a report that will contain three pages.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
- A. For the target page, set Allow use as tooltip to On.
- B. Configure filters on the target visual.
- C. For the tooltip page, configure filters.
- D. Add and configure visuals on the tooltip page.
- E. For the tooltip page, set Allow use as tooltip to On.
正解：A、D、E
解説：
You can create a custom tooltip page that shows more details about the selected category, such as this:
To create a custom tooltip page and prepare it for use, you need to perform these three actions34:
* Add and configure visuals on the tooltip page. You can add any visuals, images, or other items that you want to show on the tooltip page. You can also format them as you like.
* For the tooltip page, set Allow use as tooltip to On. This will enable Power BI to recognize this page as a tooltip page. You can also change the Page size to Tooltip to fit your content better.
* For the target visual, set Tooltip type to Report page. This will allow you to select which report page
* you want to use as a custom tooltip for your visual. You can also filter your tooltip by fields from your target visual.
質問 # 168
You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.
You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:
* Create reports that use the HR dataset.
* Publish the reports to WorkspaceB.
* Prevent the ability to modify the HR dataset.
* Prevent the ability to add users to WorkspaceB.
正解：
解説：
See the explanation for the answer.
Explanation
Answer is as below.
質問 # 169
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.
正解：
解説：
質問 # 170
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)
質問 # 171
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.
正解：
解説：
Explanation:
Graphical user interface, application Description automatically generated
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ...]]])
Expression - The expression to be evaluated.
filter1, filter2,... (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(<table>,<filter>)
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or
[Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date.
Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax
質問 # 172
For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing dat a. The solution must minimize development effort. Which type ol data source should you use?
- A. Power Bl dataflows
- B. an Excel workbook
- C. a SharePoint folder
- D. Power Bl dataset
正解：D
解説：
case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.
質問 # 173
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.
正解：
解説：
Explanation:
Graphical user interface, application Description automatically generated
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ...]]])
Expression - The expression to be evaluated.
filter1, filter2,... (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(<table>,<filter>)
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or
[Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date.
Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax
質問 # 174
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 Traffic in which Traffic [URL visited] does not contain "blog''
- B. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"
- C. Remove the rows in Posts m which Post [Publish Date] is in the last seven days.
- D. Remove Posts [Full Text] and Posts [Summary].
- E. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
正解：A、D
質問 # 175
You have a Power Bl semantic model that contains a table named Opportunity.
The Opportunity table contains a column named Qualification
The Qualification column contains values between 0 and V
You need to build a new measure to score the opportunities on a scale of low, medium, and high.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
質問 # 176
You create a Power Bl dataset that contains the table shown in the following exhibit.
You need to make the table available as an organizational data type In Microsoft Excel.
How should you configure the properties of the table? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 177
You have a Power BI tenant that contains a workspace named WS1. WS1 contains the following items:
- A semantic model named SM1.
- A report named RPT1 that is connected to SM1.
- A report named RPT2 that is connected to SM1.
- A report named RPT3 that is connected to SM1.
- A dashboard named DB1 that contains content from RPT1 and RPT2.
You need to grant workspace access to a group named Group1. The solution must meet the following requirements:
- Group1 must be able to view RPT1, RPT2, and DB1.
- Group1 must be prevented from viewing RPT3.
- Group1 must be prevented from creating new reports and dashboards by
using SM1.
- Group1 must be prevented from sharing the reports and dashboards to
other users.
- Administrative effort must be minimized.
What should you do?
- A. Store PBIX files in a shared folder in Microsoft OneDrive.
- B. Publish an app.
- C. Share each item individually.
- D. Assign Group1 the Viewer role for WS1.
正解：B
解説：
Publishing an app in Power BI allows you to control which reports and dashboards are accessible to a specific audience while keeping administrative effort minimal. This approach meets all the given requirements:
- Group1 can view RPT1, RPT2, and DB1 (you can include only these reports in the app).
- Group1 is prevented from viewing RPT3 (since RPT3 will not be included in the app).
- Group1 cannot create new reports or dashboards using SM1 (viewers of the app cannot modify the dataset).
- Group1 cannot share reports and dashboards (app viewers cannot share content).
- Minimal administrative effort (you only need to manage access to the app instead of configuring individual report permissions).
質問 # 178
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.
正解：
解説：
Explanation:
質問 # 179
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.
正解：
解説：
質問 # 180
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?
- A. Change the data type of sales [region_id] to Decimal Number.
- B. Change the data type of sales[sales_id] to Text.
- C. In the Sales table, add a measure for sum(sales_amount).
- D. Change the data type of Sales[region_id] to Whole Number.
正解：D
解説：
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).
質問 # 181
The table has the following columns.
You need to add a column that will be used to sort the Year Month column chronologically.
正解：
解説：
See the answer in explanation.
Explanation
Answer as.
Graphical user interface, application Description automatically generated
質問 # 182
......
PL-300認定概要最新のPL-300のPDF問題集：https://jp.fast2test.com/PL-300-premium-file.html
トップクラスMicrosoft PL-300試験材料で学習ガイド！練習問題バージョン：https://drive.google.com/open?id=1U2HGI1XFtMJcdi21fURcvB-p8p2P9g67