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

 

Question 41

Which Power BI feature allows you to create a calculation that changes dynamically based on the filters and selections made by a report user?

1. Measure
2. Calculated column
3. Custom column
4. Static parameter

Correct Answer: 1

Explanation

A measure is a DAX calculation that is evaluated dynamically according to the current filter context. When users select slicers, filters, or data points in a report, the result of a measure can change accordingly. For example, a Total Sales measure can return different values when users select different regions or product categories. Calculated columns are evaluated during data refresh and store a value for each row. Custom columns are created during Power Query transformation. Therefore, a measure is the appropriate choice for dynamic calculations in reports.

Question 42

You need to combine two tables by matching CustomerID values and bring columns from one table into another. Which Power Query operation should you use?

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

Correct Answer: 2

Explanation

Merge Queries joins two Power Query tables based on matching values in selected columns. In this scenario, CustomerID can be selected as the matching key, allowing information from one table to be brought into the other. This is similar to performing a database join. Append Queries combines rows from tables with compatible structures rather than matching records. Unpivot restructures columns into rows, while Group By creates aggregations. Therefore, Merge Queries is the correct operation when the objective is to combine related information using a common key.

Question 43

Which DAX function can be used to return the largest value from a column?

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

Correct Answer: 3

Explanation

The MAX DAX function returns the largest value from a specified column or expression. It can be used to identify values such as the highest sales amount, maximum order quantity, or latest date depending on the data type. MIN returns the smallest value, AVERAGE calculates the arithmetic mean, and SUM adds numeric values. MAX is also commonly used inside measures when a report requires a maximum value according to the current filter context. Therefore, MAX is the appropriate function when the requirement is to identify the largest value.

Question 44

A Power BI report must display the total number of sales transactions. Which DAX function is appropriate when every transaction has a unique numeric transaction ID?

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

Correct Answer: 1

Explanation

COUNT returns the number of nonblank numeric values in a column. If every sales transaction has a numeric TransactionID and each transaction contains a value, COUNT can be used to determine the number of transactions. For example, COUNT(Sales[TransactionID]) counts the numeric transaction IDs available under the current filter context. SUM adds values, AVERAGE calculates an average, and MAX returns the highest value. Therefore, COUNT is appropriate when the goal is to count numeric transaction identifiers rather than add their values.

Question 45

Which Power Query feature allows you to remove rows that contain errors in one or more columns?

1. Remove Errors
2. Split Column
3. Merge Queries
4. Pivot Column

Correct Answer: 4

Explanation

Remove Errors is a Power Query transformation that removes rows containing errors from a selected column. It is useful during data-cleaning processes when invalid or problematic records should not be loaded into the Power BI model. Before removing errors, developers should understand why the errors occurred because simply deleting records can affect analysis. Split Column separates values, Merge Queries joins tables, and Pivot Column changes the structure of data. Therefore, when the requirement specifically involves eliminating rows containing errors, Remove Errors is the appropriate transformation.

Question 46

Which type of Power BI relationship is normally used when one customer can have many orders?

1. Many-to-many
2. One-to-one
3. One-to-many
4. Many-to-one from Orders to Customers

Correct Answer: 3

Explanation

A one-to-many relationship is appropriate when one record in a dimension table corresponds to multiple records in a fact table. In this example, one customer can have many orders, so the Customer table is on the “one” side and the Orders table is on the “many” side. This relationship allows customer attributes to filter related order records. Although the reverse perspective can be described as many-to-one from Orders to Customers, the standard relationship description from the dimension to fact structure is one-to-many. Therefore, one-to-many is the appropriate answer.

Question 47

You want to display a visual that ranks products from highest to lowest sales. Which visual can directly communicate this ordering effectively?

1. Bar chart
2. Card
3. Gauge
4. Map

Correct Answer: 1

Explanation

A bar chart is effective for comparing categorical values and displaying them in an ordered ranking. Products can be placed on the category axis and sales on the value axis, then sorted from highest to lowest. This makes it easy for users to identify the products with the greatest or lowest sales. A Card is intended for individual metrics, a Gauge compares a value with a target, and a Map is designed for geographic analysis. Therefore, a bar chart is an appropriate visualization for ranking products according to their sales values.

Question 48

Which Power BI capability allows users to analyze a selected data point by moving to a dedicated detail page?

1. Drillthrough
2. Conditional formatting
3. Data labeling
4. Theme

Correct Answer: 1

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, selecting a customer in a sales report can open a customer-details page showing orders, revenue, and other related information. This keeps the main report page focused while still providing access to deeper analysis. Conditional formatting changes visual appearance, data labeling displays information on visuals, and themes control report styling. Therefore, Drillthrough is the correct feature for navigating to contextual detail pages.

Question 49

Which Power Query transformation is useful for summarizing rows according to a selected column and calculating totals, averages, or counts?

1. Group By
2. Split Column
3. Fill Down
4. Replace Values

Correct Answer: 1

Explanation

Group By allows Power Query to organize rows according to one or more selected columns and perform aggregations such as Sum, Count Rows, Minimum, Maximum, or Average. For example, a sales dataset can be grouped by Region to calculate total sales for each region. Split Column separates one column into multiple columns, Fill Down copies values into empty cells, and Replace Values changes selected values. Therefore, Group By is the appropriate transformation when the requirement is to summarize records and calculate aggregate values during data preparation.

Question 50

Which DAX function returns the average of the numeric values in a column?

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

Correct Answer: 3

Explanation

The AVERAGE function calculates the arithmetic mean of the numeric values in a column. It is commonly used for metrics such as average sales, average order value, or average quantity. The result is affected by the current filter context when used within a measure. SUM adds numeric values, COUNT counts values, and DISTINCTCOUNT counts unique values. Therefore, when a report requires the mean of a numeric column, AVERAGE is the appropriate DAX function. It provides a straightforward way to summarize numerical performance across the selected dataset.

Question 51

You need to display geographic sales information by city on a map. Which field should be assigned an appropriate geographic data category?

1. Sales Amount
2. City
3. Product ID
4. Invoice Number

Correct Answer: 2

Explanation

The City field should be categorized appropriately as geographic data so Power BI can better interpret the location information when used with mapping visuals. Data categories help Power BI understand whether a column represents a city, state, country, postal code, latitude, or longitude. Sales Amount is a measure, while Product ID and Invoice Number are identifiers rather than geographic locations. Correct geographic categorization can improve location recognition and reduce ambiguity when creating map-based visualizations. Therefore, City is the appropriate field for geographic categorization in this scenario.

Question 52

Which Power BI visual is particularly useful for showing hierarchical categories as nested rectangles whose sizes represent values?

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

Correct Answer: 1

Explanation

A Treemap represents categories using nested rectangles, with the size of each rectangle corresponding to a selected measure. It can also display hierarchical relationships, making it useful for analyzing values across categories and subcategories. For example, sales can be shown by product category and then broken down into individual products. A line chart is more suitable for trends, a gauge shows progress toward a target, and a card displays a single value. Therefore, a Treemap is an appropriate visual for hierarchical categorical data represented through relative area.

Question 53

Which DAX function can return a filtered table that meets a specified condition?

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

Correct Answer: 1

Explanation

FILTER returns a table containing only the rows that satisfy a specified condition. It is frequently used within DAX expressions when calculations require more specific filtering logic than a simple column filter. For example, FILTER can identify sales records where SalesAmount exceeds a particular threshold. SUM aggregates numeric values, MAX returns the largest value, and FORMAT converts values into formatted text. FILTER can also be combined with CALCULATE or iterator functions to build more advanced measures. Therefore, FILTER is the appropriate function for creating a conditionally filtered table.

Question 54

You want to change the order in which months appear in a chart so that January comes before February rather than sorting alphabetically. What should you configure?

1. Sort by Column
2. Drillthrough
3. Query Folding
4. Row-level security

Correct Answer: 1

Explanation

Sort by Column allows one column to be sorted according to the values of another column. For example, a Month Name column can be sorted by a Month Number column containing values from 1 through 12. This ensures that January, February, March, and the remaining months appear in chronological order rather than alphabetical order. Drillthrough controls navigation, query folding concerns source-side query processing, and row-level security controls data access. Therefore, Sort by Column is the appropriate modeling feature for controlling the order of month names.

Question 55

Which Power BI feature can be used to apply consistent fonts, colors, and formatting across an entire report?

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

Correct Answer: 1

Explanation

A Power BI theme provides consistent formatting across report visuals. Themes can define elements such as colors, fonts, visual properties, and other formatting choices, helping maintain a consistent appearance across multiple report pages. Bookmarks save particular report states, tooltips provide additional contextual information, and slicers allow users to filter data interactively. Applying a theme is especially useful when reports need to follow organizational formatting standards or maintain a consistent visual design. Therefore, Theme is the appropriate feature for applying consistent report-wide formatting.

Question 56

Which DAX function can count nonblank values in a column, including text and numeric values?

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

Correct Answer: 2

Explanation

COUNTA counts the number of nonblank values in a column and can work with both text and numeric data. This differs from COUNT, which is primarily used to count numeric values. For example, COUNTA can count populated customer names even when the column contains text. SUM adds numeric values, while DISTINCTCOUNT counts unique values rather than all nonblank values. Therefore, when the requirement is to count populated entries regardless of whether they are text or numbers, COUNTA is the appropriate DAX function.

Question 57

A report contains many visuals, and you want one slicer selection to affect only selected visuals rather than every visual on the page. Which feature should you use?

1. Edit Interactions
2. Data category
3. Query parameter
4. Relationship detection

Correct Answer: 1

Explanation

Edit Interactions allows a report author to control how one visual affects other visuals on the same page. When configuring a slicer, the author can specify which visuals should respond to its selections and which should remain unchanged. This provides greater control over report behavior and can prevent unwanted filtering. Data categories describe the semantic meaning of columns, query parameters influence data retrieval, and relationship detection concerns model relationships. Therefore, Edit Interactions is the appropriate feature for controlling which visuals respond to a slicer.

Question 58

Which Power Query feature can automatically detect and convert a column’s data type based on the values it contains?

1. Automatic data type detection
2. Drillthrough
3. Row-level security
4. Bookmarks

Correct Answer: 1

Explanation

Power Query can automatically detect data types based on the values present in a dataset. For example, it may identify a column containing dates and assign a Date type or identify numeric values and assign a numeric type. Although automatic detection can be useful, developers should review the resulting data types to ensure they match business requirements. Drillthrough, row-level security, and bookmarks are Power BI report or security features rather than Power Query data-type operations. Therefore, automatic data type detection is the appropriate feature for this requirement.

Question 59

Which Power BI visual is designed to show how a value changes over time using connected data points?

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

Correct Answer: 1

Explanation

A line chart is designed to display trends by connecting data points along an axis, commonly a time axis. It is useful for analyzing changes in metrics such as revenue, sales volume, customer counts, or expenses over days, months, or years. Cards are intended for individual values, treemaps display categorical values through proportional rectangles, and donut charts emphasize proportions. Therefore, a line chart is the appropriate visual when the primary requirement is to understand how a measure changes over time.

Question 60

Which Power BI modeling feature allows you to define a reusable calculation once and use it in multiple report visuals?

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

Correct Answer: 1

Explanation

A measure is a reusable DAX calculation that can be placed in multiple visuals throughout a Power BI report. Because measures are evaluated dynamically according to filter context, the same calculation can provide appropriate results across different dimensions, slicers, and report pages. For example, a Total Revenue measure can be reused in cards, charts, tables, and matrices. Slicers provide filtering, bookmarks save report states, and tooltips display additional information. Therefore, creating a measure is the appropriate approach when a reusable calculation is needed across multiple report visuals.