Prepare to take the Microsoft PL-300 Microsoft Power BI Data Analyst exam candidates using PL-300 dumps exam material with PDF files and VCE mock exam engine, 100% real and valid.
All Microsoft PL-300 exam candidates are welcome to use PL-300 dumps:https://www.leads4pass.com/pl-300.html, Complete practice with the 268 exam questions and answers provided by leads4pass PL-300 dumps and 100% guarantee your success in the PL-300 Microsoft Power BI Data Analyst certification exam.
Candidates can read the freely available PL-300 dumps exam questions and answers online:
| Number of exam questions | Exam name | From | Release time | PDF Download |
| 13 | Microsoft Power BI Data Analyst | leads4pass | Oct 20, 2022 | Latest pl-300 pdf online |
NEW QUESTION 1:
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Sync the slicers across the pages.
B. Replace the slicers with page-level filters.
C. Replace the slicers with visual-level filters.
D. Create a bookmark for each slicer value.
E. Replace the slicers with report-level filters.
Correct Answer: AE
Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter. You can sync a slicer and use it on any or all pages in a report.
- On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualization panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
NEW QUESTION 2:
HOTSPOT
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.
Hot Area:
Correct Answer:
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 the Visual level filter you should get the 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 the Visual level filter you should get the Top N option.
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
NEW QUESTION 3:
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, You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Instead, modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
NEW QUESTION 4:
HOTSPOT
You have a report page that contains the visuals 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.
Hot Area:
Correct Answer:
Box 1: cross-filter
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
1.
Let\’s see what happens when we select Moderation.
2.
Cross-filtering removes data that doesn\’t apply. Selecting Moderation in the doughnut chart cross-filters the line chart.
The line chart now only displays data points for the Moderation segment.
3.
Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection.
Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.
NEW QUESTION 5:
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets 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. Create one workspace for development. From the new workspace, publish an app for production.
C. Create a workspace for development and a workspace for production. From the production workspace, publish an app.
D. In one 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.
Correct Answer: C
Use different work stages (Development, Test, and Production).
Deploy from the Development workspace.
Reference:
https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/
NEW QUESTION 6:
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answers choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You need to add a measure to rank total sales by product. The results must appear as shown in the following table.
Which DAX formula should you use?
A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
B. Product Ranking= RANKX (ALL, (Product\\’), [SalesAmount], , DESC, Dense)
C. Product Ranking= RANKX (ALL, (Product\’), [SalesAmount], , DESC, Skip)
D. Product Ranking= RANKX (ALL (`Product\’), [SalesAmount], , Asc, Dense
Correct Answer: B
References: https://msdn.microsoft.com/en-us/library/gg492185.aspx
NEW QUESTION 7:
You need to configure access for the sales department users. The solution must meet the security requirements.
What should you do?
A. Add the sales department as a member of the reports workspace
B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
C. Distribute an app to the users in the Azure Active Directory group of the sales department.
D. Share each report with the Azure Active Directory group of the sales department.
Correct Answer: D
NEW QUESTION 8:
HOTSPOT
You have an API that returns more than 100 columns. The following is a sample of column names.
1.
client_notified_timestamp
2.
client_notified_source
3.
client_notified_sourceid
4.
client_notified_value
5.
client_responded_timestamp
6.
client_responded_source
7.
client_responded_sourceid
8.
client_responded_value
You plan to include only a subset of the returned columns. You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Table.RemoveColumns
When you do “Remove Columns” Power Query uses the Table.RemoveColumns function
Box 2: List.Select
Get a list of columns.
Box 3: Text.Contains
Example code to remove columns with a slash (/):
let
Source = Excel.Workbook(File.Contents(“C: Source”), null, true), #”1_Sheet” = Source{[Item=”1″,Kind=”Sheet”]}[Data],
“Promoted Headers” = Table.PromoteHeaders(#”1_Sheet”, [PromoteAllScalars=true]), // get columns which contains
any slash among values
ColumnsToRemove =
List.Select(
// get a list of all columns
Table.ColumnNames(#”Promoted Headers”),
(columnName) =>
let // get all values of a columns ColumnValues = Table.Column(#”Promoted Headers”, columnName), // go through
values and stop when you find the first occurrence of a text containing a slash // if there is a value with a slash, return
true else false ContainsSlash = List.AnyTrue(List.Transform(ColumnValues, each Text.Contains(_, “/”))) in
ContainsSlash ), // remove columns Result = Table.RemoveColumns(#”Promoted Headers”, ColumnsToRemove) in
Result
Reference: https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657
NEW QUESTION 9:
HOTSPOT
You have a table that contains the following three columns:
1.
City
2.
Total Sales
3.
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Total Sales
Box 2: Occupation
Box 3: City
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
NEW QUESTION 10:
HOTSPOT
You have a dataset named Pens that contains the following columns:
1.
Unit Price
2.
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.
Hot Area:
Correct Answer:
Box 1: A scatter plot…
A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.
Box 2: Automatically find clusters
Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
NEW QUESTION 11:
You have the visual shown in the Original exhibit. (Click the Original tab.)
You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)
What should you add to the visual?
A. a measure
B. a trendline
C. a forecast
D. an Average line
Correct Answer: C
Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.
NEW QUESTION 12:
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 historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?
A. scatter chart
B. ribbon chart
C. line chart
D. key influences
Correct Answer: C
The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.
Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.
NEW QUESTION 13:
DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that data attributes can be used as date hierarchies in Microsoft Power BI reports.
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.
Select and Place:
Correct Answer:
1- Convert list to table 2- Expand Column 3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expands columns: https://docs.microsoft.com/en- us/powerquery-m/table-expandrecordcolumn
…
A Pl-300 dumps exam question and answer shared by leads4pass for free in October 2022. Candidates can improve their knowledge by reading online. Candidates are recommended to use leads4pass pl-300 dumps exam materials: https://www.leads4pass .com/pl-300.html (268 Q&A),
Practice the complete PL-300 exam material to help you pass the exam with 100% success.
BTW, download the PL-300 exam questions and answers shared above for free online:https://drive.google.com/file/d/1n9Gg8i1mynmj0hBtikRnA0FH44aMKH8n/
