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

 

Question 121

Which Power BI feature allows you to combine data from multiple tables into a single visual model by defining connections between related fields?

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

Correct Answer: 1

Explanation

Relationships connect tables through matching columns and allow filters and calculations to work across the semantic model. For example, a Sales table can be connected to a Product table through ProductID, allowing product attributes to filter sales records. Relationships are an essential part of a well-designed Power BI model and are commonly used in star-schema structures. Bookmarks save report states, themes control formatting, and tooltips display additional information. Therefore, relationships are the appropriate feature for connecting related tables within a Power BI model.

Question 122

Which DAX function can return the highest value produced by an expression evaluated across rows of a table?

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

Correct Answer: 2

Explanation

MAXX is an iterator function that evaluates an expression for every row in a table and then returns the highest resulting value. This is useful when the value being evaluated must first be calculated for each row. For example, MAXX(Sales, Sales[Quantity] * Sales[UnitPrice]) can identify the highest transaction value. MAX operates directly on a column or expression, while MIN returns the smallest value and SUMX adds row-level results. Therefore, MAXX is appropriate when the maximum must be determined from a calculated expression.

Question 123

Which Power Query transformation should you use when you want to keep only the first 100 rows of a query?

1. Remove Bottom Rows
2. Keep Top Rows
3. Keep Range of Rows
4. Remove Duplicates

Correct Answer: 2

Explanation

Keep Top Rows allows Power Query users to retain a specified number of rows from the beginning of a dataset. For example, entering 100 keeps the first 100 rows and removes the remaining records from the query result. This can be useful for testing, sampling, or preparing limited datasets. Remove Bottom Rows removes records from the end, Keep Range of Rows selects a specified range, and Remove Duplicates eliminates repeated records. Therefore, Keep Top Rows is the appropriate transformation for retaining the first 100 rows.

Question 124

Which Power BI visual is designed to display the relationship between two numerical measures using individual data points?

1. Scatter chart
2. Card
3. Gauge
4. Funnel chart

Correct Answer: 1

Explanation

A Scatter chart displays individual data points based on two numerical measures, making it useful for identifying relationships, trends, clusters, and outliers. For example, advertising expenditure can be plotted against sales revenue to examine whether the two measures appear related. A Card displays a single value, a Gauge compares a value with a target, and a Funnel represents stages in a process. Therefore, a Scatter chart is the most appropriate visual when the goal is to analyze the relationship between two numerical variables.

Question 125

Which DAX function can return the number of days between two dates?

1. DATEDIFF
2. DATE
3. DAY
4. TODAY

Correct Answer: 1

Explanation

DATEDIFF calculates the difference between two dates according to a specified interval such as DAY, MONTH, or YEAR. For example, DATEDIFF(StartDate, EndDate, DAY) can calculate the number of days between a start and end date. DATE creates a date from individual components, DAY extracts the day number from a date, and TODAY returns the current date. Therefore, DATEDIFF is the appropriate DAX function when the requirement is to calculate the elapsed time between two dates.

Question 126

Which Power Query feature can be used to identify the number of distinct values or distribution of values in a column during data preparation?

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

Correct Answer: 1

Explanation

Column profiling features in Power Query help users inspect data quality and understand column contents. Depending on the profiling options enabled, users can examine value distributions, column statistics, errors, and other information. This can help identify unexpected values, missing data, or unusual distributions before loading the dataset. Merge Queries joins tables, Append Queries combines rows, and Split Column separates values. Therefore, column profiling is the appropriate capability for examining the contents and quality of a column during data preparation.

Question 127

Which DAX function can return the minimum value generated by an expression evaluated for every row of a table?

1. MIN
2. MINX
3. MAXX
4. SUMX

Correct Answer: 2

Explanation

MINX evaluates an expression for every row of a table and returns the smallest resulting value. This makes it useful when the minimum value must be calculated from a row-level expression rather than directly from an existing column. For example, MINX(Sales, Sales[Quantity] * Sales[UnitPrice]) can identify the smallest calculated transaction amount. MIN returns the minimum from a column or expression, MAXX finds the largest row-level result, and SUMX adds results. Therefore, MINX is the appropriate function for this scenario.

Question 128

Which Power BI feature can automatically detect relationships between tables when data is loaded into a model?

1. Auto-detect relationships
2. Bookmarks
3. Tooltips
4. Themes

Correct Answer: 1

Explanation

Power BI can automatically detect potential relationships between tables based on matching column names, data types, and available values. Auto-detect relationships can save development time when importing related datasets, although developers should review automatically created relationships to ensure they accurately represent the intended model. Bookmarks preserve report states, tooltips provide additional information, and themes control visual formatting. Therefore, Auto-detect relationships is the appropriate feature when Power BI should attempt to identify table relationships automatically.

Question 129

Which DAX function can return a value from a column in the current row context when a related table is available?

1. RELATED
2. DISTINCT
3. FILTER
4. FORMAT

Correct Answer: 1

Explanation

RELATED retrieves a value from a related table when a valid relationship exists between the current table and the related table. It is commonly used in calculated columns where information from a dimension table needs to be added to a fact table. For example, a Sales calculated column can use RELATED(Product[Category]) to retrieve the category associated with each product. DISTINCT returns unique values, FILTER creates a filtered table, and FORMAT converts values to text. Therefore, RELATED is the appropriate function for retrieving a corresponding value from a related table.

Question 130

Which Power Query operation is used to combine rows from multiple tables that have similar structures?

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

Correct Answer: 1

Explanation

Append Queries combines rows from two or more tables into one query. It is particularly useful when datasets have the same or compatible column structures, such as separate monthly sales files that need to be combined into a single table. Merge Queries joins tables based on matching key values and normally adds columns from another table. Group By creates aggregations, while Pivot Column restructures values into columns. Therefore, Append Queries is the appropriate Power Query operation when the goal is to combine records from similar tables.

Question 131

Which DAX function can return the previous day based on the current filter context?

1. PREVIOUSDAY
2. TODAY
3. DAY
4. DATE

Correct Answer: 1

Explanation

PREVIOUSDAY returns a table containing the dates from the previous day based on the current filter context. It is used in time-intelligence calculations when a measure needs to compare a current result with the immediately preceding day. It generally works best with a properly configured date table. TODAY returns the current date, DAY extracts the day number from a date, and DATE constructs a date. Therefore, PREVIOUSDAY is the appropriate function when a DAX calculation needs to reference the previous day’s dates.

Question 132

Which Power BI visual is appropriate for displaying a single value along with a target comparison in a compact format?

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

Correct Answer: 1

Explanation

A Gauge visual displays a single measure in relation to a target or goal. It is useful for KPIs where users need to understand progress toward a defined objective, such as monthly sales compared with a sales target. Scatter charts analyze relationships between numerical values, treemaps compare categories through proportional areas, and matrices display structured rows and columns. Therefore, a Gauge is appropriate when a report needs to present one value together with its target or performance range.

Question 133

Which Power Query transformation allows you to convert a column containing numbers stored as text into a numeric data type?

1. Change Type
2. Group By
3. Merge Queries
4. Unpivot Columns

Correct Answer: 1

Explanation

Change Type allows Power Query users to assign the correct data type to a column. If numbers are imported as text, changing the type to Whole Number or Decimal Number makes the values suitable for mathematical calculations and numeric sorting. Correct data types are important for model behavior and accurate analysis. Group By summarizes records, Merge Queries combines tables, and Unpivot Columns restructures the dataset. Therefore, Change Type is the appropriate transformation when text-based numeric values need to be converted into a numeric data type.

Question 134

Which DAX function can calculate the average of an expression evaluated row by row?

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

Correct Answer: 2

Explanation

AVERAGEX is an iterator function that evaluates an expression for each row of a table and then calculates the average of the resulting values. It is useful when the average must be based on a calculation rather than an existing column. For example, AVERAGEX(Sales, Sales[Quantity] * Sales[UnitPrice]) can calculate the average transaction value. AVERAGE works directly with a column, SUMX calculates a sum of row-level expressions, and COUNTX counts expression results. Therefore, AVERAGEX is appropriate for row-by-row average calculations.

Question 135

Which Power BI feature allows report authors to apply a filter to multiple report pages at the same time?

1. Page-level filter
2. Report-level filter
3. Visual-level filter
4. Drillthrough filter

Correct Answer: 2

Explanation

A report-level filter applies filtering criteria across the report, allowing the selected filter to affect multiple report pages. This is useful when a condition should consistently apply throughout the report. A page-level filter affects visuals on one page, while a visual-level filter affects only a specific visual. Drillthrough filters are used to pass selected values to detail pages. Therefore, a report-level filter is the appropriate choice when the same filtering condition needs to apply across multiple report pages.

Question 136

Which DAX function can return the first nonblank value when multiple expressions are evaluated in order?

1. COALESCE
2. SUM
3. MAX
4. DISTINCTCOUNT

Correct Answer: 1

Explanation

COALESCE evaluates expressions in sequence and returns the first expression that is not BLANK. It is useful when a report should display a fallback value when the primary measure has no result. For example, COALESCE([Current Sales], [Previous Sales], 0) can return the first available nonblank result. SUM performs addition, MAX identifies the largest value, and DISTINCTCOUNT counts unique values. Therefore, COALESCE is the appropriate DAX function when multiple possible results need to be checked until a nonblank value is found.

Question 137

Which Power BI feature allows you to create a reusable visual style for multiple reports or report pages?

1. Theme
2. Relationship
3. Slicer
4. Drillthrough

Correct Answer: 1

Explanation

A Power BI theme defines consistent visual formatting such as colors, fonts, and other design properties. Themes can be applied to reports to establish a standardized appearance and reduce the need to format individual visuals repeatedly. This is especially useful when reports need to follow organizational design standards. Relationships connect tables, slicers provide filtering controls, and drillthrough provides navigation to detail pages. Therefore, Theme is the appropriate feature for establishing a consistent visual style across report content.

Question 138

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

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

Correct Answer: 2

Explanation

MONTH extracts the month number from a date value. For example, MONTH(DATE(2026, 9, 15)) returns 9. This function can be used when creating calculated columns or supporting month-based analysis. YEAR returns the year component, DAY returns the day number, and DATE creates a date from individual components. Therefore, MONTH is the appropriate DAX function when the requirement is to obtain the numeric month associated with a date.

Question 139

Which Power Query transformation is useful for filling missing values by carrying the value from the row above into blank rows?

1. Fill Down
2. Fill Up
3. Group By
4. Pivot Column

Correct Answer: 1

Explanation

Fill Down copies the last nonblank value downward into subsequent blank cells. This is useful when source data uses a hierarchical or grouped layout where a category or identifier appears only on the first row of a group. Filling the value downward makes every related record explicitly associated with that category. Fill Up performs a similar operation in the opposite direction. Group By summarizes data, while Pivot Column changes the table structure. Therefore, Fill Down is the appropriate transformation when missing values should inherit the value from the preceding row.

Question 140

Which DAX function can return the number of rows in a table after applying a filter condition?

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

Correct Answer: 1

Explanation

COUNTROWS returns the number of rows in a table expression and can be combined with FILTER to count records that meet specific conditions. For example, COUNTROWS(FILTER(Sales, Sales[SalesAmount] > 10000)) can count sales records exceeding a specified amount. COUNT counts numeric values in a column, COUNTA counts nonblank values, and DISTINCTCOUNT counts unique values. Therefore, COUNTROWS is the appropriate function when the requirement is to count rows from a filtered table expression.