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

 

Question 21

You have a sales table containing Revenue and Cost columns. Which DAX expression should you use to calculate profit for each row?

1. Profit = Sales[Revenue] – Sales[Cost]
2. Profit = SUM(Sales[Revenue]) – Sales[Cost]
3. Profit = COUNT(Sales[Revenue]) – COUNT(Sales[Cost])
4. Profit = AVERAGE(Sales[Revenue]) – AVERAGE(Sales[Cost])

Correct Answer: 1

Explanation

A calculated column can calculate profit for each individual row by subtracting Cost from Revenue. The expression Sales[Revenue] – Sales[Cost] evaluates the two values within the current row and returns the resulting profit. This approach is appropriate when the requirement is to store a profit value for every transaction. SUM and AVERAGE are aggregation functions generally used in measures, while COUNT counts values rather than calculating their difference. Therefore, subtracting the Cost column from the Revenue column is the appropriate row-level calculation.

Question 22

Which Power BI feature allows a report author to control how a column is categorized, such as identifying a column as a city or web URL?

1. Conditional formatting
2. Data category
3. Drillthrough
4. Field parameters

Correct Answer: 2

Explanation

Data categories provide semantic information about the type of data contained in a column. For example, a column can be categorized as City, State, Country, Latitude, Longitude, or Web URL. These categories help Power BI interpret and display data appropriately in certain visuals and features. Conditional formatting controls visual appearance, drillthrough provides navigation to detailed report pages, and field parameters allow users to dynamically change fields used in visuals. Therefore, configuring a data category is the correct approach when you need to identify the meaning or type of geographic or URL data.

Question 23

A Power BI model contains a Customer table and an Orders table. You need to ensure that every customer can filter multiple related orders. Which relationship direction is normally appropriate?

1. Both directions in all cases
2. No filter direction
3. Single direction from Customer to Orders
4. Single direction from Orders to Customer

Correct Answer: 3

Explanation

In a typical star-schema model, the Customer table is a dimension and the Orders table is a fact table. A single-direction relationship from Customer to Orders allows selections made on customer attributes to filter the corresponding order records. This structure keeps filter propagation predictable and helps avoid unnecessary ambiguity in the model. Bidirectional filtering can be useful in specific scenarios but should not automatically be used everywhere. Therefore, a single-direction relationship from the Customer dimension to the Orders fact table is normally appropriate.

Question 24

You want report users to switch a visual between Revenue, Profit, and Quantity without creating separate visuals. Which Power BI feature can support this requirement?

1. Field parameters
2. Data categories
3. Query folding
4. Calculated columns

Correct Answer: 1

Explanation

Field parameters allow report users to dynamically change the fields or measures displayed in a visual. For example, a parameter can contain Revenue, Profit, and Quantity measures, allowing users to select which metric should appear in a chart. This can provide a flexible report experience without requiring multiple copies of the same visual. Data categories describe the meaning of fields, query folding concerns Power Query processing, and calculated columns create values during data refresh. Therefore, field parameters are well suited for dynamically switching measures in a visual.

Question 25

Which DAX function is commonly used to modify filter context within a calculation?

1. SUM
2. CALCULATE
3. COUNT
4. ROUND

Correct Answer: 2

Explanation

CALCULATE is one of the most important DAX functions for modifying filter context when evaluating an expression. It can add, remove, or modify filters and is frequently used to create measures for comparisons, conditional calculations, and time-based analysis. For example, a measure can use CALCULATE to calculate sales only for a particular product category. SUM performs aggregation, COUNT counts values, and ROUND changes numeric precision. Therefore, CALCULATE is the appropriate function when a DAX expression needs to evaluate an expression under a modified filter context.

Question 26

A report author wants to display detailed information when a user hovers over a data point without changing the main visual. Which feature should be used?

1. Bookmarks
2. Slicers
3. Tooltips
4. Drill-down

Correct Answer: 3

Explanation

Tooltips provide additional information when users hover over data points or other report elements. A report author can configure a tooltip page containing extra measures, charts, or contextual details that appear when the user points to a visual element. This allows additional information to be presented without taking up permanent space on the report canvas. Bookmarks save report states, slicers provide filtering controls, and drill-down moves between hierarchy levels. Therefore, a tooltip is the appropriate feature for displaying contextual information on hover.

Question 27

Which modeling approach is generally recommended for a Power BI model containing transactional sales data and descriptive product information?

1. Star schema
2. Single flat table only
3. Circular schema
4. Random relationship structure

Correct Answer: 1

Explanation

A star schema separates measurable transactional information into fact tables and descriptive information into dimension tables. For example, a Sales fact table can contain transaction amounts and quantities, while Product, Customer, and Date tables provide descriptive attributes. This structure generally improves model organization, simplifies relationships, and supports efficient analysis. A single flat table may work for simple datasets but can create unnecessary duplication. Circular and random relationship structures can introduce ambiguity and make models harder to maintain. Therefore, a star schema is generally recommended for analytical Power BI models.

Question 28

Which DAX function can return the value of an expression when a condition is TRUE and another value when it is FALSE?

1. IF
2. SUMX
3. DISTINCT
4. FILTER

Correct Answer: 1

Explanation

The IF function evaluates a logical condition and returns one result when the condition is TRUE and another result when it is FALSE. For example, IF([Total Sales] > 100000, “High”, “Low”) can classify sales according to a threshold. SUMX performs an iterator-based aggregation, DISTINCT returns unique values, and FILTER returns a filtered table. Because the requirement is to produce different results depending on whether a condition is met, IF is the appropriate DAX function.

Question 29

You have a column containing product names and another containing sales values. Which visual is useful for comparing sales across many product categories while allowing users to see relative size?

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

Correct Answer: 1

Explanation

A treemap displays hierarchical or categorical data using differently sized rectangles. The size of each rectangle can represent a measure such as sales, allowing users to compare the relative contribution of numerous categories in a compact visual. It can be especially useful when there are many categories and limited report space. A Card is designed for individual values, a Gauge focuses on progress toward a target, and a Funnel is commonly used for sequential stages. Therefore, a treemap can effectively show relative sales size across numerous product categories.

Question 30

Which Power Query feature allows you to combine rows from two tables that have compatible columns?

1. Merge Queries
2. Append Queries
3. Group By
4. Pivot Column

Correct Answer: 2

Explanation

Append Queries combines rows from two or more tables into a single table. It is useful when datasets have similar structures, such as monthly sales tables containing the same columns. Power Query places the records from one table below the records from another table. Merge Queries instead joins tables based on matching columns and typically adds columns from another query. Group By creates aggregations, while Pivot Column restructures data. Therefore, Append Queries is the correct choice when the objective is to combine compatible rows into one dataset.

Question 31

A measure should calculate total sales only for the year 2026. Which DAX function can be used to apply the year filter within the measure?

1. FORMAT
2. CONCATENATE
3. CALCULATE
4. DISTINCTCOUNT

Correct Answer: 3

Explanation

CALCULATE can modify the filter context of a DAX expression by applying additional conditions. A measure can use CALCULATE with a filter on the year field so that sales are evaluated only for 2026. This technique is widely used when creating measures that require specific filtering logic. FORMAT changes values into formatted text, CONCATENATE combines text values, and DISTINCTCOUNT counts unique values. Therefore, CALCULATE is the appropriate function for applying a year-specific filter inside a measure.

Question 32

Which Power BI visual is designed to compare actual performance against a target value using a single progress-style indicator?

1. Gauge
2. Matrix
3. Scatter chart
4. Decomposition tree

Correct Answer: 1

Explanation

A Gauge visual is designed to show a single measure in relation to a target or goal. It can communicate whether a value is approaching, meeting, or moving away from a defined target. For example, monthly revenue can be displayed against a sales target using a gauge. A Matrix presents information in rows and columns, a Scatter chart examines relationships between numerical values, and a Decomposition Tree helps analyze a measure across dimensions. Therefore, the Gauge visual is appropriate for displaying progress toward a single target.

Question 33

Which Power Query transformation can be used to replace a specific incorrect value throughout a column?

1. Transpose
2. Replace Values
3. Unpivot Columns
4. Group By

Correct Answer: 2

Explanation

Replace Values in Power Query allows specific values in a column to be changed to another value. For example, if a region column contains an incorrect spelling such as “Calfornia,” it can be replaced with “California.” The transformation is recorded as a step and can be reapplied when the query is refreshed. Transpose switches rows and columns, Unpivot converts columns into attribute-value rows, and Group By performs aggregations. Therefore, Replace Values is the appropriate transformation for correcting repeated incorrect values in a column.

Question 34

A report needs a visual that shows the relationship between advertising spending and sales revenue for individual products. Which visual is most suitable?

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

Correct Answer: 3

Explanation

A Scatter chart is useful for analyzing relationships between two numerical variables. In this scenario, advertising spending can be placed on one axis and sales revenue on the other, with individual products represented as data points. This allows users to identify patterns, clusters, and potential outliers between the two measures. Pie charts focus on proportions, cards display individual values, and funnel charts represent sequential stages. Therefore, a Scatter chart is the most appropriate visual for examining the relationship between advertising spending and sales revenue.

Question 35

Which Power BI feature allows a user to select one or more values from a list and use those selections to filter report visuals?

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

Correct Answer: 1

Explanation

A Slicer is an interactive visual that provides users with a list, dropdown, date selector, or other selection interface for filtering report data. For example, a Region slicer can allow users to select North, South, East, or West and update connected visuals accordingly. Themes control report-wide visual formatting, bookmarks save particular report states, and tooltips display additional information when users hover over visuals. Therefore, a slicer is the appropriate feature when users need to select filter values interactively.

Question 36

You need to create a calculation that evaluates an expression for every row of a table and then adds the resulting values together. Which DAX function is appropriate?

1. SUMX
2. COUNT
3. MAX
4. DISTINCTCOUNT

Correct Answer: 1

Explanation

SUMX is an iterator function that evaluates an expression for each row of a specified table and then sums the resulting values. This is useful when the calculation cannot simply sum an existing column. For example, SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]) can calculate total sales by multiplying quantity and price for each transaction before adding the results. COUNT counts values, MAX returns the highest value, and DISTINCTCOUNT counts unique values. Therefore, SUMX is appropriate for row-by-row calculations followed by aggregation.

Question 37

Which Power BI visualization is most appropriate for displaying values across two categorical dimensions in a row-and-column layout?

1. Card
2. Matrix
3. Gauge
4. Donut chart

Correct Answer: 2

Explanation

A Matrix visual displays data in a flexible row-and-column structure and can include multiple levels of grouping. It is useful when users need to compare measures across two or more categorical dimensions, such as sales by region and product category. Matrix visuals also support hierarchical expansion and subtotals. Cards are designed for single metrics, gauges show progress toward targets, and donut charts show proportions. Therefore, a Matrix is the appropriate visualization when the report requires a structured cross-tabular presentation of multiple dimensions.

Question 38

Which Power BI feature can help identify slow-performing report visuals and provide information about their query duration?

1. Performance Analyzer
2. Bookmarks
3. Data categories
4. Sensitivity labels

Correct Answer: 1

Explanation

Performance Analyzer is a Power BI Desktop feature used to examine report performance. It can record the time taken by visuals to load and provides information about the operations contributing to visual rendering. This helps report developers identify visuals or queries that may require optimization. Bookmarks manage saved report states, data categories describe column types, and sensitivity labels help classify data. Therefore, Performance Analyzer is the appropriate feature for investigating visual performance and understanding which elements may be contributing to slower report response times.

Question 39

A dataset contains blank values in a numeric column, and you need to replace them with zero during data preparation. Which Power Query approach can accomplish this?

1. Replace Values
2. Merge Queries
3. Split Column
4. Transpose

Correct Answer: 1

Explanation

Replace Values can be used in Power Query to replace null or specified values with another value such as zero. This transformation can be useful when blank numeric values need to be represented as zero for subsequent calculations or reporting. The exact replacement method depends on how the blank values are represented in the source data. Merge Queries combines tables, Split Column separates values into multiple columns, and Transpose switches rows and columns. Therefore, Replace Values is an appropriate Power Query feature for replacing blank values during data preparation.

Question 40

Which Power BI feature allows a report page to be hidden from normal navigation while still remaining available for specific report functionality?

1. Data refresh
2. Query parameters
3. Hidden page
4. Data gateway

Correct Answer: 3

Explanation

A report page can be hidden so that it does not appear in the standard page navigation available to report users. Hidden pages can be useful for supporting specific report designs, such as tooltip pages or drillthrough-related experiences, where users access the content through an interaction rather than ordinary page navigation. Data refresh updates model data, query parameters control certain query inputs, and a data gateway supports connectivity to some data sources. Therefore, hiding a report page is the appropriate feature when the page should remain available without appearing in normal navigation.