[2025-December-New]Braindump2go PL-300 Exam Prep Free[Q371-Q411]
2025/December Latest Braindump2go PL-300 Exam Dumps with PDF and VCE Free Updated Today! Following are some new Braindump2go PL-300 Real Exam Questions!
QUESTION 371
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Change any DAX measures to use iterator functions.
B. Implement row-level security (RLS).
C. Replace the default visuals with AppSource visuals.
D. Split the visuals onto multiple pages.
Answer: D
QUESTION 372
Hotspot Question
You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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:
QUESTION 373
Hotspot Question
You have a Power BI report that contains a page. The page contains the following visuals:
– A card
– A matrix
– A bar chart
You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix. The card and the bar chart must change when a user selects a cell in the matrix.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#change-the-interactions-of-drillable-visualizations
By default, a matrix will have “Entire Page” in the “Apply drill down filters to” option inside the Format tab, which is what we don’t want to happen, so changing to “Selected Visual” should give us the behavior we want
QUESTION 374
You have a Power BI model that contains two tables named Population and Date.
The Population table contains two columns named PopulationAmount and DateKey.
DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table.
The Power BI model contains two measures that have the following definitions.
Total Population = Sum(‘Population’[PopulationAmount])
2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
A. one row per year that contains blank values for every year except 2023
B. one row per date that contains the population value for the corresponding year repeated in each row
C. a single row for the year 2023 that contains the related population value
D. one row per year that contains the same value repeated for each year
Answer: D
QUESTION 375
You publish a dataset to the Power BI service. The dataset contains a connection to an on-premises Microsoft SQL Server database.
You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway.
You confirm the following with the administrator of the gateway:
– You have the appropriate permissions to use the gateway.
– The data source was created on the gateway.
– The gateway has a status of Running.
What is the most likely reason the gateway is unavailable?
A. The type of data source is not supported by the on-premises data gateway.
B. The server name in the PBIX file does not match the data source name in the gateway.
C. The credentials for the data source are invalid.
D. The data source is configured to use single sign-on (SSO).
Answer: B
Explanation:
In Power BI, when you configure a data source to use an on-premises data gateway, the server name and other connection details in your PBIX file must match the data source configuration in the gateway. If there’s a mismatch in the server name or other connection details, the scheduled refresh won’t work, and you won’t be able to select the appropriate gateway.
QUESTION 376
Hotspot Question
You have a folder that contains 50 JSON files.
You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.
Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
QUESTION 377
You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.
You are notified that the Excel data source was moved to a new location.
You need to update the PBIX file to use the new location.
What are three ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. From the Datasets settings of the Power BI service, configure the data source credentials.
B. From the Data source settings in Power BI Desktop, configure the file path.
C. From Current File in Power BI Desktop, configure the Data Load settings.
D. From Power Query Editor, use the formula bar to configure the file path for the applied step.
E. From Advanced Editor in Power Query Editor, configure the file path in the M code.
Answer: BDE
QUESTION 378
You are reviewing a Power BI data model.
You have a calculated table that has the following definition.
ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )
You need to identify the results of the DAX expression.
Which rows will be returned in ProductList?
A. all the rows in ProductsGroupB that have a matching row in ProductsGroupA
B. all the rows in both tables
C. all the rows in ProductsGroupA that have a matching row in ProductsGroupB
D. all the rows in ProductsGroupA that have no matching row in ProductsGroupB
Answer: C
Explanation:
https://learn.microsoft.com/en-us/dax/intersect-function-dax
QUESTION 379
You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount.
You need to create the visual shown in the following exhibit.
In which section of the Fields well should you place the measures?
A. Columns
B. Rows
C. Values
D. Drill through
Answer: C
QUESTION 380
Hotspot Question
You have Power BI report that contains the fields 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:
QUESTION 381
You have a Power BI model that contains a table named Employees. The table contains the following columns:
– Employee ID
– First Name
– Last Name
– Department
– Salary
Each employee is uniquely identified by using Employee ID.
You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.
Which DAX expression should you use?
A. DISTINCTCOUNT(‘Employees’[Salary])
B. CALCULATE(DISTINCTCOUNT(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
C. CALCULATE(AVERAGE(‘Employees’[Salary]), ‘Employees’[Department] = “Sales”)
D. AVERAGE(‘Employees’[Salary])
Answer: C
QUESTION 382
You use Power Query Editor to preview a query that contains sales order data in the following columns:
– Tax Amount
– Sales Order ID
– Freight Amount
– Subtotal Amount
– Total Item Quantity
The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount.
You need to query the data to identify the following metrics by month:
– The average item quantity per order
– The average freight amount per order
– The maximum item quantity per order
How should you modify the query?
A. In the Total Item Quantity column, replace the null values with 0.
B. In the Tax Amount column, remove rows that contain null values.
C. In the Freight Amount column, remove rows that contain null values.
D. In the Freight Amount column, replace the null values with 0.
Answer: D
QUESTION 383
You have a Power BI dataset that contains quarterly sales performance data.
You need to enable managers to review the data in a format that meets the following requirements:
– Is optimized for printing.
– Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?
A. a template app
B. a dashboard
C. a paginated report
D. an interactive report
Answer: C
QUESTION 384
You have a Power BI report that contains the visuals shown in the following table.
You need to modify the location of each visual.
What should you modify for each visual?
A. the layer order
B. the padding
C. the position
D. the tab order
Answer: C
QUESTION 385
You have a Power BI report. The report contains a line chart that displays sales data for several regions.
You need to add an element to the report that will enable users to filter the sales data to include only a selected region.
Which two elements achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. a slicer visual
B. a drillthrough filter
C. a table visual
D. a card visual
E. a Key Performance Indicator (KPI) visual
Answer: AB
QUESTION 386
Drag and Drop Question
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
– Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
– Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.
Answer:
QUESTION 387
You have the CSV file shown in the following table.
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
– The first column must contain the month.
– The second column must contain the year.
– The third column must contain the order amount for the month and year.
Which transformation should you use first?
A. remove
B. unpivot
C. transpose
D. pivot
Answer: B
QUESTION 389
You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps.
From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:
– Use Analytics views.
– Filter data from the cloud.
Which connector should you use?
A. OData queries Most Voted
B. Azure DevOps (Boards only) Most Voted
C. Azure DevOps Server (Boards only)
D. OData Feed
Answer: B
Explanation:
Select Get Data > Online Services, Azure DevOps (Boards only) for cloud services or select Azure DevOps Server (Boards only) for on-premises. Then select Connect. Analytics views only support queries against work items and test cases.
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
QUESTION 390
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 have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 391
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 have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You change the semantic model mode.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 392
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 have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You normalize casing in the source query or Power Query Editor.
Does this meet the goal?
A. Yes
B. No
Answer: A
QUESTION 393
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 have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You add an index key and normalize casing in the data source.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 394
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI semantic model.
You need to ensure that the semantic model can be refreshed in PowerBi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Web
B. Excel Workbook
C. Folder
D. Text/CSV
E. SharePoint folder
Answer: AE
QUESTION 395
You use Power Query Editor to preview a column named Date as shown in the following exhibit.
You need to change the Date column to contain only the year. The solution must minimize administrative effort.
What should you do?
A. Split the column by delimiter.
B. Split the column by number of characters.
C. Extract the text after the delimiter.
D. Transform the column to contain only the year.
Answer: D
QUESTION 396
Hotspot Question
You have a Power BI semantic model that contains the data sources shown in the following table.
You need to configure the privacy level s of the data sources.
What should you configure for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Answer:
Explanation:
Employee review data seems to be private since it contains sensitive information. And sales opportunities is organizational since it contains less informative information but still internal.
QUESTION 397
Hotspot Question
You use Power Query Editor to preview the data shown in the following exhibit.
You confirm that the data will always start on row 3, and row 3 will always contain the column names.
How should you shape the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
QUESTION 398
Hotspot Question
You are designing the data model for a Power BI semantic model.
You have the following tables in the star schema.
Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
QUESTION 399
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 have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
– Due Date
– Order Date
– Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationship between the sales table and the date table.
Does this meet the goal?
A. Yes
B. No
Answer: A
QUESTION 400
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 have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
– Due Date
– Order Date
– Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
A. Yes
B. No
Answer: A
QUESTION 401
You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters.
You need to calculate the average item price for a given country. The solution must support the existing filters.
Which type of quick measure should you use?
A. Total for category (filters applied)
B. Average per category
C. Rolling average
D. Weighted average per category
Answer: B
Explanation:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
QUESTION 402
You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4.
Query1 loads customer data into the model and is referenced by the other three queries.
You discover that data refresh for the model is slow.
You need to improve the data refresh time. The solution must minimize costs.
What should you do?
A. Run the Table.buffer function in Query1.
B. Duplicate Query1 to all the other queries.
C. Reconfigure Query1 as a dataflow entity.
D. From the Power BI Admin portal, increase the Capacity settings.
Answer: C
Explanation:
https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries
In the example, if Query1 is redesigned as a dataflow entity, Query2, Query3, and Query4 can use it as a data source. With this design, the entity sourced by Query1 will be evaluated only once.
QUESTION 403
You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently.
You need to create a Power BI report that meets the following requirements:
– Supports real-time analytics
– Minimizes performance impact on the data source
– Displays the most recent data without performing a data refresh
Which connectivity mode should you use for the dataset?
A. DirectQuery mode
B. import mode
C. LiveConnect mode
D. push mode
Answer: A
QUESTION 404
You create a Power BI report named Summary1.
You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1.
Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution.
NOTE: Each correct answer is worth one point.
A. Top Operations
B. DAX query
C. Server requests
D. Dependencies
E. Visual display
Answer: BE
QUESTION 405
You have a Microsoft 365 subscription that contains the resources shown in the following table.
You create a new dashboard that uses row-level security (RLS) filters. You define a new role named Consultants.
To which resource can you assign the Consultants role?
A. Group2
B. Team1
C. Sales reports
D. Group1
Answer: C
QUESTION 406
You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
– Date
– Product
– SalesAmount
You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
A. CALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
B. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max(‘Date'[Date])-30, Max(‘Date'[Date])))
C. CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
D. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
Answer: B
QUESTION 407
You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources:
– Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business
– Source2: An Azure SQL database on a virtual network
– Source3: A public website
Which data sources require an on-premises data gateway?
A. Source1 only
B. Source2 only
C. Source3 only
D. Source1 and Source2 only
E. Source2 and Source3 only
F. Source1, Source2, and Source3
Answer: B
Explanation:
You need a gateway to connect to data sources that are located in a private network, such as an Azure Virtual Network (Azure VNet). A virtual network, or VNet, is a logically isolated segment of a network that insulates traffic from the public internet. A VNet provides enhanced network security.
https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-data-gateways
QUESTION 408
You have a Power BI semantic model that contains two queries.
You discover that a report based on the model has performance issues.
You plan to use Power Query to reduce the data loaded to the model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
A. Apply group by and summarize techniques.
B. Combine the queries by using Append.
C. Remove unnecessary columns and rows.
D. Combine the queries by using Merge.
E. Create a new query group.
Answer: AC
QUESTION 409
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 have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You create aggregations to summarize results.
Does this meet the goal?
A. Yes
B. No
Answer: A
QUESTION 410
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 have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.
Solution: You increase Automatic page refresh intervals.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 411
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 have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in import storage mode.
Solution: You configure incremental refresh.
Does this meet the goal?
A. Yes
B. No
Answer: A
Explanation:
Incremental refresh allows you to load only new or changed data, rather than refreshing the entire dataset. This can significantly reduce the amount of data that needs to be processed and transferred, especially in large datasets.
Resources From:
1.2025 Latest Braindump2go PL-300 Exam Dumps (PDF & VCE) Free Share:
https://www.braindump2go.com/pl-300.html
2.2025 Latest Braindump2go PL-300 PDF and PL-300 VCE Dumps Free Share:
https://drive.google.com/drive/folders/1XLIyQFg9-MCU_1qJzrLgoEywgoGYveCv?usp=sharing
3.2025 Free Braindump2go PL-300 Exam Questions Download:
https://www.braindump2go.com/free-online-pdf/PL-300-VCE-Dumps(371-411).pdf
Free Resources from Braindump2go,We Devoted to Helping You 100% Pass All Exams!