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

 

Question 221

Which Power BI feature allows a report author to create calculations that can be reused across multiple visuals?

1. Calculated column
2. Measure
3. Custom column
4. Calculated table

Correct Answer: 2

Explanation

A measure is a reusable DAX calculation that is evaluated according to the current filter context. Measures are commonly used for totals, percentages, averages, ratios, and other analytical calculations that need to respond dynamically when users interact with a report. Unlike calculated columns, measures do not store a calculated value for every row. A custom column is created during Power Query data preparation, while a calculated table creates a new table through DAX. Therefore, a measure is the appropriate choice for reusable dynamic calculations across multiple visuals.

Question 222

Which DAX function can shift a set of dates forward or backward by a specified number of intervals?

1. DATESBETWEEN
2. DATE
3. DATEADD
4. DATEDIFF

Correct Answer: 3

Explanation

DATEADD shifts a set of dates forward or backward by a specified number of intervals such as days, months, quarters, or years. It is commonly used in time-intelligence calculations when comparing the current period with another shifted period. For example, DATEADD(Date[Date], -1, YEAR) can be used to reference dates from the previous year. DATESBETWEEN returns a date range, DATE constructs an individual date, and DATEDIFF calculates the difference between dates. Therefore, DATEADD is the appropriate function for shifting date context.

Question 223

Which Power Query transformation can change all text values in a column to uppercase?

1. Format
2. Replace Values
3. Extract
4. Group By

Correct Answer: 1

Explanation

The Format transformation in Power Query provides text operations such as uppercase, lowercase, and proper case. Applying Uppercase converts text values into capital letters, which can help standardize inconsistent source data. For example, values such as “london”, “London”, and “LONDON” can be standardized into a consistent uppercase format. Replace Values changes specific matching values, Extract retrieves portions of text, and Group By creates summaries. Therefore, Format is the appropriate Power Query transformation when all text values need to be converted to uppercase.

Question 224

Which Power BI visual is best suited for comparing two numerical measures and identifying clusters or outliers?

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

Correct Answer: 2

Explanation

A Scatter chart plots individual records using numerical values on two axes. It is useful for identifying relationships, clusters, trends, and unusual observations. For example, a business can compare advertising spending against revenue to identify whether higher spending is associated with higher sales. A Card displays a single value, a Funnel chart represents sequential stages, and a Gauge compares a value with a target. Therefore, a Scatter chart is the appropriate visual when two numerical measures need to be compared and patterns or outliers need to be identified.

Question 225

Which DAX function can return the number of rows in a filtered table expression?

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

Correct Answer: 3

Explanation

COUNTROWS returns the number of rows contained in a table or table expression. When combined with FILTER, it can count records that satisfy a specific condition. For example, COUNTROWS(FILTER(Sales, Sales[Amount] > 1000)) can count sales transactions whose amount exceeds 1,000. COUNT counts numeric values in a column, COUNTA counts nonblank values, and DISTINCTCOUNT counts unique values. Therefore, COUNTROWS is the appropriate DAX function when the requirement is to count records from a filtered table expression.

Question 226

Which Power BI feature allows a report author to define a security role with a filter that limits which rows a user can access?

1. Bookmarks
2. Row-level security
3. Tooltips
4. Themes

Correct Answer: 2

Explanation

Row-level security allows Power BI developers to define roles that restrict the rows visible to users. A role can contain DAX filter expressions that determine which records a user can access. For example, a regional role can restrict a report user to sales records belonging to a particular region. Bookmarks save report states, tooltips display additional information, and themes control report formatting. Therefore, Row-level security is the appropriate feature when access to specific rows needs to be controlled according to security roles.

Question 227

Which DAX function returns the number of values in a column that are not blank, including text and numbers?

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

Correct Answer: 4

Explanation

COUNTA counts nonblank values in a column and can include both text and numeric values. It is useful when the goal is to determine how many records contain some value regardless of the value’s data type. COUNT is mainly used for numeric values, COUNTROWS counts rows in a table, and DISTINCTCOUNT counts unique values. For example, COUNTA(Customer[Email]) can count records where an email value exists. Therefore, COUNTA is the appropriate DAX function for counting all nonblank values in a column.

Question 228

Which Power Query transformation is used to convert rows into columns based on the values of a selected field?

1. Unpivot Columns
2. Pivot Column
3. Merge Columns
4. Split Column

Correct Answer: 2

Explanation

Pivot Column transforms row values into separate columns. It is useful when a dataset contains categories in rows but the reporting structure requires those categories to become column headers. For example, a table containing Product, Month, and Sales can be pivoted so that each month becomes a separate column. Unpivot Columns performs the opposite type of restructuring, while Merge Columns combines existing columns and Split Column divides one column. Therefore, Pivot Column is the correct Power Query transformation for converting selected row values into columns.

Question 229

Which DAX function can return the smallest value produced by evaluating an expression for each row?

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

Correct Answer: 1

Explanation

MINX evaluates an expression for each row of a table and returns the smallest resulting value. It is useful when the value being evaluated is calculated rather than stored directly in a column. For example, MINX(Sales, Sales[Quantity] * Sales[UnitPrice]) can identify the smallest calculated transaction value. MIN returns the minimum from an existing column, MAXX returns the largest row-level result, and AVERAGE calculates an arithmetic mean. Therefore, MINX is the appropriate function when the minimum must be determined from a calculated expression.

Question 230

Which Power BI feature allows a user to select between different measures displayed by the same visual?

1. Bookmark
2. Field parameter
3. Drillthrough
4. Tooltip

Correct Answer: 2

Explanation

Field parameters allow report users to dynamically switch the fields or measures used by a visual. For example, a chart can be configured so users select Sales, Profit, or Quantity from a parameter control while keeping the same visual structure. This reduces the need to create multiple duplicate visuals and provides a flexible reporting experience. Bookmarks save report states, Drillthrough navigates to detail pages, and Tooltips display additional information. Therefore, a Field parameter is the appropriate feature for dynamically switching measures within a visual.

Question 231

Which DAX function can calculate the total of an expression evaluated for each row of a table?

1. SUM
2. SUMX
3. TOTAL
4. ADD

Correct Answer: 2

Explanation

SUMX evaluates an expression for every row in a specified table and then adds the results together. This is especially useful when the required total is based on a calculation performed separately for each record. For example, SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]) calculates total revenue when quantity and unit price are stored separately. SUM directly adds values from a column, while TOTAL and ADD are not the standard DAX functions used for this purpose. Therefore, SUMX is the appropriate function for row-level expression totals.

Question 232

Which Power BI visual is most appropriate for displaying a single KPI value such as total revenue?

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

Correct Answer: 2

Explanation

A Card visual displays a single important value prominently and is commonly used for key performance indicators. Examples include total revenue, total profit, customer count, or order volume. Cards allow users to understand an important measure quickly without interpreting a more complex chart. A Matrix presents data in rows and columns, a Treemap compares categories through proportional areas, and a Scatter chart analyzes relationships between numerical measures. Therefore, Card is the most appropriate visual when a single KPI value needs to be presented clearly.

Question 233

Which DAX function can retrieve a value from a related table when a relationship exists between the tables?

1. RELATED
2. FILTER
3. VALUES
4. CALCULATE

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 particularly useful in calculated columns where an attribute from a dimension table needs to be brought into another table. For example, a Sales calculated column can use RELATED(Product[Category]) to retrieve the category associated with each product. FILTER creates a filtered table, VALUES returns distinct values, and CALCULATE modifies filter context. Therefore, RELATED is the appropriate function for retrieving a corresponding value through a relationship.

Question 234

Which Power Query feature allows you to keep only rows that meet a specified condition?

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

Correct Answer: 2

Explanation

Filter Rows allows Power Query users to retain records that meet specified conditions and exclude records that do not. For example, a Sales table can be filtered to keep only transactions where the sales amount is greater than 1,000 or where the region equals a specific value. Remove Rows can remove records based on position or other criteria, Replace Values changes cell contents, and Group By summarizes records. Therefore, Filter Rows is the appropriate transformation when the dataset needs to retain records according to defined conditions.

Question 235

Which DAX function returns the first date available in the current filter context?

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

Correct Answer: 1

Explanation

FIRSTDATE returns the first date in the current filter context for a specified date column or date table. It is useful in calculations where the beginning of the selected period needs to be identified. For example, a report filtered to a particular month can use FIRSTDATE to determine the first date included in that selection. LASTDATE returns the final date, TODAY returns the current date, and MINX evaluates an expression across rows. Therefore, FIRSTDATE is the appropriate function for identifying the earliest date in the current context.

Question 236

Which Power BI feature can display additional contextual information when a user places the pointer over a visual data point?

1. Bookmark
2. Tooltip
3. Slicer
4. Drill-down

Correct Answer: 2

Explanation

A Tooltip displays additional information when users hover over a data point in a visual. It can show supplementary fields or measures without requiring users to navigate away from the current report page. Power BI also supports dedicated tooltip pages that can provide a customized layout and additional visuals. Bookmarks save report states, Slicers provide filtering controls, and Drill-down moves between hierarchy levels. Therefore, Tooltip is the appropriate feature when contextual information should appear during hovering over a visual element.

Question 237

Which DAX function can remove filters from a specified table or column when used in a calculation?

1. FILTER
2. REMOVEFILTERS
3. VALUES
4. SELECTEDVALUE

Correct Answer: 2

Explanation

REMOVEFILTERS clears filters from specified tables or columns in a DAX calculation. It is often used with CALCULATE when a measure needs to ignore a particular filtering condition while retaining other relevant context. For example, a percentage-of-total measure may remove a product category filter to calculate the overall total. FILTER creates a filtered table expression, VALUES returns distinct values, and SELECTEDVALUE retrieves one selected value. Therefore, REMOVEFILTERS is the appropriate function when specific filters need to be explicitly cleared.

Question 238

Which Power Query transformation allows you to fill blank cells using the value from the row immediately above?

1. Fill Up
2. Fill Down
3. Replace Values
4. Remove Blank Rows

Correct Answer: 2

Explanation

Fill Down copies the most recent nonblank value downward into subsequent blank cells. It is particularly useful when source data stores a category or identifier only on the first row of a group and leaves the following rows blank. Applying Fill Down makes the associated value available for every record in that group. Fill Up performs the operation in the opposite direction, Replace Values changes specified cell contents, and Remove Blank Rows deletes empty records. Therefore, Fill Down is the correct transformation for carrying values downward.

Question 239

Which DAX function can return the average of an expression evaluated for every row in a table?

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

Correct Answer: 2

Explanation

AVERAGEX evaluates an expression for each row of a table and calculates the average of the resulting values. It is useful when the required average depends on a row-level calculation rather than a value already stored in a column. For example, AVERAGEX(Sales, Sales[Quantity] * Sales[UnitPrice]) can calculate the average transaction value. AVERAGE works directly with a column, MEDIAN calculates a middle value, and SUMX calculates a total. Therefore, AVERAGEX is the appropriate function for averaging calculated row-level results.

Question 240

Which Power BI feature allows a report author to create a customized visual navigation experience between report pages?

1. Page navigation buttons
2. Data categories
3. Conditional formatting
4. Column profiling

Correct Answer: 1

Explanation

Page navigation buttons allow report authors to create interactive controls that move users between report pages. They can be used to build menus, home pages, section navigation, and other structured report experiences. A button can be configured with a page navigation action so that selecting it opens a specified destination page. Data categories provide semantic information about fields, conditional formatting changes visual appearance based on values, and column profiling examines data quality. Therefore, Page navigation buttons are the appropriate feature for customized report navigation.