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

 

Question 101

Which Power BI feature allows you to create a hierarchy containing Year, Quarter, Month, and Day fields for time-based analysis?

1. Date hierarchy
2. Bookmark
3. Field parameter
4. Data category

Correct Answer: 1

Explanation

A date hierarchy organizes date information into multiple levels such as Year, Quarter, Month, and Day. This structure allows users to analyze information at different levels of detail and use drill-down capabilities within visuals. Power BI can automatically create date hierarchies for date fields when appropriate settings are enabled. Bookmarks save report states, field parameters dynamically change fields or measures, and data categories define semantic information about columns. Therefore, a date hierarchy is the appropriate feature for organizing dates into multiple analytical levels.

Question 102

Which Power Query transformation should be used to remove rows that contain duplicate records?

1. Remove Duplicates
2. Merge Queries
3. Split Column
4. Fill Down

Correct Answer: 1

Explanation

Remove Duplicates is a Power Query transformation designed to eliminate repeated records. After selecting one or more columns, Power Query can identify duplicate combinations and retain only unique rows. This is useful when source systems contain repeated records or when a unique list is required for modeling. Merge Queries combines information from separate tables, Split Column separates values, and Fill Down propagates values into blank cells. Therefore, Remove Duplicates is the appropriate transformation when duplicate records need to be removed during data preparation.

Question 103

Which DAX function can return a value from the previous period when working with a properly configured date table?

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

Correct Answer: 2

Explanation

PREVIOUSMONTH returns a table containing the dates from the previous month based on the current filter context. It is commonly used in time-intelligence calculations to compare current-period results with the previous month. For example, a measure can use CALCULATE together with PREVIOUSMONTH to calculate prior-month sales. DATE creates date values, MONTH extracts a month number, and YEAR extracts a year. Therefore, PREVIOUSMONTH is the appropriate DAX function when a calculation needs to reference dates from the preceding month.

Question 104

Which Power BI feature allows a user to select multiple values from a category and filter a report accordingly?

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

Correct Answer: 1

Explanation

A slicer provides an interactive way for report users to select one or more values and filter connected visuals. For example, a Product Category slicer can allow users to select several categories simultaneously and analyze their combined sales. Slicers can also support dropdowns, lists, date ranges, and other selection methods. Tooltips display additional information, bookmarks preserve report states, and themes control visual formatting. Therefore, a slicer is the appropriate feature when users need to interactively select multiple filter values within a report.

Question 105

Which DAX function can calculate the sum of an expression evaluated for each row in a table?

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

Correct Answer: 1

Explanation

SUMX evaluates an expression for each row of a specified table and then adds the resulting values. This makes it useful when the value being aggregated must first be calculated at the row level. For example, SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]) can calculate the total sales amount when no precomputed SalesAmount column exists. SUM directly adds values from a column, while COUNT counts values and MIN identifies the smallest value. Therefore, SUMX is the appropriate function for summing the results of a row-level expression.

Question 106

Which Power Query feature allows you to identify and remove completely blank rows from a dataset?

1. Remove Blank Rows
2. Merge Queries
3. Pivot Column
4. Split Column

Correct Answer: 1

Explanation

Remove Blank Rows can be used in Power Query to eliminate rows that do not contain meaningful data. Removing empty rows can improve data quality and prevent unnecessary records from entering the Power BI model. This is especially useful when source files contain accidental blank lines or empty records. Merge Queries combines related tables, Pivot Column changes the structure of the dataset, and Split Column separates values. Therefore, Remove Blank Rows is the appropriate transformation when completely empty records need to be excluded.

Question 107

Which Power BI feature is designed to restrict users to specific rows of data based on their identity or role?

1. Row-level security
2. Conditional formatting
3. Bookmarks
4. Data categories

Correct Answer: 1

Explanation

Row-level security, commonly called RLS, restricts which rows users can view based on roles and filtering rules. For example, regional managers can be configured to see only sales records associated with their assigned region. RLS is implemented through roles and DAX filter expressions, and users can be assigned to those roles after the model is published. Conditional formatting changes visual appearance, bookmarks save report states, and data categories define field semantics. Therefore, row-level security is the appropriate feature for restricting data at the row level.

Question 108

Which DAX function can return the current date and time?

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

Correct Answer: 2

Explanation

The NOW function returns the current date and time. It is useful when a calculation requires both the current calendar date and the current time component. TODAY returns only the current date, DATE constructs a date from specified year, month, and day values, and DAY extracts the day number from an existing date. Therefore, NOW is the correct DAX function when both date and time information are required. Its returned value depends on the evaluation environment and refresh or calculation behavior of the model.

Question 109

Which Power BI visual is generally suitable for comparing values across a small number of categories using horizontal bars?

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

Correct Answer: 1

Explanation

A bar chart is useful for comparing numerical values across categories, especially when category names are relatively long or when a horizontal layout improves readability. Each category is represented by a bar whose length corresponds to its value. Cards display individual metrics, gauges show progress toward targets, and donut charts emphasize part-to-whole relationships. Bar charts can also be sorted to make rankings easier to identify. Therefore, a bar chart is an appropriate visual for comparing values across categories in a clear and readable format.

Question 110

Which DAX function can return a table containing only unique values from a column?

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

Correct Answer: 1

Explanation

DISTINCT returns a table containing the unique values from a specified column or expression. It can be useful when creating calculated tables, filtering logic, or other DAX expressions that require a unique list. For example, DISTINCT(Customer[Region]) can return a table containing each region once. SUM performs numerical aggregation, AVERAGE calculates a mean, and COUNT counts values. Therefore, DISTINCT is the appropriate DAX function when the objective is to obtain unique values rather than all repeated records.

Question 111

Which Power Query feature allows you to select only specific columns and discard all other columns from a query?

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

Correct Answer: 1

Explanation

Choose Columns allows you to specify which fields should remain in a Power Query dataset while excluding all other columns. This is useful when a source contains many fields but the Power BI model requires only a smaller subset. Reducing unnecessary columns can simplify the query and potentially reduce the amount of data loaded into the model. Group By creates summaries, Merge Queries joins tables, and Fill Down propagates values. Therefore, Choose Columns is the appropriate Power Query feature for retaining only selected fields.

Question 112

Which DAX function can calculate the percentage change between a current value and a previous value when combined with appropriate measures?

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

Correct Answer: 1

Explanation

DIVIDE is commonly used in DAX to safely perform division and can be used to calculate percentage changes. For example, a percentage-change measure can divide the difference between current and previous values by the previous value. DIVIDE also provides an optional alternate result when the denominator is zero or blank, helping avoid calculation errors. SUM adds values, MAX returns the highest value, and COUNT counts values. Therefore, DIVIDE is an appropriate function for calculations involving ratios and percentage changes.

Question 113

Which Power BI feature allows users to view additional information by hovering over a data point in a chart?

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

Correct Answer: 1

Explanation

A Tooltip displays additional information when a user hovers over a visual element. The information can include values, categories, and even customized tooltip pages containing additional visuals. This allows report designers to provide more context without overcrowding the primary report canvas. Slicers are used for filtering, bookmarks preserve report states, and themes control formatting. Therefore, Tooltip is the appropriate feature when additional information should appear as the user moves the pointer over a data point.

Question 114

Which DAX function can return a specified alternate result when a division operation encounters a zero or blank denominator?

1. DIVIDE
2. QUOTIENT
3. SUM
4. ROUND

Correct Answer: 1

Explanation

DIVIDE is designed to perform division while allowing an optional alternate result when the denominator is zero or blank. For example, DIVIDE([Profit], [Sales], 0) can return zero instead of producing an unwanted division error when Sales is zero. QUOTIENT performs integer division, SUM adds values, and ROUND changes numeric precision. Using DIVIDE is generally preferred over manually using the division operator when the calculation needs explicit handling of invalid denominators. Therefore, DIVIDE is the correct function for this requirement.

Question 115

Which Power BI feature can be used to display a visual showing the factors that contribute to an overall metric?

1. Decomposition tree
2. Card
3. Gauge
4. Donut chart

Correct Answer: 1

Explanation

A Decomposition Tree allows users to analyze a measure across multiple dimensions and identify factors contributing to an overall value. For example, total sales can be broken down by region, product category, salesperson, and other dimensions. Users can interactively expand branches to investigate how different attributes contribute to the selected measure. Cards display individual values, gauges compare values with targets, and donut charts emphasize proportions. Therefore, the Decomposition Tree is the appropriate visual for interactively analyzing the contributors to an overall metric.

Question 116

Which Power Query transformation can convert a column containing “First Last” into separate First and Last columns using a space delimiter?

1. Split Column by Delimiter
2. Group By
3. Merge Queries
4. Remove Duplicates

Correct Answer: 1

Explanation

Split Column by Delimiter can divide a text column into multiple columns based on a specified delimiter. In this example, a space can be selected as the delimiter to separate the first and last names into different columns. The transformation can be configured to split at the first delimiter, last delimiter, or each occurrence depending on the data structure. Group By summarizes records, Merge Queries joins tables, and Remove Duplicates eliminates repeated rows. Therefore, Split Column by Delimiter is the appropriate transformation.

Question 117

Which DAX function can return the previous year period when used with a properly configured date table?

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

Correct Answer: 1

Explanation

SAMEPERIODLASTYEAR returns a table containing dates from the corresponding period in the previous year. It is frequently used with CALCULATE to create year-over-year comparison measures. For example, a Previous Year Sales measure can use CALCULATE with SAMEPERIODLASTYEAR to compare current sales against the equivalent period from the prior year. TODAY returns the current date, DATE constructs a date, and MONTH extracts a month number. Therefore, SAMEPERIODLASTYEAR is the appropriate DAX function for previous-year period comparisons.

Question 118

Which Power BI feature allows report users to select a specific data point and see the corresponding records in a detailed table or page?

1. Drillthrough
2. Theme
3. Data category
4. Query parameter

Correct Answer: 1

Explanation

Drillthrough allows users to navigate from a summary visual to a detailed page filtered according to the selected data point. For example, selecting a product in a sales chart can open a product-detail page containing transactions, customers, and other relevant information. This approach keeps summary reports concise while still allowing deeper investigation. Themes control formatting, data categories describe field semantics, and query parameters influence query behavior. Therefore, Drillthrough is the appropriate Power BI feature for moving from summary information to filtered detail.

Question 119

Which DAX function can return the first nonblank result among multiple expressions?

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

Correct Answer: 1

Explanation

COALESCE evaluates multiple expressions and returns the first result that is not BLANK. This is useful for providing fallback values in measures when the preferred calculation may return blank. For example, COALESCE([Sales Amount], 0) can display zero when the Sales Amount measure has no result. MAX returns the largest value, COUNT counts values, and SUM performs numeric aggregation. Therefore, COALESCE is the appropriate function when a calculation needs to select the first available nonblank result from several expressions.

Question 120

Which Power BI feature allows you to create a report page that users can navigate to using a button or other interactive action?

1. Report page navigation
2. Data category
3. Query folding
4. Calculated column

Correct Answer: 1

Explanation

Report page navigation allows users to move between report pages through interactive controls such as buttons. It can create a structured navigation experience where users move from an overview page to detailed analysis pages and then return to summary information. This is particularly useful for multi-page reports that need intuitive navigation. Data categories describe fields, query folding relates to Power Query source processing, and calculated columns create row-level model calculations. Therefore, report page navigation is the appropriate feature for connecting report pages through interactive navigation.