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

 

Question 281

Which DAX function can preserve existing filters while adding a new filter condition to a calculation?

1. REMOVEFILTERS
2. ALL
3. KEEPFILTERS
4. DISTINCT

Correct Answer: 3

Explanation

KEEPFILTERS modifies the behavior of filters used inside functions such as CALCULATE by preserving existing filters while applying an additional restriction. Without KEEPFILTERS, a new filter on the same column can replace an existing filter. For example, it can be useful when a calculation needs to further restrict products while retaining the user’s current product selection. REMOVEFILTERS clears filters, ALL can remove filter context, and DISTINCT returns unique values. Therefore, KEEPFILTERS is the appropriate function when existing filters should remain active.

Question 282

Which Power Query feature can use the first row of a dataset as the column names?

1. Use First Row as Headers
2. Fill Down
3. Promote Values
4. Rename Columns

Correct Answer: 1

Explanation

Use First Row as Headers promotes the first row of a Power Query table to become the column headers. This is particularly useful when importing spreadsheets or text files where the actual column names are stored in the first row rather than being recognized automatically. Once promoted, the values in that row become field names for subsequent transformations and modeling. Fill Down copies values into empty cells, while Rename Columns changes existing column names individually. Therefore, Use First Row as Headers is the appropriate Power Query feature.

Question 283

Which DAX function can return the last date for which an expression is not blank in the current date context?

1. LASTDATE
2. LASTNONBLANK
3. MAX
4. ENDOFMONTH

Correct Answer: 2

Explanation

LASTNONBLANK returns the last value in a column for which an expression is not blank. It is useful when the latest date with meaningful data needs to be identified rather than simply returning the latest date in the calendar. For example, it can help locate the most recent date on which sales were recorded. LASTDATE returns the last date in the current context, MAX returns the largest value, and ENDOFMONTH returns the last date of a month. Therefore, LASTNONBLANK is the appropriate function.

Question 284

Which Power BI visual is designed to show how a starting value changes into a final value through positive and negative contributions?

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

Correct Answer: 2

Explanation

A Waterfall chart shows how individual positive and negative changes contribute to a starting value and ultimately produce a final value. It is useful for analyzing changes in revenue, profit, expenses, inventory, or other measures where increases and decreases need to be displayed sequentially. A Funnel chart focuses on stages in a process, a Gauge compares a value with a target, and a Card displays a single summarized value. Therefore, a Waterfall chart is the appropriate visual for showing cumulative increases and decreases.

Question 285

Which DAX function can return the number of distinct nonblank values in a column?

1. DISTINCTCOUNTNOBLANK
2. DISTINCT
3. COUNT
4. VALUES

Correct Answer: 1

Explanation

DISTINCTCOUNTNOBLANK counts the distinct values in a column while excluding blank values from the result. This can be useful when a dataset contains missing identifiers and the analysis should count only meaningful unique entries. For example, it can calculate the number of unique customers while ignoring records where the customer identifier is blank. DISTINCT returns a table of unique values, COUNT counts numeric values, and VALUES returns a table of values under the current context. Therefore, DISTINCTCOUNTNOBLANK is the appropriate function.

Question 286

Which Power Query option creates a new query that is based on the results of an existing query without copying its transformation steps independently?

1. Duplicate
2. Reference
3. Merge
4. Append

Correct Answer: 2

Explanation

Reference creates a new query based on the output of an existing query. The referenced query uses the existing query’s result as its starting point, which can be useful when several queries need to build different transformations from a common prepared dataset. Duplicate creates a separate copy of the query and its transformation steps. Merge joins queries based on matching columns, while Append combines rows from multiple queries. Therefore, Reference is the appropriate option when a new query should depend on an existing query’s output.

Question 287

Which DAX function can return a value from another table when multiple search conditions are specified?

1. LOOKUPVALUE
2. RELATEDTABLE
3. CALCULATETABLE
4. VALUES

Correct Answer: 1

Explanation

LOOKUPVALUE searches for a value in a table using one or more search conditions and returns the corresponding result. It can be useful when a matching relationship is not being used directly for the required lookup. For example, a calculation can search for a product code and region and return a corresponding price. RELATED retrieves a related column value through an established relationship, while RELATEDTABLE returns related rows. CALCULATETABLE produces a filtered table expression. Therefore, LOOKUPVALUE is appropriate when multiple search conditions are required.

Question 288

Which Power BI feature lets a report author change the fields used by a visual through a user selection?

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

Correct Answer: 2

Explanation

Field parameters allow report users to dynamically change the fields or measures displayed in a visual. For example, a chart can let users switch between Sales, Profit, and Quantity without requiring separate visuals for each measure. This provides a flexible way to create interactive reports while reducing visual duplication. Bookmarks save report states, Themes control visual formatting, and Tooltips provide additional information when users hover over visuals. Therefore, Field parameters are the appropriate Power BI feature for dynamically changing fields in a visual.

Question 289

Which DAX function can return the total for a quarter-to-date calculation?

1. TOTALMTD
2. TOTALYTD
3. TOTALQTD
4. QUARTER

Correct Answer: 3

Explanation

TOTALQTD calculates the quarter-to-date value of an expression based on the current date context. It accumulates values from the beginning of the current quarter through the selected date. This is useful for monitoring metrics such as quarterly sales, expenses, or profit as the quarter progresses. TOTALMTD performs a month-to-date calculation, TOTALYTD calculates year-to-date values, and QUARTER is used to obtain a quarter number rather than calculate a total. Therefore, TOTALQTD is the appropriate DAX function for quarter-to-date calculations.

Question 290

Which Power Query transformation can add values from the previous row into blank cells below them?

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

Correct Answer: 1

Explanation

Fill Down copies the value from the nearest nonblank cell above into subsequent blank cells in the selected column. This is useful when source data uses grouped labels, where a category is listed once and the following records contain blank cells until the next category begins. Filling down makes each record self-contained and easier to analyze. Replace Values changes specified values, Remove Blank Rows removes entire empty records, and Transpose switches rows and columns. Therefore, Fill Down is the appropriate transformation for populating blank cells from preceding values.

Question 291

Which DAX function can return the absolute value of a number?

1. ABS
2. ROUND
3. MOD
4. SIGN

Correct Answer: 1

Explanation

ABS returns the absolute value of a number, meaning it removes the negative sign when the input is negative while leaving positive values unchanged. For example, ABS(-250) returns 250. This can be useful when analyzing differences where only the magnitude of the variance matters. ROUND changes the precision of a number, MOD returns a remainder after division, and SIGN identifies whether a number is positive, negative, or zero. Therefore, ABS is the correct DAX function when the magnitude without regard to sign is required.

Question 292

Which Power BI report layout is specifically designed to optimize a report for display on a phone?

1. Desktop layout
2. Mobile layout
3. Print layout
4. Presentation layout

Correct Answer: 2

Explanation

Mobile layout is designed to optimize Power BI report pages for smaller phone screens. Report authors can arrange and resize supported visuals specifically for mobile viewing rather than relying entirely on the desktop arrangement. This helps improve readability and navigation when users access reports through mobile devices. Desktop layout is designed for larger screens, while print and presentation layouts are not the dedicated Power BI report design modes for phone optimization. Therefore, Mobile layout is the appropriate choice for creating a phone-friendly report experience.

Question 293

Which DAX function can change a numeric value into formatted text?

1. FORMAT
2. VALUE
3. CONVERT
4. ROUND

Correct Answer: 1

Explanation

FORMAT converts a value into text using a specified formatting pattern. It can be used to display numbers as currency, percentages, dates, or other formatted representations. For example, FORMAT(0.25, “0%”) can produce a text result representing 25 percent. Because FORMAT returns text, it should be used carefully when the resulting value still needs to participate in numerical calculations. VALUE converts text to a numeric value, while ROUND changes numeric precision. Therefore, FORMAT is the correct function for creating formatted text.

Question 294

Which Power Query transformation can keep only a specified number of rows from the beginning of a table?

1. Keep Bottom Rows
2. Keep Top Rows
3. Remove Top Rows
4. Filter Rows

Correct Answer: 2

Explanation

Keep Top Rows retains a specified number of records from the beginning of a Power Query table and removes the remaining rows from the resulting query. It can be useful when working with samples, preview datasets, or source files where only the first set of records is required. Keep Bottom Rows performs the same type of operation from the end of the table. Remove Top Rows eliminates records from the beginning, while Filter Rows retains records according to conditions. Therefore, Keep Top Rows is correct.

Question 295

Which DAX function can return the date that occurs a specified number of months before or after a given date?

1. EDATE
2. DATEDIFF
3. DATEADD
4. EOMONTH

Correct Answer: 1

Explanation

EDATE returns a date that occurs a specified number of months before or after a starting date. For example, EDATE can shift a date forward by three months or backward by one month. It is useful for calculations involving subscription periods, anniversaries, payment schedules, or other month-based offsets. DATEDIFF calculates the difference between two dates, DATEADD shifts dates in a date column or table context, and EOMONTH returns the end of a month. Therefore, EDATE is appropriate for shifting an individual date by months.

Question 296

Which Power BI visual is particularly useful for comparing categories across multiple dimensions using rows and columns?

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

Correct Answer: 1

Explanation

A Matrix visual displays data using rows and columns and can represent hierarchical information across multiple dimensions. It supports features such as expandable row and column groups, subtotals, and conditional formatting. For example, a matrix can display sales by region in rows and years in columns while also showing product categories at additional hierarchy levels. A Card displays a single value, a Gauge compares performance with a target, and a Funnel chart represents stages. Therefore, Matrix is the appropriate visual for multidimensional tabular comparisons.

Question 297

Which DAX function can return the day of the week as a number for a given date?

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

Correct Answer: 1

Explanation

WEEKDAY returns a number representing the day of the week for a specified date. Its optional return-type argument can control how the days are numbered, such as starting the week on Sunday or Monday. This makes WEEKDAY useful for creating weekday-based calculations, schedules, and classifications. DAY returns the day number within the month, WEEKNUM returns the week number within a year, and MONTH returns the month number. Therefore, WEEKDAY is the appropriate DAX function when the weekday number is required.

Question 298

Which Power Query transformation switches rows into columns and columns into rows?

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

Correct Answer: 3

Explanation

Transpose switches the orientation of a table so that rows become columns and columns become rows. It can be useful when source data is arranged in an orientation that does not suit the intended analysis. After transposing, additional transformations can be applied to create appropriate headers and data types. Pivot Column converts category values into columns, Unpivot Columns converts columns into attribute-value rows, and Split Column separates one column into multiple columns. Therefore, Transpose is the correct Power Query transformation for switching rows and columns.

Question 299

Which DAX function can return the remainder after dividing one number by another?

1. DIVIDE
2. MOD
3. QUOTIENT
4. ROUND

Correct Answer: 2

Explanation

MOD returns the remainder after one number is divided by another. For example, MOD(10, 3) returns 1 because 1 remains after dividing 10 by 3. This function can be useful for identifying repeating patterns, alternating groups, or determining whether values are evenly divisible. DIVIDE performs division and can provide an alternate result for division-by-zero situations, while ROUND changes numerical precision. Therefore, MOD is the appropriate DAX function when the remainder from a division operation is required.

Question 300

Which Power BI feature allows a report author to control which visuals are visible and manage their layering order on a page?

1. Selection pane
2. Bookmarks
3. Sync slicers
4. Data labels

Correct Answer: 1

Explanation

The Selection pane allows report authors to manage the visibility and layering order of visuals and other objects on a report page. It is useful when several objects overlap or when certain elements need to be shown or hidden during report design. Authors can rename objects and control which ones are visible, making complex page layouts easier to manage. Bookmarks save specific report states, Sync slicers coordinates slicer selections across pages, and Data labels display values on visuals. Therefore, Selection pane is the correct feature.