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

 

Question 261

Which DAX function can rank a value compared with other values in a specified context?

1. RANKX
2. RANK
3. ORDERBY
4. SORT

Correct Answer: 1

Explanation

RANKX calculates the rank of an expression over a table based on a specified evaluation. It is commonly used to rank products, salespeople, regions, or other entities according to a measure or numeric value. For example, RANKX can assign a position to each product based on total sales, allowing users to identify the highest-performing products. The function can work with ascending or descending rankings and can be affected by filter context. Therefore, RANKX is the appropriate DAX function for creating rankings in Power BI.

Question 262

Which Power Query transformation converts values in a column into separate columns based on another field?

1. Unpivot Columns
2. Pivot Column
3. Split Column
4. Transpose

Correct Answer: 2

Explanation

Pivot Column transforms distinct values from one column into separate columns while using another column to populate the resulting values. This is useful when source data is stored vertically but the desired output requires categories to become columns. For example, monthly sales categories can be transformed into separate columns for easier analysis. Unpivot performs the opposite type of restructuring by converting columns into rows. Split Column divides values, while Transpose switches rows and columns. Therefore, Pivot Column is the correct transformation for this requirement.

Question 263

Which DAX function returns a table containing the values that are directly visible in the current filter context?

1. ALL
2. DISTINCT
3. VALUES
4. FILTER

Correct Answer: 3

Explanation

VALUES returns a one-column table containing the distinct values from a column or a table in the current filter context. It is frequently used in DAX calculations where the currently selected values need to be evaluated or passed into another expression. For example, VALUES(Product[Category]) can return the categories currently available under the active filters. ALL removes filters, DISTINCT returns unique values without the same context behavior in some scenarios, and FILTER creates a filtered table based on a condition. Therefore, VALUES is appropriate here.

Question 264

Which Power BI feature allows multiple visuals to use the same slicer selection across different report pages?

1. Sync slicers
2. Bookmarks
3. Drillthrough
4. Tooltips

Correct Answer: 1

Explanation

Sync slicers allows a slicer selection to be shared across multiple report pages. This is useful when a report contains several pages and users should be able to select a value, such as a region or year, while keeping the same selection applied when navigating between pages. The Sync slicers pane controls which pages use the slicer and whether it is visible on each page. Bookmarks save report states, Drillthrough navigates to detail pages, and Tooltips provide additional information.

Question 265

Which DAX function can return the number of rows in a table after a filter is applied?

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

Correct Answer: 2

Explanation

COUNTROWS returns the number of rows in a table. When a filtered table expression is supplied, it counts the rows remaining after that filtering operation. For example, COUNTROWS(FILTER(Sales, Sales[Amount] > 1000)) can count transactions whose amount exceeds 1,000. COUNT counts numeric values in a column, COUNTA counts nonblank values, and DISTINCTCOUNT counts unique values. Therefore, COUNTROWS is particularly useful when the requirement involves counting records in a table or a filtered table expression.

Question 266

Which Power BI storage mode keeps data in the source system and sends queries to the source when users interact with the report?

1. Import
2. DirectQuery
3. Dual
4. Cached

Correct Answer: 2

Explanation

DirectQuery keeps the data in the underlying source rather than importing the complete dataset into the Power BI model. When users interact with visuals, Power BI sends queries to the source system to retrieve the required results. This approach can be useful when data is too large to import or when near-real-time access is required, although performance depends on the source and query design. Import stores data in the model, while Dual can operate using either imported or DirectQuery behavior depending on the situation.

Question 267

Which DAX function can return the value associated with a related table when the relationship and matching row are available?

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

Correct Answer: 2

Explanation

RELATED retrieves a value from a related table when an appropriate relationship exists between the tables. It is commonly used in calculated columns to bring an attribute from a lookup or dimension table into the current table. For example, a Sales table can use RELATED(Product[Category]) to retrieve the category associated with each sales record. RELATEDTABLE returns a related table rather than a single value. LOOKUPVALUE searches based on specified conditions, while VALUES returns a table of values. Therefore, RELATED is correct for this scenario.

Question 268

Which Power Query option can create a new column whose value is calculated using a custom formula?

1. Conditional Column
2. Custom Column
3. Group By
4. Duplicate Column

Correct Answer: 2

Explanation

Custom Column allows users to create a new column using a Power Query formula written in the M language. It is useful when the required calculation cannot be completed with a standard transformation. For example, a custom column can combine fields, perform mathematical calculations, or apply conditional logic using an expression. Conditional Column creates values based on defined conditions, Group By summarizes records, and Duplicate Column copies an existing column. Therefore, Custom Column is the appropriate feature for creating a column using a custom formula.

Question 269

Which DAX function can return the year-to-date value for an expression?

1. TOTALYTD
2. TOTALMTD
3. TOTALQTD
4. YEAR

Correct Answer: 1

Explanation

TOTALYTD calculates the year-to-date value of an expression based on the current date context. It is commonly used for measures such as year-to-date sales, expenses, or profit. The calculation accumulates values from the beginning of the relevant year through the current date in the filter context. TOTALMTD performs a month-to-date calculation, TOTALQTD performs a quarter-to-date calculation, and YEAR extracts the year from a date. Therefore, TOTALYTD is the appropriate DAX function for calculating year-to-date totals.

Question 270

Which Power BI model design generally places descriptive dimension tables around a central fact table?

1. Snowflake schema
2. Star schema
3. Flat file model
4. Single-table model

Correct Answer: 2

Explanation

A star schema organizes a central fact table containing measurable business events and surrounding dimension tables containing descriptive attributes. For example, a Sales fact table may connect to Customer, Product, Date, and Store dimensions. This structure generally makes relationships easier to understand and supports efficient analytical queries. A snowflake schema further normalizes dimensions into additional related tables. Flat-file and single-table models do not provide the same dimensional organization. Therefore, the star schema is the model design described in the question.

Question 271

Which DAX function can return the next month relative to the current date context?

1. PREVIOUSMONTH
2. NEXTMONTH
3. MONTH
4. EOMONTH

Correct Answer: 2

Explanation

NEXTMONTH returns a table containing dates from the month immediately following the current date context. It can be useful when calculations need to reference future monthly periods, such as comparing current results with the following month’s values. PREVIOUSMONTH returns dates from the preceding month, MONTH extracts the month number from a date, and EOMONTH returns the last date of a month after applying a specified offset. Therefore, NEXTMONTH is the appropriate function when the next month’s date context is required.

Question 272

Which Power BI filter level applies a filter to every page in a report?

1. Visual-level filter
2. Page-level filter
3. Report-level filter
4. Slicer-level filter

Correct Answer: 3

Explanation

A report-level filter applies to all pages in a Power BI report. This is useful when a restriction should remain consistent throughout the report, such as limiting all pages to a particular business unit or fiscal year. A visual-level filter affects only one visual, while a page-level filter affects visuals on one report page. A slicer is an interactive report control rather than a standard filter-level category. Therefore, a report-level filter is the appropriate choice when the same filtering condition must apply across the entire report.

Question 273

Which DAX function can return the value selected when a column has exactly one value in the current context?

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

Correct Answer: 1

Explanation

SELECTEDVALUE returns the value when the specified column has exactly one distinct value in the current filter context. It can also return an alternate result when there is no single selected value. This makes it useful for dynamic titles, labels, and calculations that depend on a user’s selection. HASONEVALUE checks whether exactly one value exists but returns a Boolean result rather than the selected value itself. VALUES returns a table of values, while DISTINCT returns unique values. Therefore, SELECTEDVALUE is the correct function.

Question 274

Which Power Query transformation removes records that contain errors in one or more columns?

1. Remove Duplicates
2. Remove Errors
3. Filter Rows
4. Replace Values

Correct Answer: 2

Explanation

Remove Errors eliminates rows containing errors from a selected column or relevant table data. It is useful when source systems contain invalid values that prevent a clean dataset from being loaded or analyzed. For example, records containing conversion errors after changing a column’s data type can be removed using this transformation. Remove Duplicates targets repeated records, Filter Rows removes records based on conditions, and Replace Values changes matching values. Therefore, Remove Errors is the appropriate Power Query transformation for removing error-containing records.

Question 275

Which DAX function can return a table containing dates between a specified start date and end date?

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

Correct Answer: 1

Explanation

DATESBETWEEN returns a table containing dates between a specified beginning date and ending date. It is commonly used in time-intelligence calculations where a measure needs to operate over a custom date range. For example, it can help calculate sales between two selected dates within a report. DATE creates a specific date, DATEDIFF calculates the difference between dates, and EDATE shifts a date by a specified number of months. Therefore, DATESBETWEEN is the appropriate function for defining a date range in DAX.

Question 276

Which Power BI feature lets users create a visual that identifies factors contributing to a selected outcome?

1. Key influencers
2. Gauge
3. Card
4. Donut chart

Correct Answer: 1

Explanation

The Key influencers visual analyzes data to identify factors associated with a selected outcome. For example, it can help determine which customer attributes are associated with higher sales or which conditions are associated with a particular result. The visual presents factors that have relationships with the analyzed value and allows users to explore those factors interactively. A Gauge compares a value with a target, a Card displays a single value, and a Donut chart shows proportions. Therefore, Key influencers is the appropriate visual for this purpose.

Question 277

Which DAX function can remove filters from a specified column or table while evaluating a calculation?

1. ALLSELECTED
2. REMOVEFILTERS
3. KEEPFILTERS
4. FILTER

Correct Answer: 2

Explanation

REMOVEFILTERS clears filters from specified tables or columns when evaluating a DAX expression. It is often used with CALCULATE when a calculation needs to ignore a particular filtering condition. For example, a measure can remove the Product filter to calculate a broader total while retaining other active filters. ALLSELECTED preserves filters originating from outside the current visual context, KEEPFILTERS adds restrictions without replacing existing filters, and FILTER creates a filtered table expression. Therefore, REMOVEFILTERS is correct for explicitly clearing filters.

Question 278

Which Power BI feature allows users to move between report pages by selecting a button?

1. Drillthrough
2. Bookmarks
3. Page navigation
4. Sync slicers

Correct Answer: 3

Explanation

Page navigation allows report users to move between report pages through navigation buttons or other navigation controls. It can make reports easier to use by providing a structured menu or set of buttons for accessing different sections. For example, a report may have buttons for Sales, Customers, Inventory, and Finance pages. Drillthrough moves users to detail pages based on a selected data point, Bookmarks save specific report states, and Sync slicers synchronizes slicer selections. Therefore, Page navigation is the correct feature.

Question 279

Which DAX function can calculate a value for each row of a table and then aggregate the results?

1. SUM
2. SUMX
3. COUNTROWS
4. MAX

Correct Answer: 2

Explanation

SUMX is an iterator function that evaluates an expression for each row of a specified table and then adds the resulting values together. It is useful when the required total cannot be obtained by simply summing an existing column. For example, SUMX can calculate Quantity multiplied by Unit Price for every sales row and then add those row-level amounts. SUM adds values from a column directly, COUNTROWS counts records, and MAX returns the largest value. Therefore, SUMX is appropriate for row-by-row calculations followed by aggregation.

Question 280

Which Power BI capability allows a user to test how a report behaves under a defined row-level security role?

1. Manage relationships
2. View as role
3. Edit interactions
4. Performance Analyzer

Correct Answer: 2

Explanation

View as role allows report developers to test how data appears when a specific row-level security role is applied. This is useful for verifying that users assigned to different roles can see only the records permitted by the defined security filters. For example, a regional role can be tested to confirm that only the appropriate region’s data is visible. Manage relationships handles model connections, Edit interactions controls visual behavior, and Performance Analyzer examines report performance. Therefore, View as role is the correct capability for testing RLS behavior.