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

 

Question 361

Which DAX function can return the total sales while preserving filters selected outside the current visual?

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

Correct Answer: 3

Explanation

ALLSELECTED returns values while retaining filters that come from outside the current visual or query context. It is commonly used for calculations such as visual totals, where a measure should compare the current selection with the broader selection made by the report user. For example, ALLSELECTED can help calculate a product’s percentage of the total visible across a selected region. ALL and REMOVEFILTERS remove specified filters more broadly, while DISTINCT returns unique values. Therefore, ALLSELECTED is appropriate when external selections should remain part of the calculation.

Question 362

Which Power Query transformation can reverse the order of rows in a table?

1. Reverse Rows
2. Sort Rows
3. Transpose
4. Keep Bottom Rows

Correct Answer: 1

Explanation

Reverse Rows changes the order of records so that the last row becomes the first and the first row becomes the last. This can be useful when source data is arranged in reverse chronological order or when a transformation requires records to be processed from the opposite direction. Sort Rows orders records according to selected column values, while Transpose switches rows and columns. Keep Bottom Rows retains a specified number of records rather than reversing their order. Therefore, Reverse Rows is the appropriate Power Query transformation.

Question 363

Which DAX function can return the number of unique values in a column while excluding blank values?

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

Correct Answer: 2

Explanation

DISTINCTCOUNTNOBLANK counts distinct values in a column while excluding blank values. It is useful when the analysis requires the number of unique meaningful entries and missing values should not contribute to the result. For example, it can count unique customer IDs while ignoring records where CustomerID is blank. DISTINCTCOUNT can include a blank as a distinct value, COUNTROWS counts table records, and COUNTA counts nonblank values without specifically performing a distinct count. Therefore, DISTINCTCOUNTNOBLANK is the correct function.

Question 364

Which Power BI visual is most appropriate for showing the composition of a total using segments within a circle?

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

Correct Answer: 2

Explanation

A Donut chart displays categories as segments of a circular ring, allowing users to compare each category’s contribution to the overall total. It is useful when the number of categories is relatively small and the main purpose is to show proportions. A Treemap uses rectangular areas, a Scatter chart shows relationships between numerical variables, and a Gauge displays progress toward a target. Therefore, a Donut chart is the appropriate visual when the composition of a total needs to be represented using circular segments.

Question 365

Which DAX function can return a table filtered according to a specified Boolean condition?

1. VALUES
2. FILTER
3. DISTINCT
4. ALL

Correct Answer: 2

Explanation

FILTER returns a table containing only the rows that satisfy a specified condition. It is frequently used inside more complex DAX calculations when the required filtering logic cannot be expressed using a simple column filter. For example, FILTER can return sales rows where the transaction amount is greater than a particular threshold. VALUES returns values from the current context, DISTINCT returns unique values, and ALL removes filters. Therefore, FILTER is the appropriate DAX function when a table needs to be restricted according to a condition.

Question 366

Which Power Query feature allows a user to create a copy of an existing query and its transformation steps?

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

Correct Answer: 2

Explanation

Duplicate creates a separate copy of an existing Power Query query, including its transformation steps. This can be useful when two queries need to begin with the same source and initial transformations but later follow different processing paths. Reference instead creates a query based on the output of another query, allowing the new query to depend on the existing result. Merge combines tables using matching columns, while Append combines rows from multiple queries. Therefore, Duplicate is the appropriate feature for creating an independent copy of a query.

Question 367

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

1. MONTH
2. QUARTER
3. YEAR
4. WEEKNUM

Correct Answer: 2

Explanation

QUARTER returns the quarter number associated with a date, producing a value from 1 through 4. This can be useful when creating calculated columns or grouping report data by fiscal or calendar quarter. For example, a date in September belongs to quarter 3 of a standard calendar year. MONTH returns the month number, YEAR returns the year, and WEEKNUM returns the week number within a year. Therefore, QUARTER is the appropriate DAX function when the quarter component of a date is required.

Question 368

Which Power BI feature allows users to view a report in a layout optimized for smaller screens?

1. Mobile layout
2. Theme
3. Tooltip
4. Bookmark

Correct Answer: 1

Explanation

Mobile layout provides a report design specifically optimized for smaller screens such as smartphones. Report authors can rearrange supported visuals and adjust their sizes so that important information remains readable and accessible on mobile devices. The desktop layout can remain unchanged while the mobile layout provides a more suitable presentation for phone users. Themes control visual formatting, Tooltips display additional information, and Bookmarks save report states. Therefore, Mobile layout is the appropriate Power BI feature for creating a small-screen report experience.

Question 369

Which DAX function can activate a relationship that is inactive in the model for a specific calculation?

1. RELATED
2. USERELATIONSHIP
3. CROSSFILTER
4. LOOKUPVALUE

Correct Answer: 2

Explanation

USERELATIONSHIP activates an existing inactive relationship while a calculation is being evaluated. This is particularly useful when two tables have multiple possible relationships, such as a Sales table containing both OrderDate and ShipDate connected to the same Date table. One relationship can be active by default while USERELATIONSHIP allows a measure to temporarily use the alternative relationship. RELATED retrieves a related value, CROSSFILTER changes filter direction, and LOOKUPVALUE searches for matching values. Therefore, USERELATIONSHIP is correct.

Question 370

Which Power Query transformation can change a column from text containing separate values into multiple fields using a delimiter?

1. Merge Columns
2. Split Column
3. Pivot Column
4. Group By

Correct Answer: 2

Explanation

Split Column can separate the contents of one column into multiple columns using a delimiter, character count, or another supported method. For example, a column containing “John Smith” can be divided into First Name and Last Name using a space delimiter. This is useful when source systems store multiple pieces of information in a single field. Merge Columns performs the reverse operation by combining fields, Pivot Column restructures values, and Group By creates summaries. Therefore, Split Column is the correct transformation.

Question 371

Which DAX function can return a value based on multiple conditions without requiring nested IF statements?

1. SWITCH
2. FORMAT
3. COALESCE
4. ABS

Correct Answer: 1

Explanation

SWITCH evaluates an expression against multiple possible values or conditions and returns the corresponding result. It can make DAX logic easier to read when several outcomes are possible. For example, a sales measure can classify performance as High, Medium, or Low based on predefined conditions. This can be easier to maintain than deeply nested IF statements. FORMAT converts values to text, COALESCE returns the first nonblank expression, and ABS returns an absolute value. Therefore, SWITCH is appropriate for handling multiple conditional outcomes.

Question 372

Which Power BI feature allows a report author to control whether selecting one visual filters or highlights another visual?

1. Edit Interactions
2. Sync Slicers
3. Bookmarks
4. Query Dependencies

Correct Answer: 1

Explanation

Edit Interactions controls how visuals respond to selections made in other visuals on the same report page. A report author can configure an interaction so that a selection filters another visual, highlights it, or has no effect on it. This provides greater control over the report’s analytical behavior and user experience. Sync Slicers synchronizes slicer selections between pages, Bookmarks save report states, and Query Dependencies displays query relationships. Therefore, Edit Interactions is the correct feature for controlling visual interactions.

Question 373

Which DAX function can return the first nonblank value from a column according to an expression?

1. FIRSTDATE
2. FIRSTNONBLANK
3. MIN
4. VALUES

Correct Answer: 2

Explanation

FIRSTNONBLANK returns the first value in a column for which a specified expression is not blank. It is useful when a calculation needs to identify the earliest meaningful value rather than simply the first value in the column. For example, it can help identify the first date associated with recorded sales activity. FIRSTDATE returns the first date in the current context, MIN returns the smallest value, and VALUES returns a table of values. Therefore, FIRSTNONBLANK is the appropriate function for finding the first nonblank result.

Question 374

Which Power BI feature allows report authors to organize visuals and control their visibility on a report page?

1. Selection pane
2. Data view
3. Model view
4. Query Dependencies

Correct Answer: 1

Explanation

The Selection pane provides a list of objects on a report page and allows authors to manage their visibility and layering order. It is especially useful when a page contains overlapping visuals, buttons, shapes, or images. Authors can hide objects temporarily and organize their stacking order without deleting them. Data view is used to inspect table data, Model view manages relationships and model structure, and Query Dependencies displays connections between queries. Therefore, Selection pane is the appropriate feature for managing report-page objects.

Question 375

Which DAX function can return the current date and time?

1. TODAY
2. NOW
3. DATE
4. TIME

Correct Answer: 2

Explanation

NOW returns the current date and time as a datetime value. It is useful when calculations need to consider both the current date and the current time, such as determining elapsed time or comparing timestamps. TODAY returns only the current date without the time component. DATE creates a date from specified year, month, and day values, while TIME creates a time value from specified hour, minute, and second components. Therefore, NOW is the correct DAX function when both the current date and time are required.

Question 376

Which Power Query feature allows users to inspect the distribution and quality of values within columns?

1. Column Profiling
2. Query Dependencies
3. Merge Queries
4. Applied Steps

Correct Answer: 1

Explanation

Column Profiling provides information about the contents and quality of data in Power Query columns. It can help users examine value distributions, identify errors, and detect empty or unexpected values during data preparation. This makes it useful for discovering data-quality issues before the dataset is loaded into the Power BI model. Query Dependencies shows relationships between queries, Merge Queries combines related tables, and Applied Steps lists transformations applied to the current query. Therefore, Column Profiling is the appropriate feature for inspecting column quality.

Question 377

Which DAX function can return the total for a year-to-date period without requiring a manually constructed date filter?

1. TOTALYTD
2. DATESYTD
3. YEAR
4. PREVIOUSYEAR

Correct Answer: 1

Explanation

TOTALYTD calculates an expression over the year-to-date period based on the current date context. It simplifies common year-to-date calculations because the function handles the accumulation of values from the beginning of the year through the current date. For example, TOTALYTD([Total Sales], ‘Date'[Date]) can calculate cumulative sales for the current year. DATESYTD returns a date table rather than directly calculating the expression, YEAR extracts a year number, and PREVIOUSYEAR references the prior year. Therefore, TOTALYTD is correct.

Question 378

Which Power BI relationship direction allows filters to propagate from both related tables?

1. Single
2. Both
3. Forward
4. None

Correct Answer: 2

Explanation

The Both cross-filter direction allows filters to propagate between both tables participating in a relationship. This can be useful in certain modeling scenarios where filtering either table needs to affect the other table. However, bidirectional filtering should be used carefully because unnecessary relationships in both directions can introduce ambiguity or unexpected filtering behavior. Single allows filtering primarily in one direction, while Forward and None are not standard cross-filter direction choices in Power BI relationships. Therefore, Both is the correct option.

Question 379

Which DAX function can return a table of dates from the beginning of the current month through the selected date?

1. DATESMTD
2. TOTALMTD
3. DATEADD
4. MONTH

Correct Answer: 1

Explanation

DATESMTD returns a table containing dates from the beginning of the current month through the last date in the current filter context. It is useful when constructing custom month-to-date calculations with CALCULATE or other DAX functions. TOTALMTD directly calculates an expression over the month-to-date period, while DATEADD shifts a date context and MONTH extracts the month number. Therefore, DATESMTD is the appropriate function when the month-to-date date table itself is required.

Question 380

Which Power BI feature allows users to subscribe to a report or dashboard and receive scheduled email updates?

1. Data alerts
2. Subscriptions
3. Bookmarks
4. Drillthrough

Correct Answer: 2

Explanation

Subscriptions allow users to receive scheduled email snapshots or updates related to Power BI reports and dashboards, depending on the available service capabilities and permissions. This can help users stay informed without manually opening the report each time. Data alerts are designed to notify users when a monitored dashboard value reaches a specified condition. Bookmarks save report states, while Drillthrough provides navigation to detailed pages. Therefore, Subscriptions is the appropriate Power BI feature for receiving scheduled report-related email updates.