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

 

Question 341

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

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

Correct Answer: 2

Explanation

YEAR extracts the year component from a date value and returns it as a number. For example, YEAR(DATE(2026, 9, 17)) returns 2026. This function is useful when creating calculated columns, grouping data by year, or building date-based calculations. MONTH returns the month number, DAY returns the day of the month, and WEEKDAY returns a number representing the day of the week. Therefore, YEAR is the appropriate DAX function when the year portion of a date needs to be retrieved.

Question 342

Which Power Query transformation can remove rows from the bottom of a table?

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

Correct Answer: 3

Explanation

Remove Bottom Rows eliminates a specified number of records from the end of a Power Query table. It can be useful when a source file contains totals, notes, footers, or other records after the main dataset. For example, if the final two rows contain report summaries rather than transaction data, they can be removed before loading the table. Remove Top Rows works from the beginning, Remove Blank Rows removes empty records, and Keep Bottom Rows retains records from the end. Therefore, Remove Bottom Rows is correct.

Question 343

Which DAX function can return the corresponding date period from the next year?

1. NEXTYEAR
2. PREVIOUSYEAR
3. SAMEPERIODLASTYEAR
4. YEAR

Correct Answer: 1

Explanation

NEXTYEAR returns a table containing dates from the year immediately following the current date context. It can be useful when calculations need to compare or analyze future annual periods. For example, a measure can use NEXTYEAR to evaluate an expression against the following year’s date range. PREVIOUSYEAR returns the preceding year, SAMEPERIODLASTYEAR returns the corresponding period from one year earlier, and YEAR extracts the year number. Therefore, NEXTYEAR is the appropriate DAX function when the next year’s date context is required.

Question 344

Which Power BI feature allows a report author to create a reusable page containing visuals that appear when users hover over other visuals?

1. Drillthrough page
2. Tooltip page
3. Bookmark page
4. Navigation page

Correct Answer: 2

Explanation

A Tooltip page is a dedicated report page designed to provide additional information when users hover over data points in supported visuals. It can contain multiple visuals and can provide more detailed context than a standard tooltip. For example, hovering over a product in a sales chart can display a tooltip page containing sales, profit, and quantity information. A Drillthrough page is accessed through a selected data point, while bookmarks save report states and navigation pages support movement between pages. Therefore, Tooltip page is correct.

Question 345

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

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

Correct Answer: 2

Explanation

MINX evaluates an expression for each row of a table and returns the smallest resulting value. It is useful when the value being compared must first be calculated at the row level. For example, MINX can evaluate Quantity multiplied by Unit Price for every transaction and return the lowest calculated amount. MIN directly returns the smallest value from a column, MAXX returns the largest row-level result, and AVERAGEX calculates an average. Therefore, MINX is the appropriate DAX function for row-by-row minimum calculations.

Question 346

Which Power BI filter type affects only the visual to which it is applied?

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

Correct Answer: 3

Explanation

A visual-level filter applies only to the specific visual where the filter is configured. This allows report authors to restrict one chart, table, or other visual without changing the data displayed by other visuals on the same page. Page-level filters affect all applicable visuals on one page, while report-level filters affect the entire report. A slicer provides an interactive filtering mechanism rather than representing this standard filter scope. Therefore, a visual-level filter is the correct choice when only one visual should be affected.

Question 347

Which DAX function can return a table containing the values from a column after removing duplicate entries?

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

Correct Answer: 1

Explanation

DISTINCT returns a table containing the unique values from a specified column or table expression. It is useful when a DAX calculation needs a list of values without repeated entries. For example, DISTINCT(Customer[City]) can return each city only once from the customer table. VALUES can also return distinct values but has behavior related to the current filter context and blank values that differs in some situations. FILTER creates a filtered table, while ALL removes filters. Therefore, DISTINCT is appropriate for explicitly obtaining unique values.

Question 348

Which Power Query feature allows users to change the name of a column without changing its underlying data?

1. Rename
2. Replace Values
3. Change Type
4. Split Column

Correct Answer: 1

Explanation

Rename changes the name of a selected column while leaving the values and underlying data unchanged. Clear and meaningful column names are important because they make Power Query transformations and the resulting Power BI model easier to understand. For example, a column named “Col1” can be renamed to “Customer Name” without altering its records. Replace Values modifies cell contents, Change Type changes the data type, and Split Column divides one field into multiple fields. Therefore, Rename is the correct transformation for changing a column name.

Question 349

Which DAX function can return the first date of the year in the current date context?

1. STARTOFYEAR
2. FIRSTDATE
3. DATE
4. YEAR

Correct Answer: 1

Explanation

STARTOFYEAR returns a table containing the first date of the year in the current date context. It is commonly used in time-intelligence calculations where a measure needs to reference the beginning of the current year. FIRSTDATE returns the earliest date in the current context but does not specifically represent the beginning of the year. DATE creates a date from individual components, while YEAR extracts the year number. Therefore, STARTOFYEAR is the appropriate DAX function when the beginning of the current year is required.

Question 350

Which Power BI visual is commonly used to show the relationship between two numerical variables?

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

Correct Answer: 2

Explanation

A Scatter chart is designed to display the relationship between two numerical variables by plotting individual data points along horizontal and vertical axes. It can help identify correlations, clusters, outliers, and general patterns in the data. For example, a business can compare advertising expenditure with sales revenue using a scatter chart. A Line chart is generally used to show trends over an ordered axis, a Funnel chart represents sequential stages, and a Card displays a summarized value. Therefore, Scatter chart is the appropriate visual for this purpose.

Question 351

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

1. TOTALQTD
2. DATESQTD
3. DATEADD
4. QUARTER

Correct Answer: 2

Explanation

DATESQTD returns a table containing dates from the beginning of the current quarter through the last date in the current filter context. It is useful for constructing custom quarter-to-date calculations with CALCULATE and other DAX expressions. TOTALQTD directly evaluates an expression over the quarter-to-date period, while DATEADD shifts dates by a specified interval. QUARTER extracts the quarter number from a date. Therefore, DATESQTD is the appropriate function when the requirement is to return the quarter-to-date date range itself.

Question 352

Which Power Query feature can remove records containing empty values from a table?

1. Remove Errors
2. Remove Duplicates
3. Remove Blank Rows
4. Replace Values

Correct Answer: 3

Explanation

Remove Blank Rows removes rows that are completely blank from a Power Query table. This can be useful when imported spreadsheets or text files contain empty records between actual data rows. Removing these unnecessary rows helps create a cleaner dataset before it is loaded into the Power BI model. Remove Errors targets records containing errors, Remove Duplicates eliminates repeated records, and Replace Values changes matching cell contents. Therefore, Remove Blank Rows is the appropriate transformation when completely empty records need to be removed.

Question 353

Which DAX function can return the difference between two dates using a specified time interval?

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

Correct Answer: 2

Explanation

DATEDIFF calculates the difference between two dates according to a specified interval. The interval can be expressed as day, week, month, quarter, or year, depending on the requirement. For example, DATEDIFF(StartDate, EndDate, MONTH) can determine the number of month boundaries between two dates. DATEADD shifts a date context, EDATE shifts an individual date by months, and EOMONTH returns a month-end date. Therefore, DATEDIFF is the appropriate DAX function when the difference between two dates needs to be measured.

Question 354

Which Power BI feature allows report authors to hide a page from normal report navigation while keeping it available for specific purposes?

1. Hidden page
2. Mobile layout
3. Tooltip
4. Selection pane

Correct Answer: 1

Explanation

A hidden page can be removed from normal report navigation while remaining part of the report. Hidden pages can be useful for supporting content, specialized navigation designs, or pages that should not appear in the standard page list. For example, a report may contain a supporting analysis page that is accessed through a specific navigation mechanism rather than shown to every user. Mobile layout controls phone-specific design, Tooltips provide hover information, and Selection Pane manages objects on a page. Therefore, Hidden page is correct.

Question 355

Which DAX function can return the number of unique values in a column while counting blank as a distinct value when applicable?

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

Correct Answer: 1

Explanation

DISTINCTCOUNT counts the number of distinct values in a column and can include a blank value as a distinct value when one is present. This makes it useful when every distinct category, including a blank category, needs to be represented in the count. DISTINCTCOUNTNOBLANK specifically excludes blank values. COUNT counts numeric values rather than unique values, while COUNTROWS counts records. Therefore, DISTINCTCOUNT is the appropriate function when unique values should be counted without specifically excluding blanks.

Question 356

Which Power BI feature allows a report to contain a clickable control that can perform navigation or trigger another report action?

1. Button
2. Card
3. Matrix
4. Gauge

Correct Answer: 1

Explanation

Buttons provide interactive controls that can perform actions such as page navigation, drillthrough, applying bookmarks, or other supported report actions. They are commonly used to create navigation menus and improve the user experience of a report. For example, a button can take users from a summary page to a detailed analysis page. A Card displays a value, a Matrix presents structured data, and a Gauge compares a measure with a target. Therefore, Button is the appropriate Power BI feature for creating a clickable report control.

Question 357

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

1. MAX
2. MAXX
3. TOPN
4. RANKX

Correct Answer: 2

Explanation

MAXX evaluates an expression for each row of a table and returns the largest resulting value. This makes it useful when the maximum value must be calculated from a row-level expression rather than directly from an existing column. For example, MAXX(Sales, Sales[Quantity] * Sales[UnitPrice]) can identify the largest calculated transaction amount. MAX works directly with a column or expression, TOPN returns a set of top rows, and RANKX calculates rankings. Therefore, MAXX is the appropriate function for row-level maximum calculations.

Question 358

Which Power Query transformation can organize records into groups and calculate summaries such as totals or averages?

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

Correct Answer: 2

Explanation

Group By organizes rows according to selected columns and can calculate aggregations such as Sum, Average, Count Rows, Minimum, or Maximum. For example, sales records can be grouped by Region to calculate total sales for each region. This transformation is useful for creating summary datasets before loading data into Power BI. Pivot Column restructures values into columns, Split Column separates one field into multiple fields, and Fill Down populates blank values. Therefore, Group By is the appropriate Power Query transformation for creating grouped summaries.

Question 359

Which DAX function can return a table containing dates from the previous year corresponding to the current date context?

1. PREVIOUSYEAR
2. SAMEPERIODLASTYEAR
3. NEXTYEAR
4. YEAR

Correct Answer: 2

Explanation

SAMEPERIODLASTYEAR returns dates corresponding to the same period in the previous year based on the current date context. It is commonly used for year-over-year comparisons where the current selection may represent a specific month, quarter, or range of dates. For example, it can help compare current-month sales with sales from the same month in the prior year. PREVIOUSYEAR returns the previous year’s period, NEXTYEAR moves to the following year, and YEAR extracts a year number. Therefore, SAMEPERIODLASTYEAR is correct.

Question 360

Which Power BI capability can automatically detect relationships between tables when compatible columns are identified?

1. Manage Relationships
2. Auto-detect relationships
3. Query Dependencies
4. Column Profiling

Correct Answer: 2

Explanation

Auto-detect relationships can identify potential relationships between tables by examining compatible columns and their values. This can simplify the initial modeling process when imported datasets contain fields that clearly correspond, such as matching customer or product identifiers. Users should still review automatically detected relationships to ensure that the resulting model reflects the intended business logic. Manage Relationships provides manual relationship management, Query Dependencies shows query connections, and Column Profiling examines data quality. Therefore, Auto-detect relationships is the correct capability.