최신 PL-300 무료덤프 - Microsoft Power BI Data Analyst
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
정답: A
You need to create a Power Bl report. The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
정답:
Explanation:
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You are profiting data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.
정답:
Explanation:
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.
정답:
see the explanation for the answer.
Explanation:
Answer as selected
Explanation:
Answer as selected
You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.
What should you set as the relationship cardinality?
What should you set as the relationship cardinality?
정답: A
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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?
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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have a column named UnitslnStock as shown in the following exhibit
UnitsInStock has 75 non-null values, of which 51 are unique.
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.
UnitsInStock has 75 non-null values, of which 51 are unique.
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:
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.
Which type of visualization should you use?
You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.
Which type of visualization should you use?
정답: C
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You are building a Power Bl report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user s location.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user s location.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: D,E
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.
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.
정답:
Explanation:
Box 1: Top N
Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual.
Then there are more advanced filters.
Box 2: Visual
Once you drag to SKU to Visual level filter you should get Top N option.
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?
정답: D
You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart.
You need to ensure that the bar chart displays on Dashboard',
What should you do?
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart.
You need to ensure that the bar chart displays on Dashboard',
What should you do?
정답: A
You have an app workspace named Retail Analysis in the Power BI service.
You need manage the members that have access to the app workspace.
What should you do?
You need manage the members that have access to the app workspace.
What should you do?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have the Azure SQL databases shown in the following table.
You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
정답:
Explanation:
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?
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
You have a Power BI semantic model named Model1.
You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.
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.
You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.
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:
