PL-300 Dumps Free Test Engine Player Verified Updated [Aug 01, 2025]
Q&As with Explanations Verified & Correct Answers
NEW QUESTION # 63
The Sales table contains records of sales by day from the last five years up until today's date.
You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.
Which DAX expression should you use?
- A. Option D
- B. option C
- C. Option A
- D. Option B
Answer: D
NEW QUESTION # 64
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
NEW QUESTION # 65
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.
Answer:
Explanation:
1 - Transpose the table
2 - Unpivot all the columns other than Measure
3 - Rename the Meeasure column as Year
4 - Change the data type of the Year column to Date
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION # 66
You create a data model in Power BI.
Report developers and users provide feedback that the data model is too complex.
The model contains the following tables.
The model has the following relationships:
*There is a one-to-one relationship between Sales_Region and Region_Manager.
*There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
*There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.
You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
Explanation:
1.Merge [Region_Manager] and [Manager] by using an inner join.
3.Merge [Sales_Region] and [Sales_Manager] by using an inner join.
6.Merge [Sales_Region] and [Region_Manager] by using an inner join.
NEW QUESTION # 67
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.
Which type of visual should you use?
- A. decomposition tree
- B. Q&A
- C. smart narrative
- D. key influencers
Answer: B
NEW QUESTION # 68
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 answer 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 (ALL, ('Product'), [SalesAmount], , DESC, Skip)
- B. Product Ranking= RANKX (ALL, ('Product'), [SalesAmount], , DESC, Dense)
- C. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
- D. Product Ranking= RANKX (ALL ('Product'), [SalesAmount], , Asc, Dense
Answer: B
Explanation:
References: https://msdn.microsoft.com/en-us/library/gg492185.aspx
NEW QUESTION # 69
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. Replace the slicers with report-level filters.
- B. Create a bookmark for each slicer value.
- C. Replace the slicers with visual-level filters.
- D. Sync the slicers across the pages.
- E. Replace the slicers with page-level filters.
Answer: A,D
Explanation:
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.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations 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 # 70
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization .
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Configure a report-level filter.
- B. Edit the interactions of the slicer that is on the same page as the KPI visualization.
- C. Add the same slicer to each page and configure Sync slicers.
- D. Edit the interactions of the KPI visualization.
- E. Configure a page-level filter.
Answer: B,C
NEW QUESTION # 71
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Breadcrumbs
- B. Funnel charts
- C. R visuals
- D. Bubble maps
- E. Custom visuals
Answer: A,C
NEW QUESTION # 72
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 tooltip page, configure filters.
- B. Configure filters on the target visual.
- C. For the target page, set Allow use as tooltip to On.
- D. Add and configure visuals on the tooltip page.
- E. For the tooltip page, set Allow use as tooltip to On.
Answer: C,D,E
Explanation:
Explanation
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.
NEW QUESTION # 73
You have a Power Bl report named Orders that supports the following analysis:
* Total sales over time
* The count of orders over time
* New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.
Answer:
Explanation:
NEW QUESTION # 74
What should you create to meet the reporting requirements of the sales department?
- A. option C
- B. Option D
- C. Option B
- D. Option A
Answer: A
NEW QUESTION # 75
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.
Answer:
Explanation:
Explanation
Text Description automatically generated
Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column.
Box 2: Suppliers table
NEW QUESTION # 76
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?
- A. Add a Top N filter to the visual.
- B. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
- C. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
- D. Configure the Sales Profit measure to use the RANKX function.
Answer: A
Explanation:
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
1. Select the Column you want to display the Top Sales Profit
2. Then change the Filter Type of that Column to Top N
3. Fill in Top / Bottom number field
4. And lastly drag to the By Value filed your Sales Profit Incorrect Answers:
B: You would need a filter as well.
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
NEW QUESTION # 77
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.
Answer:
Explanation:
NEW QUESTION # 78
You receive annual sales data that must be included in Power Bl reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
* Visualizes the Sales value over a period of years and months
* Adds a slicer for the month
* Adds a slicer for the year
Answer:
Explanation:
Explanation:
NEW QUESTION # 79
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
- A. Add the Weekly_Returns data to the Sales table by using related DAX functions.
- B. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
- C. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
Answer: B
Explanation:
Explanation
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
NEW QUESTION # 80
You have the line chart shown in the exhibit. (Click the Exhibit tab.)
You need to modify the chart to meet the following requirements:
* Identify months that have order counts above the mean.
* Display the mean monthly order count.
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.
Answer:
Explanation:
Explanation:
1. Select the line chart
2. Add the average line
3. Turn on Data Label
NEW QUESTION # 81
......
To prepare for the PL-300 exam, candidates should have a strong understanding of data analysis concepts and experience using Power BI for data analysis. Microsoft offers various training courses and resources to help candidates prepare for the exam, including online courses, practice exams, and study guides. Candidates can also gain hands-on experience by working on real-world projects using Power BI.
Verified PL-300 dumps Q&As Latest PL-300 Download: https://freecert.test4sure.com/PL-300-exam-materials.html