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

 

Question 181

Which Power BI feature allows a report author to define a relationship where one value in a dimension table can correspond to many records in a fact table?

1. One-to-many relationship
2. Many-to-many relationship
3. One-to-one relationship
4. Cross-report relationship

Correct Answer: 1

Explanation

A one-to-many relationship is commonly used in Power BI star-schema models. One record in a dimension table, such as a customer or product, can correspond to many records in a fact table, such as orders or sales. For example, one customer can have many sales transactions. This relationship allows filters from the dimension to propagate to the related fact table. A many-to-many relationship allows multiple matches on both sides, while one-to-one requires unique values on both sides. Therefore, a one-to-many relationship is appropriate for this modeling scenario.

Question 182

Which DAX function can concatenate text values from multiple rows into a single text string using a specified delimiter?

1. CONCATENATE
2. CONCATENATEX
3. FORMAT
4. COMBINEVALUES

Correct Answer: 2

Explanation

CONCATENATEX is an iterator function that evaluates an expression for each row of a table and combines the resulting text values into a single string. It can use a delimiter such as a comma or semicolon between values. This makes it useful for displaying multiple related items in one result, such as listing all products associated with a customer. CONCATENATE combines two text values, FORMAT converts values to formatted text, and COMBINEVALUES combines expressions using a delimiter. Therefore, CONCATENATEX is the appropriate function for combining text from multiple rows.

Question 183

Which Power Query transformation should be used to remove completely empty rows from a dataset?

1. Remove Errors
2. Remove Blank Rows
3. Filter Rows
4. Remove Duplicates

Correct Answer: 2

Explanation

Remove Blank Rows removes rows that contain no meaningful values across the relevant columns. This is useful when source files contain empty lines that were introduced through manual data entry, exported spreadsheets, or formatting. Removing these records helps keep the dataset clean and prevents unnecessary blank records from entering the semantic model. Remove Errors targets rows containing errors, Filter Rows applies specific conditions, and Remove Duplicates eliminates repeated records. Therefore, Remove Blank Rows is the appropriate Power Query transformation for eliminating completely blank records.

Question 184

Which Power BI feature allows users to navigate from a summary report page to a page containing details for a selected data point?

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

Correct Answer: 2

Explanation

Drillthrough allows users to navigate from a summary visual to a dedicated detail page that is filtered according to the selected data point. For example, a user can select a customer in a sales summary and open a drillthrough page containing detailed transactions for that customer. Drill-down moves between hierarchy levels within a visual, while tooltips display additional information during hovering. Bookmarks save specific report states. Therefore, Drillthrough is the correct feature when users need to navigate to a filtered detail page.

Question 185

Which DAX function returns the smallest value in a specified column within the current filter context?

1. MIN
2. MINX
3. MAX
4. FIRSTNONBLANK

Correct Answer: 1

Explanation

MIN returns the smallest numeric value from a specified column while respecting the current filter context. For example, MIN(Sales[SalesAmount]) can return the lowest sales amount among the records currently visible through active report filters. MINX is used when an expression must be evaluated for each row before determining the minimum. MAX returns the largest value, while FIRSTNONBLANK identifies the first nonblank result based on an expression. Therefore, MIN is the appropriate function for retrieving the lowest value from an existing numeric column.

Question 186

Which Power Query feature can be used to summarize rows by a category and calculate an aggregate such as total sales?

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

Correct Answer: 2

Explanation

Group By allows Power Query users to organize records according to one or more columns and calculate aggregations such as Sum, Count Rows, Average, Minimum, or Maximum. For example, sales records can be grouped by Region to calculate total sales for each region. Pivot Column changes values into separate columns, Split Column separates one column into multiple columns, and Fill Down propagates values into blank cells. Therefore, Group By is the appropriate transformation when the goal is to summarize records by a category.

Question 187

Which DAX function returns a value only when exactly one distinct value is present in the current filter context?

1. SELECTEDVALUE
2. DISTINCT
3. VALUES
4. HASONEVALUE

Correct Answer: 1

Explanation

SELECTEDVALUE returns the single value when the current filter context contains exactly one distinct value. If multiple values or no value are selected, it can return BLANK or a specified alternate result. This function is often used in dynamic report titles, labels, and measures that need to respond to a user’s selection. DISTINCT returns a table of unique values, VALUES returns distinct values within context, and HASONEVALUE checks whether exactly one value exists. Therefore, SELECTEDVALUE is the appropriate function for retrieving a single selected value.

Question 188

Which Power BI visual can display a process as a series of stages, showing how values decrease from one stage to the next?

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

Correct Answer: 1

Explanation

A Funnel chart displays values across sequential stages of a process and is commonly used to analyze progression or conversion. For example, a sales pipeline can show leads, qualified opportunities, proposals, and completed sales, allowing users to see how the number of records changes at each stage. A Matrix presents structured tabular information, a Card displays a single value, and a Scatter chart shows relationships between numerical measures. Therefore, a Funnel chart is the appropriate visual for displaying stage-based processes and their changing values.

Question 189

Which DAX function can return the number of rows in a table regardless of the data types contained in those rows?

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

Correct Answer: 3

Explanation

COUNTROWS returns the number of rows in a table or table expression. It does not depend on whether individual columns contain numbers, text, or other data types because it counts records rather than values within a specific column. For example, COUNTROWS(Sales) returns the number of rows in the Sales table under the current filter context. COUNT focuses on numeric values, COUNTA counts nonblank column values, and DISTINCTCOUNT counts unique values. Therefore, COUNTROWS is the appropriate function when the requirement is to count records.

Question 190

Which Power BI feature allows users to filter a report using a visual control containing selectable values?

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

Correct Answer: 1

Explanation

A slicer is an interactive visual control that allows users to filter report data by selecting values. For example, a user can select a particular year, region, product category, or customer from a slicer, and connected visuals can update according to that selection. Cards show individual values, Gauges display progress toward targets, and Shapes are primarily used for design or navigation. Therefore, a Slicer is the appropriate Power BI feature when users need a visible control for filtering report content.

Question 191

Which DAX function can return a date that is a specified number of months before or after another date?

1. EDATE
2. DATE
3. DATESBETWEEN
4. MONTH

Correct Answer: 1

Explanation

EDATE returns a date that occurs a specified number of months before or after a starting date. For example, EDATE(StartDate, 3) returns a date three months after the starting date, while a negative number can move the result backward. DATE creates a date from year, month, and day components. DATESBETWEEN returns a table of dates within a specified range, while MONTH extracts the month number. Therefore, EDATE is the appropriate DAX function when date calculations need to shift a date by a number of months.

Question 192

Which Power Query feature allows you to select a range of rows based on their position in the table?

1. Keep Top Rows
2. Keep Range of Rows
3. Remove Bottom Rows
4. Filter Rows

Correct Answer: 2

Explanation

Keep Range of Rows allows users to retain a specific range of records based on their position in the query. This can be useful when a dataset needs to be sampled or when only a particular section of rows should remain. Keep Top Rows retains records from the beginning, Remove Bottom Rows removes records from the end, and Filter Rows selects records based on column values or conditions. Therefore, Keep Range of Rows is the appropriate Power Query operation when a specific positional range of rows must be retained.

Question 193

Which DAX function can return the weekday number for a given date?

1. WEEKDAY
2. WEEKNUM
3. DAY
4. DATE

Correct Answer: 1

Explanation

WEEKDAY returns a number representing the day of the week for a specified date. The return numbering can be configured through the function’s optional parameters, allowing different days to be treated as the first day of the week. This function is useful for weekday-based analysis, such as distinguishing business days from weekends. WEEKNUM returns the week number within a year, DAY extracts the day of the month, and DATE creates a date. Therefore, WEEKDAY is the appropriate function for identifying the weekday number.

Question 194

Which Power BI capability can highlight values in a table or matrix according to rules or data ranges?

1. Conditional formatting
2. Drillthrough
3. Bookmarks
4. Data categories

Correct Answer: 1

Explanation

Conditional formatting changes the appearance of values based on defined rules, thresholds, or data values. In tables and matrices, it can be used to apply background colors, font colors, data bars, icons, or other visual indicators. For example, low profit values can be highlighted differently from high profit values. Drillthrough provides navigation to detailed pages, bookmarks save report states, and data categories provide semantic classifications for fields. Therefore, Conditional formatting is the appropriate capability for visually highlighting values according to conditions.

Question 195

Which DAX function returns the number of distinct values in a column, excluding duplicate values?

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

Correct Answer: 1

Explanation

DISTINCTCOUNT counts unique values in a specified column, so duplicate values are counted only once. For example, if a customer ID appears in many sales transactions, DISTINCTCOUNT(Sales[CustomerID]) can determine how many unique customers are represented. COUNT counts numeric values, COUNTA counts nonblank values regardless of data type, and COUNTROWS counts records in a table. Therefore, DISTINCTCOUNT is the correct DAX function when the analysis requires the number of unique values rather than the total number of records.

Question 196

Which Power Query operation converts columns containing attribute names into rows containing attribute-value pairs?

1. Pivot Column
2. Merge Queries
3. Unpivot Columns
4. Append Queries

Correct Answer: 3

Explanation

Unpivot Columns converts selected columns into attribute-value pairs, transforming a wide table into a more normalized structure. For example, columns named January, February, and March can be converted into an Attribute column containing month names and a Value column containing the corresponding amounts. Pivot Column performs a different transformation by converting values into separate columns. Merge Queries joins tables, while Append Queries combines rows from multiple tables. Therefore, Unpivot Columns is the appropriate transformation when column headers need to become row values.

Question 197

Which DAX function can return a value from a related table when there is a valid relationship and the current context contains a corresponding row?

1. RELATED
2. RELATEDTABLE
3. LOOKUPVALUE
4. VALUES

Correct Answer: 1

Explanation

RELATED retrieves a single value from a related table when a valid relationship exists and the current row context identifies the corresponding related record. It is commonly used in calculated columns to bring attributes from a dimension table into a fact table. RELATEDTABLE returns a table of related rows rather than a single value. LOOKUPVALUE can retrieve a value based on search conditions, while VALUES returns a table of unique values. Therefore, RELATED is the appropriate function when retrieving a corresponding single value through an established relationship.

Question 198

Which Power BI feature allows a report author to create a dedicated page that appears as a custom tooltip when users hover over a visual?

1. Tooltip page
2. Drillthrough page
3. Bookmark
4. Dashboard tile

Correct Answer: 1

Explanation

A Tooltip page is a dedicated report page designed to appear when users hover over a visual element. It can contain additional charts, measures, and contextual information related to the selected data point. This allows reports to provide deeper details without requiring users to navigate away from the current page. A Drillthrough page requires navigation to a separate detail page, bookmarks save report states, and dashboard tiles display report content on dashboards. Therefore, Tooltip page is the appropriate feature for customized hover-based details.

Question 199

Which DAX function can return the number of days between two dates while allowing the interval to be specified?

1. DATEDIFF
2. DAYS
3. DATE
4. DAY

Correct Answer: 1

Explanation

DATEDIFF calculates the difference between two dates according to a specified interval. The interval can be DAY, MONTH, QUARTER, YEAR, or another supported unit. For example, DATEDIFF(StartDate, EndDate, DAY) returns the number of day boundaries between the two dates. DATE creates a date, DAY extracts the day component from a date, and DAYS is not the standard DAX function used for this purpose. Therefore, DATEDIFF is the appropriate function for calculating date differences with a selectable interval.

Question 200

Which Power BI feature can help identify which visual on a report page is consuming excessive processing time?

1. Performance Analyzer
2. Data category
3. Bookmarks
4. Field parameter

Correct Answer: 1

Explanation

Performance Analyzer helps report developers investigate the performance of visuals on a Power BI report page. It records the time required for visual queries and other processing activities, allowing developers to identify visuals that may be contributing to slow report performance. This information can support optimization efforts, such as simplifying calculations or reducing unnecessary visual complexity. Data categories describe field meaning, bookmarks save report states, and field parameters provide dynamic field selection. Therefore, Performance Analyzer is the appropriate tool for investigating visual performance.