View Full Microsoft PL-300 Exam Dumps and Practice Test Dumps.

 

Question 241

Which Power BI view is used to create report pages and add visuals such as charts, tables, and slicers?

1. Report view
2. Model view
3. Data view
4. Query view

Correct Answer: 1

Explanation

Report view is the primary workspace for creating and designing Power BI reports. In this view, report authors can add charts, tables, cards, slicers, text boxes, shapes, and other visual elements to report pages. It also provides tools for formatting visuals and configuring interactions between them. Model view is used for relationships and model structure, while Data view allows users to inspect table data. Therefore, Report view is the appropriate workspace when creating report pages and adding data visualizations.

Question 242

Which DAX function can return the median value of a numeric column?

1. AVERAGE
2. MEDIAN
3. MAX
4. SUM

Correct Answer: 2

Explanation

MEDIAN returns the middle value of a numeric column when the values are arranged in ascending or descending order. It is useful when a typical value needs to be identified while reducing the influence of unusually high or low values. For example, median sales can provide a more representative view when a small number of transactions are exceptionally large. AVERAGE calculates the arithmetic mean, MAX returns the largest value, and SUM calculates a total. Therefore, MEDIAN is the appropriate DAX function for calculating the middle value.

Question 243

Which Power Query transformation allows you to remove a specified number of rows from the beginning of a table?

1. Remove Bottom Rows
2. Remove Blank Rows
3. Remove Top Rows
4. Remove Duplicates

Correct Answer: 3

Explanation

Remove Top Rows removes a specified number of records from the beginning of a Power Query table. This is useful when source files contain unnecessary header information, introductory rows, or other records before the actual dataset begins. For example, if the first five rows contain report metadata, those rows can be removed before promoting the actual column headers. Remove Bottom Rows works from the end, Remove Blank Rows targets empty records, and Remove Duplicates eliminates repeated values. Therefore, Remove Top Rows is the correct transformation.

Question 244

Which Power BI visual is useful for displaying hierarchical categories with proportional rectangular areas?

1. Matrix
2. Funnel chart
3. Treemap
4. Card

Correct Answer: 3

Explanation

A Treemap represents categories using rectangular areas whose sizes correspond to numerical values. It can also display hierarchical relationships by organizing categories and subcategories into nested areas. This makes it useful for comparing the relative contribution of products, regions, departments, or other categories. A Matrix presents structured data in rows and columns, a Funnel chart displays sequential stages, and a Card highlights a single value. Therefore, Treemap is the appropriate visual when hierarchical categories need to be compared using proportional areas.

Question 245

Which DAX function returns the largest value from a numeric column?

1. MAX
2. MIN
3. SUM
4. AVERAGE

Correct Answer: 1

Explanation

MAX returns the largest value in a specified column or expression while respecting the current filter context. For example, MAX(Sales[Revenue]) can identify the highest revenue value within the records currently included in a report calculation. This makes MAX useful for identifying peak sales, highest prices, or other maximum values. MIN returns the smallest value, SUM calculates a total, and AVERAGE calculates the arithmetic mean. Therefore, MAX is the appropriate DAX function when the highest value in a numeric column is required.

Question 246

Which Power Query operation combines rows from two or more queries with compatible column structures?

1. Merge Queries
2. Append Queries
3. Group By
4. Pivot Column

Correct Answer: 2

Explanation

Append Queries combines rows from two or more queries into a single query. It is especially useful when multiple datasets have similar structures, such as separate files containing monthly or regional sales records. The rows from the selected queries are added together to create one consolidated dataset. Merge Queries instead joins tables using matching values, Group By creates summaries, and Pivot Column restructures values into columns. Therefore, Append Queries is the appropriate Power Query operation when records from multiple similar tables need to be combined.

Question 247

Which DAX function can return the current month number from a date value?

1. MONTH
2. YEAR
3. DAY
4. WEEKDAY

Correct Answer: 1

Explanation

MONTH extracts the month number from a date value. For example, MONTH(DATE(2026, 9, 15)) returns 9. This function can be used in calculated columns, measures, and other date-related calculations where the month component is needed. YEAR returns the year, DAY returns the day of the month, and WEEKDAY returns a number representing the day of the week. Therefore, MONTH is the appropriate DAX function when the requirement is to obtain the numeric month associated with a particular date.

Question 248

Which Power BI feature allows users to select a subset of data directly on a report page?

1. Card
2. Slicer
3. Matrix
4. Gauge

Correct Answer: 2

Explanation

A Slicer provides an interactive control that allows users to select values and filter connected report visuals. For example, a Year slicer can allow users to select 2025 or 2026 and update the charts on the page accordingly. Slicers can contain lists, dropdowns, ranges, or other selection methods depending on the field type. A Card displays a value, a Matrix presents structured information, and a Gauge compares performance with a target. Therefore, Slicer is the appropriate feature for interactive filtering directly on a report page.

Question 249

Which DAX function can evaluate an expression using a specified filter context?

1. CALCULATE
2. DISTINCT
3. CONCATENATE
4. FORMAT

Correct Answer: 1

Explanation

CALCULATE evaluates an expression after modifying or applying filter context. It is fundamental to DAX because it allows measures to produce results based on specific conditions. For example, CALCULATE([Total Sales], Product[Category] = “Furniture”) can calculate sales specifically for the Furniture category. DISTINCT returns unique values, CONCATENATE combines text, and FORMAT converts values into formatted text. Therefore, CALCULATE is the appropriate DAX function when a calculation needs to be evaluated under a specified or modified filter context.

Question 250

Which Power Query feature can be used to inspect column statistics and identify potential data-quality issues?

1. Column profiling
2. Merge Queries
3. Append Queries
4. Split Column

Correct Answer: 1

Explanation

Column profiling provides information about the contents and quality of columns during Power Query data preparation. It can help users identify errors, empty values, distributions, and other characteristics of the source data. This makes it useful for discovering data-quality problems before information is loaded into the Power BI model. Merge Queries joins tables, Append Queries combines rows, and Split Column separates a column into multiple fields. Therefore, column profiling is the appropriate capability for examining column statistics and identifying potential data issues.

Question 251

Which DAX function can return the smallest value in a specified numeric column?

1. MIN
2. MAX
3. AVERAGE
4. SUM

Correct Answer: 1

Explanation

MIN returns the smallest value from a specified column or expression. It respects the current filter context, so the result can change when users filter the report by dimensions such as date, product, or region. For example, MIN(Sales[Amount]) can identify the lowest transaction amount within the currently selected data. MAX returns the largest value, AVERAGE calculates the arithmetic mean, and SUM adds values together. Therefore, MIN is the appropriate DAX function when the lowest value in a numeric column is required.

Question 252

Which Power BI capability allows a user to move from a summarized category to more detailed categories within the same visual hierarchy?

1. Drillthrough
2. Drill-down
3. Page navigation
4. Tooltip

Correct Answer: 2

Explanation

Drill-down allows users to move from a higher level of a hierarchy to a more detailed level within the same visual. For example, a sales chart organized by Year can be drilled down to Quarter, Month, and Day. This allows users to explore increasingly detailed information without opening another report page. Drillthrough navigates to a separate detail page, Page navigation moves between report pages, and Tooltips display additional information when hovering. Therefore, Drill-down is the appropriate feature for exploring hierarchy levels within a visual.

Question 253

Which DAX function can return the number of unique customers in a sales table?

1. COUNT
2. COUNTA
3. DISTINCTCOUNT
4. COUNTROWS

Correct Answer: 3

Explanation

DISTINCTCOUNT counts unique values in a specified column. If a sales table contains multiple transactions for the same customer, DISTINCTCOUNT(Sales[CustomerID]) counts each customer only once. This makes it useful for calculating metrics such as unique customers, unique products, or unique transaction identifiers. COUNT counts numeric values, COUNTA counts nonblank values, and COUNTROWS counts table records. Therefore, DISTINCTCOUNT is the correct DAX function when the objective is to determine the number of unique customers represented in a dataset.

Question 254

Which Power Query transformation can change the order of rows according to a selected column?

1. Sort
2. Filter Rows
3. Group By
4. Replace Values

Correct Answer: 1

Explanation

Sort changes the order of records according to the values in one or more selected columns. Users can sort values in ascending or descending order and can apply multiple sorting levels when necessary. For example, sales records can be sorted by Revenue from highest to lowest. Filter Rows removes records that do not meet specified conditions, Group By creates aggregated summaries, and Replace Values modifies matching values. Therefore, Sort is the appropriate Power Query transformation when records need to be arranged according to column values.

Question 255

Which DAX function can return the previous month based on the current date context?

1. PREVIOUSMONTH
2. NEXTMONTH
3. MONTH
4. DATE

Correct Answer: 1

Explanation

PREVIOUSMONTH returns a table containing dates from the month immediately preceding the current filter context. It is useful for month-over-month comparisons and calculations involving previous-period performance. For example, a measure can use PREVIOUSMONTH to calculate sales for the preceding month and compare them with current sales. NEXTMONTH returns the following month, MONTH extracts a month number, and DATE creates a date. Therefore, PREVIOUSMONTH is the appropriate DAX function when a calculation needs to reference the previous month’s date context.

Question 256

Which Power BI feature allows report authors to create a consistent set of colors, fonts, and formatting across a report?

1. Bookmarks
2. Themes
3. Tooltips
4. Relationships

Correct Answer: 2

Explanation

Themes provide a consistent visual design for a Power BI report by defining settings such as colors, fonts, and other formatting properties. Applying a theme can reduce repetitive formatting work and help maintain a consistent appearance across multiple report pages. Bookmarks save report states, Tooltips provide additional information, and Relationships connect tables in the semantic model. Therefore, Themes are the appropriate Power BI feature when a report author needs to establish consistent visual formatting throughout a report.

Question 257

Which DAX function can return the current day of the month from a date value?

1. DAY
2. MONTH
3. YEAR
4. WEEKDAY

Correct Answer: 1

Explanation

DAY extracts the day-of-month component from a date value. For example, DAY(DATE(2026, 9, 17)) returns 17. This function is useful when calculations or classifications require the numeric day within a month. MONTH returns the month number, YEAR returns the year, and WEEKDAY returns a number representing the day of the week. Therefore, DAY is the appropriate DAX function when the requirement is to retrieve the day component from a date.

Question 258

Which Power Query operation can replace an existing value with another value throughout a selected column?

1. Replace Values
2. Remove Errors
3. Fill Down
4. Choose Columns

Correct Answer: 1

Explanation

Replace Values allows Power Query users to find a specified value and substitute it with another value in a selected column. It is useful for correcting inconsistent labels, standardizing text, replacing placeholders, or fixing known source-data issues. For example, several records containing “N/A” can be replaced with an appropriate standardized value. Remove Errors handles error records, Fill Down copies preceding values into blank cells, and Choose Columns controls which columns remain. Therefore, Replace Values is the correct transformation for changing existing values.

Question 259

Which DAX function can calculate the average of values in a numeric column?

1. AVERAGE
2. AVERAGEX
3. MEDIAN
4. SUMX

Correct Answer: 1

Explanation

AVERAGE calculates the arithmetic mean of the numeric values in a specified column. It respects the current filter context, meaning the result can change according to selections made in the report. For example, AVERAGE(Sales[OrderValue]) can calculate the average order value for the currently filtered dataset. AVERAGEX evaluates an expression row by row before calculating the average, MEDIAN returns the middle value, and SUMX calculates a row-level total. Therefore, AVERAGE is appropriate when averaging values already stored in a numeric column.

Question 260

Which Power BI tool can help identify slow-performing visuals by recording the time taken to process them?

1. Performance Analyzer
2. Model view
3. Data category
4. Selection pane

Correct Answer: 1

Explanation

Performance Analyzer helps developers investigate report performance by recording the time taken by individual visuals and their associated queries. This allows report authors to identify visuals that require excessive processing and may contribute to a slow user experience. The information can be used to optimize measures, visuals, and report design. Model view focuses on relationships and model structure, Data categories define semantic field types, and the Selection pane manages visual visibility and ordering. Therefore, Performance Analyzer is the appropriate tool for investigating slow-performing visuals.