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

 

Question 141

Which Power BI view is primarily used to create and manage relationships between tables?

1. Report view
2. Data view
3. Model view
4. Reading view

Correct Answer: 3

Explanation

Model view provides a graphical representation of the tables and relationships within a Power BI semantic model. It allows developers to create, modify, and inspect relationships, review cardinality, and configure cross-filter direction. This view is particularly useful when designing or troubleshooting a data model. Report view is used to create report pages and visuals, while Data view is used to inspect table data. Reading view is intended for consuming reports. Therefore, Model view is the appropriate choice for managing table relationships.

Question 142

Which DAX function returns the current date and time from the system?

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

Correct Answer: 2

Explanation

NOW returns the current date and time from the system. It is useful when both the current date and current time are required in a calculation or report. TODAY returns only the current date without the current 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 values. Therefore, when a Power BI calculation requires the current date together with the current time, NOW is the appropriate DAX function.

Question 143

Which Power Query feature allows you to select specific columns and remove all other columns from a query?

1. Choose Columns
2. Group By
3. Fill Down
4. Replace Values

Correct Answer: 1

Explanation

Choose Columns allows you to select the columns that should remain in a Power Query result while excluding all other columns. This is useful when source tables contain unnecessary fields that should not be loaded into the model. Removing irrelevant columns can also simplify the model and reduce unnecessary data. Group By creates summaries, Fill Down fills missing values using preceding values, and Replace Values changes specific cell values. Therefore, Choose Columns is the appropriate feature for retaining only selected columns.

Question 144

Which Power BI visual is most suitable for showing values across several categories when the category names are relatively long?

1. Pie chart
2. Line chart
3. Bar chart
4. Gauge

Correct Answer: 3

Explanation

A bar chart is well suited for comparing values across categories, particularly when category names are long. Horizontal bars provide sufficient space for labels and make comparisons between categories easy to read. A pie chart is generally used to show parts of a whole, a line chart is commonly used for trends over an ordered axis, and a Gauge focuses on a single value against a target. Therefore, a bar chart is an appropriate choice when category labels are lengthy and category comparisons are required.

Question 145

Which DAX function can return the largest value in a column while respecting the current filter context?

1. MIN
2. MAX
3. AVERAGE
4. SUM

Correct Answer: 2

Explanation

MAX returns the largest value in a specified column or expression within the current filter context. For example, a measure using MAX(Sales[SalesAmount]) can identify the highest sales amount visible under the active filters. This allows the result to change when users filter the report by date, product, customer, or another field. MIN returns the smallest value, AVERAGE calculates the arithmetic mean, and SUM adds values. Therefore, MAX is the appropriate DAX function for retrieving the highest value from a column.

Question 146

Which Power Query operation changes rows into columns based on the values of a selected column?

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

Correct Answer: 2

Explanation

Pivot Column transforms values from a selected column into separate columns, often using another column to provide the values placed into those new columns. This is useful when source data is stored in a normalized format but analysis requires categories to appear as individual columns. Unpivot performs the opposite type of restructuring by converting columns into attribute-value rows. Split Column separates one column, while Transpose switches rows and columns. Therefore, Pivot Column is the correct Power Query operation for converting category values into columns.

Question 147

Which DAX function removes filters from a specified table or column when calculating a measure?

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

Correct Answer: 1

Explanation

ALL removes filters from a specified table or column and is commonly used in DAX measures that need to calculate values independently of certain filters. For example, a percentage-of-total calculation may use ALL(Sales) to obtain an overall total against which the current filtered value can be compared. FILTER creates a filtered table expression, VALUES returns distinct values, and SELECTEDVALUE returns a single selected value when applicable. Therefore, ALL is appropriate when a calculation needs to remove existing filter context from specified data.

Question 148

Which Power BI feature can display additional information when a user hovers over a data point?

1. Drillthrough
2. Tooltip
3. Bookmark
4. Slicer

Correct Answer: 2

Explanation

Tooltips display additional information when users hover over data points in a visual. A tooltip can show extra fields or measures without requiring the user to leave the current report page. Power BI also supports dedicated tooltip pages that can provide a customized layout containing additional details. Drillthrough navigates users to another page, bookmarks store report states, and slicers provide interactive filtering. Therefore, Tooltip is the appropriate feature when additional information should appear during mouse hovering over a visual element.

Question 149

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

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

Correct Answer: 2

Explanation

FIRSTDATE returns the first date in the current filter context for a specified date column or table. It can be useful in time-based calculations where the beginning of the selected period needs to be identified. LASTDATE performs the opposite operation by returning the last date in the context. STARTOFMONTH focuses specifically on the beginning of a month, while MINX evaluates an expression across rows and returns the smallest result. Therefore, FIRSTDATE is the appropriate function when the first date of the current context is required.

Question 150

Which Power Query transformation removes rows containing errors from a selected column?

1. Remove Errors
2. Remove Blank Rows
3. Replace Errors
4. Keep Rows

Correct Answer: 1

Explanation

Remove Errors eliminates rows containing errors from a selected column or query. This transformation is useful when invalid records cannot be corrected or should not be included in the final dataset. For example, if a column contains conversion errors caused by incompatible source values, Remove Errors can exclude those affected rows. Remove Blank Rows targets completely blank rows, Replace Errors substitutes another value for errors, and Keep Rows retains rows based on conditions. Therefore, Remove Errors is the correct transformation when error-containing rows should be removed.

Question 151

Which Power BI feature allows users to select one value from a list and use it to filter report visuals?

1. Card
2. Slicer
3. Matrix
4. Shape

Correct Answer: 2

Explanation

A slicer provides an interactive filtering control that allows report users to select values from a field and filter related visuals. For example, a Region slicer can allow users to select North, South, East, or West and update the report accordingly. Cards display individual values, matrices present data in rows and columns, and shapes are primarily decorative or navigational elements. Therefore, a slicer is the appropriate Power BI feature when users need an interactive way to filter report content.

Question 152

Which DAX function counts the number of unique values in a column?

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

Correct Answer: 3

Explanation

DISTINCTCOUNT counts the number of unique values in a column. It is useful when duplicate records should not be counted more than once. For example, DISTINCTCOUNT(Sales[CustomerID]) can determine how many unique customers are represented in the current filter context. COUNT counts numeric values, COUNTA counts nonblank values, and COUNTROWS counts rows in a table. Therefore, DISTINCTCOUNT is the appropriate function when the requirement is to determine the number of distinct values contained in a column.

Question 153

Which Power BI capability allows a user to move from a summarized visual to a more detailed level within the same hierarchy?

1. Drill-down
2. Drillthrough
3. Bookmark
4. Spotlight

Correct Answer: 1

Explanation

Drill-down allows users to move through levels of a hierarchy within the same visual. For example, a date hierarchy may display Year, Quarter, Month, and Day. A user can start at the Year level and drill down to Quarter or Month to examine more detailed information while staying within the same visual. Drillthrough instead navigates to a separate report page containing detailed information. Bookmarks save report states, while Spotlight emphasizes a selected visual. Therefore, Drill-down is the appropriate capability for navigating hierarchy levels.

Question 154

Which DAX function can return a specified value when a calculation results in a blank value?

1. COALESCE
2. DIVIDE
3. FORMAT
4. ROUND

Correct Answer: 1

Explanation

COALESCE returns the first expression that is not BLANK, making it useful for providing fallback values when calculations produce blank results. For example, COALESCE([Sales Measure], 0) can display zero when the sales measure returns BLANK. DIVIDE performs division and can optionally specify an alternate result, FORMAT converts values into formatted text, and ROUND changes numerical precision. Therefore, COALESCE is an effective DAX function when a blank result should be replaced by another available value.

Question 155

Which Power BI visual is designed to show how a value changes continuously over an ordered category such as time?

1. Line chart
2. Treemap
3. Donut chart
4. Card

Correct Answer: 1

Explanation

A line chart is commonly used to display trends across an ordered axis, especially dates or time periods. Connecting data points with lines makes changes, increases, decreases, and patterns easier to identify. For example, monthly revenue can be displayed across a year to show how performance changes over time. Treemaps compare categories using proportional areas, donut charts show parts of a whole, and cards display individual values. Therefore, a line chart is the appropriate visual for presenting continuous trends across an ordered category.

Question 156

Which Power Query transformation can combine multiple columns into one column using a selected delimiter?

1. Merge Columns
2. Split Column
3. Group By
4. Replace Values

Correct Answer: 1

Explanation

Merge Columns combines the values from multiple selected columns into a single column. During the operation, Power Query can insert a delimiter such as a space, comma, or hyphen between the values. This is useful for creating full names from first and last names or combining separate address components. Split Column performs the opposite task by dividing one column into multiple columns. Group By creates aggregations, while Replace Values modifies matching values. Therefore, Merge Columns is the appropriate transformation for combining multiple columns into one.

Question 157

Which DAX function returns the year component from a date value?

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

Correct Answer: 2

Explanation

YEAR extracts the year component from a date value. For example, YEAR(DATE(2026, 9, 15)) returns 2026. This function can be used in calculated columns, measures, or date-related transformations where the year needs to be separated from a complete date. MONTH returns the month number, DATE creates a date from individual components, and WEEKDAY returns the day-of-week number. Therefore, YEAR is the correct DAX function when the requirement is to retrieve the year from a date.

Question 158

Which Power BI feature allows a report author to create a button that navigates users to another report page?

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

Correct Answer: 2

Explanation

Page navigation allows buttons to direct users to another page within the same Power BI report. It is useful for creating intuitive navigation menus, home pages, and interactive report experiences. A button can be configured with a page navigation action so that selecting it opens the specified destination page. Data alerts are associated with dashboard tiles, conditional formatting changes visual appearance based on values, and column profiling is a Power Query data-quality feature. Therefore, Page navigation is the appropriate capability for button-based movement between report pages.

Question 159

Which DAX function can return the average value of a numeric column while respecting the current filter context?

1. AVERAGE
2. AVERAGEX
3. MEDIANX
4. SUM

Correct Answer: 1

Explanation

AVERAGE calculates the arithmetic mean of the numeric values in a column while respecting the current filter context. This means the result can change when users filter the report by products, regions, dates, or other dimensions. AVERAGEX evaluates an expression row by row before calculating an average, while MEDIANX calculates a median from an expression. SUM adds numeric values instead of calculating an average. Therefore, AVERAGE is the appropriate DAX function when the average of an existing numeric column is required.

Question 160

Which Power Query feature allows you to sort records based on one or more columns?

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

Correct Answer: 2

Explanation

The Sort transformation arranges rows according to the values in one or more selected columns. Users can sort values in ascending or descending order and can apply sorting to multiple columns to establish additional ordering rules. Filter Rows removes records that do not meet specified conditions, Group By creates aggregated results, and Replace Values changes matching cell values. Therefore, Sort is the appropriate Power Query feature when records need to be organized according to selected column values.