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

 

Question 161

Which Power BI feature allows you to define a custom order for categorical values instead of using alphabetical sorting?

1. Sort by Column
2. Drillthrough
3. Field Parameters
4. Bookmarks

Correct Answer: 1

Explanation

Sort by Column allows a categorical column to be displayed according to another column that defines its intended order. This is useful for values such as months, weekdays, or custom business stages that should not appear alphabetically. For example, January should appear before February rather than being sorted alphabetically by month name. The supporting sort column normally contains numeric ordering values. Drillthrough provides detailed navigation, field parameters control dynamic fields, and bookmarks save report states. Therefore, Sort by Column is the correct feature.

Question 162

Which DAX function evaluates an expression for each row of a table and returns the sum of the resulting values?

1. SUM
2. SUMX
3. COUNT
4. AVERAGE

Correct Answer: 2

Explanation

SUMX is an iterator function that evaluates an expression for every row in a table and then adds the resulting values together. It is useful when the value to be aggregated must first be calculated at row level. For example, SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]) can calculate total sales when revenue is not stored directly in the table. SUM adds values from a column, COUNT counts values, and AVERAGE calculates a mean. Therefore, SUMX is appropriate for row-by-row calculations followed by summation.

Question 163

Which Power Query operation should you use to combine two tables based on matching values in a key column?

1. Append Queries
2. Group By
3. Merge Queries
4. Unpivot Columns

Correct Answer: 3

Explanation

Merge Queries combines tables by matching values in one or more selected columns. It is commonly used when information from a related table needs to be added to another query. For example, a Sales table can be merged with a Product table using ProductID to bring product descriptions or categories into the sales dataset. Append Queries combines rows from similar tables, Group By creates aggregations, and Unpivot restructures columns into rows. Therefore, Merge Queries is the correct operation when tables need to be joined using matching keys.

Question 164

Which visual is most appropriate for showing the composition of a total across a small number of categories?

1. Card
2. Line chart
3. Donut chart
4. Scatter chart

Correct Answer: 3

Explanation

A Donut chart can show how individual categories contribute to a total by displaying each category as a portion of a circular ring. It is most effective when the number of categories is relatively small and the differences between portions are easy to interpret. A Card displays a single value, a Line chart emphasizes trends across an ordered axis, and a Scatter chart shows relationships between numerical measures. Therefore, a Donut chart is an appropriate choice when the objective is to visualize the composition of a total across several categories.

Question 165

Which DAX function can return the last date in the current filter context?

1. FIRSTDATE
2. LASTDATE
3. TODAY
4. DATE

Correct Answer: 2

Explanation

LASTDATE returns the last date in the current filter context for a specified date column or date table. It is useful in time-intelligence calculations when a measure needs to identify the ending date of the selected period. For example, a report filtered to a particular month can use LASTDATE to identify the final date available within that selection. FIRSTDATE returns the earliest date, TODAY returns the current date, and DATE constructs a date from components. Therefore, LASTDATE is the appropriate function for retrieving the final date in the current context.

Question 166

Which Power BI feature allows users to switch dynamically between different fields or measures in a visual?

1. Bookmarks
2. Field parameters
3. Tooltips
4. Drillthrough

Correct Answer: 2

Explanation

Field parameters allow report users to dynamically change the fields or measures displayed in a visual. For example, a report can provide a selector that lets users switch a chart between Sales, Profit, and Quantity without creating separate visuals for each measure. This makes reports more interactive and reduces duplicated report elements. Bookmarks store specific report states, tooltips display additional information, and drillthrough navigates to detail pages. Therefore, Field parameters are the appropriate feature for dynamically switching fields or measures.

Question 167

Which DAX function can return a value based on a condition and provide different results when the condition is true or false?

1. IF
2. MAX
3. DISTINCT
4. SUM

Correct Answer: 1

Explanation

IF evaluates a logical condition and returns one value when the condition is TRUE and another value when it is FALSE. It can be used in calculated columns or measures for conditional logic. For example, IF(Sales[Amount] >= 1000, “High”, “Low”) can categorize transactions according to their value. MAX returns the largest value, DISTINCT returns unique values, and SUM calculates a total. Therefore, IF is the appropriate DAX function when different results are required based on whether a condition is satisfied.

Question 168

Which Power Query transformation is useful for separating a full name into first name and last name using a space as the separator?

1. Merge Columns
2. Group By
3. Split Column
4. Fill Down

Correct Answer: 3

Explanation

Split Column can divide one column into multiple columns based on a delimiter such as a space, comma, hyphen, or another character. For example, a FullName column containing “John Smith” can be split into separate FirstName and LastName columns using a space delimiter. Merge Columns performs the opposite operation by combining multiple columns. Group By creates summaries, while Fill Down copies preceding values into blank cells. Therefore, Split Column is the appropriate Power Query transformation for separating a full name into multiple fields.

Question 169

Which DAX function can return the current year from a date column?

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

Correct Answer: 3

Explanation

YEAR extracts the year component from a date value. For example, YEAR(Sales[OrderDate]) can return 2026 when the OrderDate contains a date from that year. This function is useful for creating year-based calculated columns, grouping records, or supporting date analysis. MONTH extracts the month number, DAY extracts the day number, and DATE creates a date using specified components. Therefore, YEAR is the correct DAX function when the requirement is to retrieve the year portion from a date.

Question 170

Which Power BI feature can restrict the rows of data that different users are allowed to see?

1. Bookmarks
2. Row-level security
3. Conditional formatting
4. Tooltips

Correct Answer: 2

Explanation

Row-level security, or RLS, restricts the data rows that users can access based on defined roles and filtering rules. For example, regional managers can be configured to see only sales records associated with their assigned region. This provides controlled access to report data while allowing multiple users to work with the same semantic model. Bookmarks save report states, conditional formatting changes visual appearance, and tooltips provide additional information. Therefore, Row-level security is the appropriate feature for restricting data visibility by user or role.

Question 171

Which DAX function can count the number of nonblank values in a column, including text values?

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

Correct Answer: 2

Explanation

COUNTA counts nonblank values in a column and can count both numeric and text values. It is useful when the requirement is to determine how many records contain a value regardless of the value’s data type. COUNT is primarily used for numeric values, DISTINCTCOUNT counts unique values, and COUNTROWS counts rows in a table expression. Therefore, COUNTA is the appropriate function when all nonblank values, including text and numbers, need to be counted in a column.

Question 172

Which Power BI visual is designed to show hierarchical data using nested rectangles whose sizes represent values?

1. Treemap
2. Gauge
3. Card
4. Line chart

Correct Answer: 1

Explanation

A Treemap displays hierarchical or categorical data using nested rectangles, with the size of each rectangle representing a measure. Larger rectangles represent larger values, while groups and subgroups can be shown through the visual structure. This makes treemaps useful for examining how categories contribute to a total while also showing hierarchy. A Gauge focuses on a value and target, a Card displays a single value, and a Line chart shows trends. Therefore, Treemap is the appropriate visual for hierarchical data represented through proportional areas.

Question 173

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

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

Correct Answer: 2

Explanation

PREVIOUSMONTH returns a table containing dates from the previous month based on the current filter context. It is commonly used in time-intelligence calculations that compare current-period results with the immediately preceding month. For example, a measure can use PREVIOUSMONTH to calculate prior-month sales and compare them with current sales. NEXTMONTH works in the opposite direction, while MONTH extracts a month number and DATE constructs a date. Therefore, PREVIOUSMONTH is the appropriate DAX function for retrieving the previous month’s date context.

Question 174

Which Power Query transformation allows you to replace specific values in a column with another value?

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

Correct Answer: 3

Explanation

Replace Values allows specific values in a Power Query column to be changed to another value. This is useful for correcting inconsistent labels, replacing outdated text, standardizing categories, or changing placeholder values. For example, values such as “N/A” can be replaced with a more appropriate representation. Remove Errors eliminates error-containing rows, Fill Up copies values upward into blank cells, and Choose Columns controls which columns remain in the query. Therefore, Replace Values is the correct transformation for changing selected values.

Question 175

Which DAX function can return the sum of a numeric column while respecting the current filter context?

1. SUM
2. SUMX
3. COUNT
4. MAX

Correct Answer: 1

Explanation

SUM adds all numeric values in a specified column and respects the current filter context. This means a measure such as SUM(Sales[SalesAmount]) can automatically change when users filter the report by date, product, region, or another dimension. SUMX is used when an expression must be evaluated row by row before being added together. COUNT counts numeric values, while MAX returns the largest value. Therefore, SUM is the appropriate DAX function when a straightforward total of an existing numeric column is required.

Question 176

Which Power BI feature allows a report author to save a specific arrangement and filter state of a report page?

1. Bookmarks
2. Relationships
3. Slicers
4. Data categories

Correct Answer: 1

Explanation

Bookmarks capture the current state of a Power BI report page, including selected filters, slicers, visibility states, and sometimes the displayed visual configuration. They can be used to create navigation experiences, reset filters, or switch between different report layouts. Relationships connect tables, slicers provide interactive filtering, and data categories provide semantic information about fields. Therefore, Bookmarks are the appropriate feature when a report author needs to save and later restore a particular report state.

Question 177

Which DAX function can return the largest value after evaluating an expression for every row in a table?

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

Correct Answer: 2

Explanation

MAXX evaluates an expression for each row of a table and returns the largest result. This makes it useful when the maximum value is based on a calculation rather than a directly stored column. For example, MAXX(Sales, Sales[Quantity] * Sales[UnitPrice]) can identify the highest calculated transaction amount. MAX works directly with a column or expression without performing row-by-row table iteration. MIN returns the smallest value and AVERAGE calculates the arithmetic mean. Therefore, MAXX is appropriate for calculated row-level maximum values.

Question 178

Which Power Query feature combines the contents of multiple columns into a single column?

1. Split Column
2. Merge Columns
3. Pivot Column
4. Filter Rows

Correct Answer: 2

Explanation

Merge Columns combines values from two or more selected columns into one column. Power Query can insert a delimiter between the combined values, such as a space, comma, or hyphen. This is useful for creating full names, complete addresses, or other combined text fields. Split Column separates one column into multiple columns, Pivot Column restructures values into separate columns, and Filter Rows limits records based on conditions. Therefore, Merge Columns is the appropriate feature when multiple columns need to be combined into one.

Question 179

Which DAX function can calculate a result using a modified filter context?

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

Correct Answer: 1

Explanation

CALCULATE evaluates an expression after modifying the filter context. It is one of the most important DAX functions for creating measures that respond to specific filtering requirements. For example, CALCULATE([Total Sales], Product[Category] = “Bikes”) can calculate sales specifically for the Bikes category. DISTINCT returns unique values, FORMAT converts values to formatted text, and CONCATENATE combines text values. Therefore, CALCULATE is the appropriate function when a measure must be evaluated under a changed or additional filter context.

Question 180

Which Power BI visual is most appropriate for comparing actual performance against a target value using a single compact indicator?

1. Gauge
2. Scatter chart
3. Treemap
4. Donut chart

Correct Answer: 1

Explanation

A Gauge visual is designed to compare a current value with a target or goal. It provides a compact indicator of progress and can communicate whether performance is approaching, meeting, or moving away from a defined target. For example, monthly revenue can be displayed against a sales goal using a Gauge. A Scatter chart analyzes relationships between numerical values, a Treemap compares categories through area, and a Donut chart shows composition. Therefore, Gauge is the appropriate visual for displaying actual performance against a target.