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

 

Question 81

Which Power BI feature is used to create relationships between tables in a semantic model?

1. Model view
2. Report view
3. Power Query Editor
4. Performance Analyzer

Correct Answer: 1

Explanation

Model view provides tools for viewing and managing relationships between tables in a Power BI semantic model. It allows developers to inspect tables, columns, relationship lines, cardinality, and filter direction. Proper relationships are essential for ensuring that filters and calculations propagate correctly across the model. Report view is primarily used to create visualizations, Power Query Editor handles data preparation, and Performance Analyzer investigates report performance. Therefore, Model view is the appropriate Power BI interface for creating and managing relationships between tables.

Question 82

Which DAX function returns the current year as a number?

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

Correct Answer: 2

Explanation

The YEAR function extracts the year component from a date value and returns it as a number. For example, YEAR(DATE(2026, 8, 15)) returns 2026. This function can be useful when creating year-based calculations or calculated columns for reporting. MONTH returns the month number, TODAY returns the current date, and DATE constructs a date from specified components. Therefore, when a calculation needs to retrieve the year portion of a date, YEAR is the correct DAX function.

Question 83

Which Power Query feature allows you to remove columns that are not required for the Power BI model?

1. Remove Columns
2. Group By
3. Merge Queries
4. Fill Down

Correct Answer: 1

Explanation

Remove Columns allows unnecessary fields to be eliminated during the Power Query data preparation process. Removing columns that are not needed can simplify the dataset, reduce model size, and make the resulting data easier to work with. It is generally useful to remove irrelevant fields before loading data into the semantic model. Group By creates aggregations, Merge Queries combines related tables, and Fill Down propagates values into blank cells. Therefore, Remove Columns is the appropriate transformation when unnecessary fields should be excluded from the model.

Question 84

Which DAX function can concatenate text values from multiple expressions into a single text result?

1. CONCATENATE
2. SUM
3. COUNTROWS
4. FILTER

Correct Answer: 1

Explanation

CONCATENATE combines two text expressions into a single text result. It can be used to construct values such as a full name from first and last name fields. For example, CONCATENATE(Customer[FirstName], Customer[LastName]) joins the two text values. SUM performs numerical aggregation, COUNTROWS counts rows, and FILTER returns a filtered table. Although other DAX functions can also combine multiple text values in more advanced scenarios, CONCATENATE is the direct function for joining two text expressions into one result.

Question 85

Which Power BI view is primarily used to design report pages and add charts, slicers, and other visuals?

1. Model view
2. Report view
3. Data view
4. Power Query Editor

Correct Answer: 2

Explanation

Report view is the primary workspace in Power BI Desktop for designing report pages and adding visualizations. Users can place charts, tables, cards, slicers, buttons, and other elements onto the report canvas. Model view focuses on relationships and data structure, while Data view allows users to inspect loaded table data. Power Query Editor is used before loading data to perform transformations and cleaning. Therefore, Report view is the appropriate workspace for creating and arranging report visuals and interactive report pages.

Question 86

Which Power Query transformation can convert text values to uppercase letters?

1. Format > UPPERCASE
2. Group By
3. Merge Queries
4. Unpivot Columns

Correct Answer: 1

Explanation

Power Query provides text formatting transformations that can convert text values to uppercase. This can help standardize data when the same information appears with inconsistent capitalization. For example, values such as “north,” “North,” and “NORTH” can be standardized to a consistent uppercase representation. Group By summarizes records, Merge Queries combines tables, and Unpivot Columns restructures data. Therefore, using the uppercase text-formatting transformation is appropriate when the goal is to standardize text capitalization during data preparation.

Question 87

Which DAX function can return the first nonblank value from a list of expressions?

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

Correct Answer: 1

Explanation

COALESCE returns the first expression that does not evaluate to BLANK. It is useful when a calculation may produce blank results and an alternative value should be displayed instead. For example, COALESCE([Total Sales], 0) can return zero when Total Sales is blank. SUM adds values, COUNT counts values, and MAX returns the highest value. Therefore, COALESCE is an appropriate DAX function when a calculation needs to provide a fallback result whenever the primary expression evaluates to blank.

Question 88

Which Power BI feature can be used to create a visual that automatically displays only the top 10 products by sales?

1. Top N filter
2. Data category
3. Bookmark
4. Relationship

Correct Answer: 1

Explanation

A Top N filter can restrict a visual to a specified number of highest or lowest items according to a selected measure. For example, a Top N filter can be configured to display only the 10 products with the greatest sales. This is useful when a dataset contains many categories and the report should focus on the most significant results. Data categories define field semantics, bookmarks save report states, and relationships connect tables. Therefore, Top N filtering is the appropriate feature for displaying the top products based on sales.

Question 89

Which DAX function can return the number of unique customers in a CustomerID column?

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

Correct Answer: 2

Explanation

DISTINCTCOUNT counts the number of unique values in a specified column. When CustomerID contains repeated values because customers can make multiple purchases, DISTINCTCOUNT can determine how many different customers are represented. COUNT counts numeric values, COUNTA counts nonblank values, and COUNTROWS counts rows in a table. Therefore, DISTINCTCOUNT is the appropriate function for calculating the number of unique customers. The result also responds to the current filter context when used as a measure, allowing analysis by region, product, date, or other dimensions.

Question 90

Which Power BI visual is best suited for showing a geographical distribution of sales by country?

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

Correct Answer: 1

Explanation

A Map visual is designed to represent data based on geographic locations. When country information is correctly categorized and associated with a sales measure, the map can display the geographic distribution of sales. This makes it useful for identifying regional patterns and comparing values across countries or locations. A Card displays an individual value, a Funnel shows sequential stages, and a Gauge compares a measure with a target. Therefore, a Map is the appropriate visual for analyzing sales based on geographic distribution.

Question 91

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

1. Sort
2. Merge
3. Pivot
4. Append

Correct Answer: 1

Explanation

The Sort operation in Power Query allows rows to be ordered according to one or more selected columns. For example, a sales table can be sorted by SalesAmount from highest to lowest or by OrderDate from oldest to newest. Sorting can help during data inspection and certain transformation workflows. Merge joins tables, Pivot changes the structure of values into columns, and Append combines rows from multiple queries. Therefore, Sort is the appropriate Power Query operation when records need to be arranged according to selected field values.

Question 92

Which DAX function can evaluate an expression for each row of a table and return the highest resulting value?

1. MAXX
2. SUMX
3. COUNTX
4. AVERAGEX

Correct Answer: 1

Explanation

MAXX is an iterator function that evaluates an expression for each row of a table and returns the highest result. It is 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 transaction value. SUMX adds results across rows, COUNTX counts results, and AVERAGEX calculates their average. Therefore, MAXX is appropriate when the requirement involves finding the maximum value of a calculated row expression.

Question 93

You need to ensure that a report visual displays values from lowest to highest. Which action should you use?

1. Sort ascending
2. Sort descending
3. Apply Top N only
4. Remove the visual

Correct Answer: 1

Explanation

Sort ascending arranges values from the smallest or earliest value to the largest or latest value, depending on the data type. For example, numerical sales values can be ordered from the lowest amount to the highest amount. Sort descending would produce the opposite order. A Top N filter limits the number of displayed categories rather than simply controlling their order. Removing the visual does not address sorting. Therefore, Sort ascending is the appropriate action when a visual needs to display values from lowest to highest.

Question 94

Which Power BI feature allows you to define a reusable set of fields that can be used to control what appears in a visual?

1. Field parameter
2. Bookmark
3. Theme
4. Tooltip

Correct Answer: 1

Explanation

Field parameters allow report authors to create a reusable selection of fields or measures that can be dynamically switched in visuals. This gives report users greater flexibility without requiring separate visuals for every possible analytical perspective. For example, a chart can allow users to switch between Revenue, Profit, and Quantity. Bookmarks save report states, themes control formatting, and tooltips provide additional contextual information. Therefore, a field parameter is the appropriate feature for dynamically controlling which fields or measures appear in a visual.

Question 95

Which DAX function returns the last date in a column within the current filter context?

1. LASTDATE
2. FIRSTDATE
3. DATE
4. TODAY

Correct Answer: 1

Explanation

LASTDATE returns the last date in a column within the current filter context. It can be useful in time-based calculations where the final date of the currently selected period is required. FIRSTDATE performs the opposite operation by returning the first date, DATE constructs a date from components, and TODAY returns the current date. LASTDATE is especially useful when working with a properly structured date table and time-based analysis. Therefore, LASTDATE is the appropriate DAX function when the requirement is to retrieve the final date in the current context.

Question 96

Which Power Query transformation is used to turn rows into columns based on the values of a selected field?

1. Pivot Column
2. Split Column
3. Remove Rows
4. Fill Down

Correct Answer: 1

Explanation

Pivot Column transforms unique values from a selected column into separate columns. It is useful when data is stored in a long format but needs to be reorganized into a wider structure. For example, a Category column containing values such as Sales and Cost can be pivoted so that those values become separate columns. Split Column separates one column into multiple columns, Remove Rows eliminates records, and Fill Down copies values into blank cells. Therefore, Pivot Column is the appropriate transformation for converting row values into columns.

Question 97

Which Power BI feature can display a warning or notification when a data value reaches a defined threshold in a dashboard tile?

1. Data alert
2. Bookmark
3. Theme
4. Tooltip

Correct Answer: 1

Explanation

Data alerts can notify users when a dashboard tile value reaches a specified threshold. For example, an alert can be configured to notify a user when a sales metric falls below a target or exceeds a defined value. This can help users monitor important metrics without continuously checking the report. Bookmarks save report states, themes control formatting, and tooltips provide contextual information when hovering over visuals. Therefore, a data alert is the appropriate Power BI feature for threshold-based notifications associated with supported dashboard tiles.

Question 98

Which DAX function is commonly used to return a value from a related table when a relationship exists between the tables?

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

Correct Answer: 1

Explanation

RELATED retrieves a value from another table that is connected through an existing relationship. It is commonly used in calculated columns when information from a related dimension table needs to be brought into the current table. For example, a Sales table can use RELATED to retrieve a product category from the related Product table. SUM performs aggregation, FILTER returns a filtered table, and FORMAT converts values to formatted text. Therefore, RELATED is the appropriate DAX function when retrieving a corresponding value from a related table.

Question 99

Which Power BI feature allows users to focus on a specific visual and temporarily enlarge it for closer analysis?

1. Spotlight
2. Drillthrough
3. Row-level security
4. Data category

Correct Answer: 1

Explanation

Spotlight can be used to emphasize a selected visual while temporarily reducing the prominence of other visuals on the report page. This can help users focus on a particular chart or analytical element when examining report information. Drillthrough moves users to another detail page, row-level security restricts access to data, and data categories define the semantic type of fields. Therefore, Spotlight is the appropriate feature when the objective is to visually emphasize one report visual for closer examination.

Question 100

Which DAX function can return the first date in a date column within the current filter context?

1. LASTDATE
2. FIRSTDATE
3. TODAY
4. MONTH

Correct Answer: 2

Explanation

FIRSTDATE returns the first date in a date column within the current filter context. It can be useful for time-based calculations that need to identify the beginning of a selected period. For example, it can help determine the starting date of a month, quarter, or other filtered period. LASTDATE returns the final date, TODAY returns the current date, and MONTH extracts the month number from a date. Therefore, FIRSTDATE is the appropriate DAX function when the calculation requires the earliest date in the current context.