Microsoft PL-300リアル試験問題保証付き更新された問題集
検証済み！合格できるPL-300試験一発合格保証付き
質問 # 80
HOTSPOT
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.
正解：
解説：
質問 # 81
The data model must support the following analysis:
Total sales by product by month in which the order was placed
Quantities sold by product by day on which the order was placed
Number Of sales transactions by quarter in Which the order was placed
For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.
正解：
解説：
Explanation
質問 # 82
ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A. Change the data type of the TempCelsius column to Integer
- B. Round the Longitude column two decimal places.
- C. Disable the Power Query load.
- D. Split the DateTime column into separate date and time columns.
正解：C
解説：
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query- query-load
質問 # 83
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 salesperson's user account.
- B. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
- C. Use the Test as role option to view data as the Sales role.
- D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
正解：A
解説：
Explanation
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.
A picture containing application Description automatically generatedThe View as roles window appears, where you see the roles you've created.Graphical user interface, text, application Description automatically generated
* Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.
* You can also select Other user and supply a given user.Graphical user interface, application Description automatically generated
* 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
質問 # 84
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
What should you recommend?
- A. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
- B. In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
- C. Create separate workspaces for development and production. Grant the end users access to the production workspace.
- D. Create one workspace for development. From the workspace, publish an app for production.
正解：C
質問 # 85
You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.
正解：
解説：
Explanation
質問 # 86
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?
- A. No
- B. Yes
正解：B
解説：
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php
質問 # 87
You have a Power BI model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:
正解：
解説：
Explanation:
質問 # 88
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 89
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)
What occurred at 12:03:06 PM?
- A. The dashboard tile cache refreshed.
- B. A new transaction was added to the data source.
- C. A user added a comment to a tile.
- D. A user pressed F5
正解：D
解説：
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
質問 # 90
You use Power 81 Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.
You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
- A. Use Power Query to combine long running queries into one query.
- B. Disable query folding on long running queries
- C. Split long running queries into subsets Of columns and use power Query to the queries
- D. Reduce number of rows and columns returned by each query.
正解：A、B
質問 # 91
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
正解：
解説：
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
質問 # 92
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
質問 # 93
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
質問 # 94
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 Power BI Admin portal, modify the Privacy Settings.
- B. Instruct each user to install Microsoft Office 2016.
- C. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
- D. From the properties of each dashboard, modify the Share dashboard settings.
正解：C
解説：
References:
http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/
質問 # 95
......
今すぐダウンロード！リアルMicrosoft PL-300試験問題集テストエンジン試験問題：https://www.goshiken.com/Microsoft/PL-300-mondaishu.html
無料PL-300サンプル問題には100%カバー率リアル試験問題：https://drive.google.com/open?id=1B1zWnr4YqBDEdBUI90fwdg_X_05c-snd