Updated PDF (New 2026) Actual Microsoft PL-300 Exam Questions
Verified PL-300 Exam Dumps PDF [2026] Access using itPass4sure
Microsoft PL-300 Exam is ideal for individuals who are looking to work as data analysts or business analysts. PL-300 exam is designed to test the candidates’ competency in creating, managing and interpreting data models with Power BI. Candidates will be required to have a strong understanding of Power BI features and functionality, data modeling techniques, and how to work with and manipulate data.
NEW QUESTION # 60
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.
Answer:
Explanation:
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
NEW QUESTION # 61
You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:
* Customer_Name
* Customer ID
* Website
The Contacts table contains the following columns:
* Contact ID
* Contact Email
* Contact Name
* Customer Name
A web-based contact form is used to fill the Contacts table. The data is not sanitized.
You need to create a merge for the Customer and Contacts tables.
What should you do?
- A. Enable fuzzy matching.
- B. Disable fuzzy matching.
- C. Set Join Kind to Left Outer.
- D. Set Join Kind to Full Outer
Answer: A
NEW QUESTION # 62
You are building a data model for a Power Bl report. You have data formatted as shown in the following table.
You need to create a clustered bar chart as shown in the following exhibit.
What should you do?
- A. From Power Query Editor, split the Machine-User column by using a delimiter.
- B. In a DAX function, create two calculated columns named Machine and User by using the substitute function.
- C. in a DAX function, create two measures named Machine and User by using the substitute function.
- D. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
Answer: A
NEW QUESTION # 63
You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
The reports display the data configured as shown in the following table.
You need to ensure that the users of the reports can locate the correct report by using natural language queries.
What should you do?
- A. From the Format settings of the reports, modify the Page Information.
- B. From the properties of the dataset, modify the Q&A and Cortana settings.
- C. From the properties of the dataset, create four Featured Q&A Questions.
- D. From the properties of the workspace, modify the Language Settings.
Answer: B
Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during- public-preview
NEW QUESTION # 64
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. key influencers
- B. smart narrative
- C. Q&A
- D. decomposition tree
Answer: D
NEW QUESTION # 65
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 # 66
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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 67
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.
Answer:
Explanation:
Answer as below
NEW QUESTION # 68
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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 69
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.
Answer:
Explanation:
NEW QUESTION # 70
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 add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
- A. Table.Distinct
- B. Table.RemoveMatchingRows
- C. Table.ReplaceMatchingRows
- D. Table.InDistinct
Answer: A
Explanation:
References: https://msdn.microsoft.com/en-us/library/mt260775.aspx
NEW QUESTION # 71
You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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:
1 - Create a product hierarchy...
2 - Replace the use of ProductDescription....
3 - Transform the ProductDescription column...
4 - Add the product hierarchy as....
5 - Add a column named ProductName...
6 - Create a product hierarchy of ProductCategory,....
NEW QUESTION # 72
You have a dataset that has the permissions 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.
Answer:
Explanation:
NEW QUESTION # 73
Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
You need to shape the query to display the following three columns:
* Month
* Sales
* Year
'What should you select in Power Query Editor?
- A. Pivot column
- B. Merge columns
- C. Transpose
- D. Unpivot columns.
Answer: D
Explanation:
This will convert your column headers (Jan-20, Feb-20,...) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.
NEW QUESTION # 74
You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
* Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.
* Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 75
You have a Power B1 report that contains the table visual shown in the following exhibit.
You need to modify the visual to display as shown in the following exhibit.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
NEW QUESTION # 76
......
Try Best PL-300 Exam Questions from Training Expert itPass4sure: https://freetorrent.itpass4sure.com/PL-300-practice-exam.html
