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

 

Question 61

Which Power Query feature allows you to rename a column during the data transformation process?

1. Rename
2. Merge Queries
3. Group By
4. Unpivot Columns

Correct Answer: 1

Explanation

Power Query provides a Rename command that allows column names to be changed during data preparation. Renaming columns can make datasets easier to understand and can ensure that field names follow consistent business terminology. The change is recorded as a transformation step and is automatically reapplied when the query refreshes. Merge Queries combines tables, Group By summarizes records, and Unpivot Columns changes columns into rows. Therefore, when the requirement is simply to change the name of an existing column before loading data into the model, the Rename operation is appropriate.

Question 62

Which DAX function can be used to return the current date without including the current time?

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

Correct Answer: 2

Explanation

The TODAY function returns the current date based on the evaluation environment without including a time component. It is useful when creating calculations that depend on the current calendar date. NOW, in contrast, returns both the current date and time. DATE creates a date from specified year, month, and day components, while YEAR extracts the year from an existing date. Therefore, when a DAX calculation requires only the current date and not the current time, TODAY is the appropriate function.

Question 63

A Power BI model contains multiple tables with duplicate customer information. Which modeling approach can help reduce unnecessary repeated data?

1. Create a dedicated Customer dimension
2. Duplicate every table
3. Create unrelated tables
4. Store all calculations as text

Correct Answer: 1

Explanation

Creating a dedicated Customer dimension can reduce repeated customer information across transactional tables. Instead of storing customer attributes such as name, region, and segment repeatedly in every fact table, the Customer dimension can contain one row per customer and relate to the relevant fact tables through a customer key. This approach supports a cleaner star schema and can improve model maintainability. Duplicating tables or creating unrelated structures increases complexity. Therefore, a dedicated Customer dimension is a suitable approach for reducing unnecessary repeated descriptive data.

Question 64

Which DAX function is commonly used to extract the year portion from a date value?

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

Correct Answer: 3

Explanation

The YEAR function extracts the year component from a date value. For example, YEAR(Sales[OrderDate]) can return 2026 when the date belongs to that year. This function is useful when creating calculated columns or supporting time-based analysis. MONTH extracts the month number, DAY returns the day component, and DATE creates a date from individual date components. Therefore, when the requirement is to obtain the year from an existing date value, YEAR is the appropriate DAX function.

Question 65

Which Power BI visual is most appropriate for showing the proportion of total sales represented by several categories?

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

Correct Answer: 1

Explanation

A Donut chart can show how individual categories contribute to a whole by representing each category as a segment of a circular visual. It is useful when the number of categories is relatively small and the main goal is to communicate proportions. A line chart focuses on trends, a scatter chart shows relationships between numerical variables, and a card displays an individual value. Although other visuals can also show proportions, a donut chart directly communicates part-to-whole relationships. Therefore, it is an appropriate choice for displaying category contributions to total sales.

Question 66

Which Power Query operation can be used to keep only rows that meet a specified condition, such as SalesAmount greater than 10,000?

1. Filter Rows
2. Pivot Column
3. Transpose
4. Merge Queries

Correct Answer: 1

Explanation

Filter Rows allows Power Query to retain only records that satisfy a specified condition. For example, a SalesAmount column can be filtered to keep only rows where the value is greater than 10,000. This transformation is useful for removing irrelevant records before the data reaches the Power BI model. Pivot Column changes the structure of data, Transpose switches rows and columns, and Merge Queries combines tables. Therefore, Filter Rows is the appropriate Power Query operation when only records meeting a particular condition should remain.

Question 67

Which DAX function can return the month number from a date?

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

Correct Answer: 2

Explanation

The MONTH function returns the month number from a date value, with January represented by 1 and December by 12. It can be useful for creating month-number columns that support chronological sorting of month names. DATE creates a date from individual components, YEAR extracts the year, and FORMAT converts values into formatted text. For example, MONTH(Sales[OrderDate]) can return the month number associated with each order date. Therefore, MONTH is the correct DAX function for extracting a numeric month value.

Question 68

You need to make a report easier to navigate by adding buttons that move users between report pages. Which Power BI feature supports this requirement?

1. Navigation buttons
2. Data categories
3. Query folding
4. Calculated columns

Correct Answer: 1

Explanation

Navigation buttons allow report authors to create interactive controls that help users move between report pages or other report elements. They can be configured for actions such as navigating to a specific page, returning to a previous page, or accessing other report destinations. This can create a more application-like navigation experience. Data categories describe field semantics, query folding concerns Power Query processing, and calculated columns create stored values within the model. Therefore, navigation buttons are the appropriate feature for improving report navigation between pages.

Question 69

Which DAX function can remove filters from a column or table when calculating a measure?

1. REMOVEFILTERS
2. COUNT
3. SUM
4. AVERAGE

Correct Answer: 1

Explanation

REMOVEFILTERS is a DAX function used to clear filters from specified columns or tables when evaluating an expression. It is especially useful when calculating totals that should ignore certain filters. For example, a percentage-of-total measure can use REMOVEFILTERS to calculate the overall total while retaining other relevant context. COUNT counts values, SUM adds values, and AVERAGE calculates an average. Therefore, REMOVEFILTERS is appropriate when a measure needs to remove existing filter context from a specific part of the model.

Question 70

Which Power BI visual can be used to display multiple measures in a compact row-and-column format with categories?

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

Correct Answer: 1

Explanation

The Matrix visual presents data in rows and columns and can display multiple measures across different categories. It supports hierarchical structures, subtotals, and expandable levels, making it useful for detailed analytical reporting. For example, a matrix can show sales, profit, and quantity by region and product category. A Gauge focuses on progress toward a target, a Card highlights a single value, and a Funnel represents sequential stages. Therefore, a Matrix is the appropriate visual when multiple measures need to be presented in a structured tabular format.

Question 71

Which Power Query transformation can replace null values with a specified value in a column?

1. Fill Up
2. Replace Values
3. Split Column
4. Merge Queries

Correct Answer: 2

Explanation

Replace Values can be used in Power Query to substitute null or other specified values with a chosen replacement. For example, missing text values can be replaced with “Unknown,” or missing numeric values can be replaced with zero when that interpretation is appropriate. Fill Up instead propagates values from lower rows, Split Column separates one column into multiple columns, and Merge Queries joins related tables. Therefore, Replace Values is the appropriate transformation when the objective is to substitute missing or unwanted values during data preparation.

Question 72

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

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

Correct Answer: 3

Explanation

COUNTROWS returns the number of rows in a table. It is useful when a report needs to count records regardless of the data type contained in individual columns. For example, COUNTROWS(Sales) can return the number of rows in the Sales table within the current filter context. COUNT focuses on numeric values in a column, DISTINCTCOUNT counts unique values, and COUNTA counts nonblank values in a column. Therefore, COUNTROWS is the most direct DAX function when the requirement is to count rows in a table.

Question 73

A Power BI report contains a large number of visuals on one page, making it difficult for users to focus on specific information. Which design approach can help improve usability?

1. Add more visuals
2. Use clear layout and appropriate whitespace
3. Remove all labels
4. Use unrelated colors for every visual

Correct Answer: 2

Explanation

A clear layout with appropriate whitespace can improve report usability by separating related information and reducing visual clutter. Report authors should organize visuals logically, maintain consistent formatting, and prioritize important metrics so users can quickly understand the page. Adding more visuals or removing useful labels can make interpretation more difficult. Using unrelated formatting throughout a report can also reduce consistency. Therefore, organizing the page with a clear structure and enough whitespace is a practical design approach for improving readability and user experience.

Question 74

Which DAX function is useful for creating a formatted text representation of a numeric or date value?

1. FORMAT
2. SUM
3. FILTER
4. MAX

Correct Answer: 1

Explanation

The FORMAT function converts a value into text using a specified formatting pattern. It can be used to display dates or numbers in a particular presentation format, such as a month name or currency-style text. However, because FORMAT returns text, it should be used carefully when the resulting value needs to participate in numerical calculations or sorting. SUM performs numeric aggregation, FILTER returns a filtered table, and MAX returns the largest value. Therefore, FORMAT is appropriate when the requirement is to create a formatted textual representation of a value.

Question 75

Which Power BI feature allows a user to select a value in one visual and have related visuals automatically respond to that selection?

1. Cross-filtering
2. Data category
3. Theme
4. Query parameter

Correct Answer: 1

Explanation

Cross-filtering allows selections in one visual to filter related data displayed in other visuals. For example, selecting a particular product category in a chart can cause a sales trend chart and summary cards to update according to that selection. This interactive behavior helps users explore relationships within the report without manually changing filters. Data categories define the semantic type of columns, themes control formatting, and query parameters influence data retrieval. Therefore, cross-filtering is the feature that enables visuals to respond dynamically to selections made in another visual.

Question 76

Which DAX function can return the smallest value from a column?

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

Correct Answer: 1

Explanation

The MIN function returns the smallest value from a specified column or expression. It can be used to identify the lowest sales amount, minimum quantity, earliest date, or another minimum value depending on the data type. MAX performs the opposite operation by returning the largest value. SUM adds numeric values, while COUNT counts values. Therefore, when a measure or calculation needs to identify the lowest value under the current filter context, MIN is the appropriate DAX function.

Question 77

Which Power Query feature can be used to change the order of columns in a table?

1. Reorder Columns
2. Group By
3. Remove Duplicates
4. Replace Values

Correct Answer: 1

Explanation

Reorder Columns allows Power Query users to change the sequence in which columns appear in the query output. Organizing columns logically can make datasets easier to inspect and maintain, especially when preparing data for a Power BI model. Group By summarizes records, Remove Duplicates eliminates repeated rows, and Replace Values changes specific values. Reordering columns does not change the underlying data values; it only changes their presentation order within the table. Therefore, Reorder Columns is the appropriate transformation for this requirement.

Question 78

Which Power BI modeling feature allows a table to contain only unique combinations of selected columns?

1. Calculated table
2. Theme
3. Bookmark
4. Tooltip

Correct Answer: 1

Explanation

A calculated table can be created with DAX and can contain a derived set of data based on existing tables or expressions. Functions such as DISTINCT can be used when the goal is to create a table containing unique values or combinations. Calculated tables can support specialized modeling scenarios, helper structures, or disconnected tables. Themes control formatting, bookmarks save report states, and tooltips display contextual information. Therefore, a calculated table is the modeling feature that can be used to create a separate table containing a derived set of unique data.

Question 79

Which visual is most appropriate for showing the stages of a process where values decrease from one stage to the next?

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

Correct Answer: 1

Explanation

A Funnel chart is designed to display sequential stages in a process and is particularly useful when the number of items decreases as they progress through those stages. Common examples include sales pipelines, recruitment processes, and website conversion stages. A Card shows a single metric, a Scatter chart examines relationships between numerical values, and a Line chart is generally used for trends over an ordered axis. Therefore, a Funnel chart is the most appropriate visual for representing a process where values typically decrease from one stage to another.

Question 80

Which Power BI feature allows you to create a report page specifically designed to display additional information when users hover over a visual?

1. Tooltip page
2. Data gateway
3. Relationship
4. Calculated column

Correct Answer: 1

Explanation

A Tooltip page is a dedicated report page that can display additional information when users hover over data points in supported visuals. It can contain multiple visuals, measures, and contextual information while remaining hidden from normal report navigation. Tooltip pages are useful for providing additional details without overcrowding the main report page. A data gateway supports connectivity to certain data sources, relationships connect tables, and calculated columns create row-level calculations. Therefore, a Tooltip page is the appropriate feature for providing rich contextual information on hover.