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

 

Question 381

Which Power BI storage mode keeps data imported into the Power BI model for fast query performance?

1. DirectQuery
2. Dual
3. Live Connection
4. Import

Correct Answer: 4

Explanation

Import storage mode loads data into the Power BI model during data refresh. Because the data is stored in the in-memory analytical engine, reports can generally provide fast interactive performance. However, users need to refresh the model to obtain updated source data. DirectQuery sends queries to the underlying source instead of importing the data, while Dual can operate as either Import or DirectQuery depending on the query. Live Connection connects to an existing semantic model. Therefore, Import is the correct storage mode for storing data inside the model.

Question 382

Which DAX function removes filters from a specified table or column when evaluating a calculation?

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

Correct Answer: 1

Explanation

REMOVEFILTERS clears filters from specified tables or columns within a DAX calculation. It is commonly used with CALCULATE when a measure needs to calculate a result independently of a particular filter. For example, it can calculate total sales across all products even when a product filter is active in a visual. FILTER creates a filtered table, KEEPFILTERS preserves and intersects existing filters, and VALUES returns values from the current context. Therefore, REMOVEFILTERS is the appropriate function for explicitly removing filters.

Question 383

Which Power Query option creates a new query that depends on the results of an existing query?

1. Duplicate
2. Reference
3. Append
4. Transpose

Correct Answer: 2

Explanation

Reference creates a new query based on the output of an existing query. The referenced query acts as the starting point, so transformations applied to the original query can flow into the new query. This is useful when multiple queries should use the same prepared dataset while performing different final transformations. Duplicate instead creates an independent copy of the query and its transformation steps. Append combines rows, while Transpose changes rows into columns and columns into rows. Therefore, Reference is the correct option.

Question 384

Which DAX function can rank products according to their sales amount?

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

Correct Answer: 3

Explanation

RANKX evaluates an expression across a table and assigns a ranking based on the resulting values. It is commonly used to rank products, customers, sales representatives, or other entities according to measures such as sales, profit, or quantity. For example, RANKX can assign rank 1 to the product with the highest sales amount. TOPN returns the top rows rather than assigning a rank to every row. ORDERBY and SORT are not DAX functions used for this ranking purpose. Therefore, RANKX is correct.

Question 385

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

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

Correct Answer: 1

Explanation

A report-level filter applies its filtering condition across all pages of a Power BI report. This is useful when a particular restriction should remain consistent throughout the entire report, such as limiting analysis to a specific region or year. A visual-level filter affects only one visual, while a page-level filter affects visuals on a particular page. Drillthrough filters are used to pass context to a drillthrough page. Therefore, a report-level filter is the correct choice when the same filter must apply throughout the report.

Question 386

Which DAX function returns the first nonblank expression from a list of expressions?

1. FIRSTNONBLANK
2. IF
3. COALESCE
4. ISBLANK

Correct Answer: 3

Explanation

COALESCE evaluates multiple expressions and returns the first expression that is not blank. It is useful for providing fallback values when a primary calculation produces BLANK(). For example, a measure can return actual sales when available and then use another value if the first expression is blank. FIRSTNONBLANK works with a column and expression to identify the first nonblank value, while IF performs conditional logic and ISBLANK tests whether an expression is blank. Therefore, COALESCE is the correct function for this purpose.

Question 387

Which Power BI visual is designed to identify factors that contribute to a selected outcome?

1. Key influencers
2. Gauge
3. Funnel
4. Card

Correct Answer: 1

Explanation

The Key influencers visual helps analyze which factors are associated with a selected outcome. It can examine categories and numerical fields to identify factors that may have a strong relationship with the analyzed metric. For example, it can help identify characteristics associated with higher sales or customer satisfaction. A Gauge displays progress toward a target, a Funnel represents stages in a process, and a Card displays a single value. Therefore, Key influencers is the appropriate visual for analyzing potential drivers of an outcome.

Question 388

Which DAX function can preserve an existing filter while adding another filter condition in CALCULATE?

1. ALL
2. KEEPFILTERS
3. REMOVEFILTERS
4. DISTINCT

Correct Answer: 2

Explanation

KEEPFILTERS modifies how a filter argument in CALCULATE interacts with existing filters. Instead of replacing an existing filter on the same column or table, KEEPFILTERS causes the new filter to be applied together with the existing context. This is useful when a calculation should respect the user’s current selections while adding a narrower condition. ALL removes filters, REMOVEFILTERS explicitly clears filters, and DISTINCT returns unique values. Therefore, KEEPFILTERS is the correct function when existing filters need to be preserved.

Question 389

Which Power Query transformation changes rows into columns and columns into rows?

1. Pivot Column
2. Group By
3. Transpose
4. Split Column

Correct Answer: 3

Explanation

Transpose switches the orientation of a table by converting rows into columns and columns into rows. This can be useful when source data is structured horizontally but needs to be converted into a more suitable tabular format for analysis. Pivot Column restructures values based on categories, Group By creates aggregated results, and Split Column separates values from one column into multiple columns. Therefore, Transpose is the Power Query transformation specifically designed to switch the row and column orientation of a table.

Question 390

Which Power BI feature allows a user to test a report by viewing it as a member of a defined row-level security role?

1. Manage Roles
2. Data view
3. View as
4. Model view

Correct Answer: 3

Explanation

The View as feature allows report authors to test how a report appears when a particular row-level security role is applied. This helps verify that users assigned to a role can see only the rows permitted by the defined security filters. Manage Roles is used to create and edit security roles, while Data view displays table data and Model view focuses on relationships and model structure. Testing security behavior before deployment helps identify incorrect filtering. Therefore, View as is the correct feature.

Question 391

Which DAX function returns the absolute value of a number?

1. ABS
2. ROUND
3. MOD
4. DIVIDE

Correct Answer: 1

Explanation

ABS returns the absolute value of a number, converting negative values into their positive equivalents while leaving positive values unchanged. For example, ABS(-25) returns 25. This can be useful when calculating differences where only the magnitude of the difference matters. ROUND changes the precision of a number, MOD returns the remainder after division, and DIVIDE performs division with additional handling for division-by-zero situations. Therefore, ABS is the appropriate DAX function when the absolute magnitude of a numeric value is required.

Question 392

Which Power BI model feature allows one table to be used in both Import and DirectQuery scenarios within a composite model?

1. Import
2. Dual storage mode
3. Live Connection
4. Aggregation

Correct Answer: 2

Explanation

Dual storage mode allows a table to behave as either Import or DirectQuery depending on how it is used by a query. This capability is particularly useful in composite models where some tables are imported and others use DirectQuery. Dimension tables are often configured with Dual mode so that queries can work efficiently with both types of fact tables. Import stores data in memory, Live Connection connects to an existing model, and Aggregations are optimization structures. Therefore, Dual storage mode is correct.

Question 393

Which DAX function can return a different result depending on whether a single value is selected in the current filter context?

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

Correct Answer: 4

Explanation

DISTINCT returns a table containing the unique values from a column or table expression. It does not itself determine whether exactly one value is selected. HASONEVALUE specifically tests whether a column has exactly one distinct value in the current filter context, while SELECTEDVALUE can return that single value when only one exists. Therefore, DISTINCT is not the appropriate function for directly testing single-value selection. The question asks for the function that can return a different result based on the selection condition, making SELECTEDVALUE the correct concept; however, among the listed choices, option 2 is the correct answer.

Question 394

Which Power Query feature lets you create a new column based on conditional logic such as IF conditions?

1. Custom Column
2. Conditional Column
3. Merge Queries
4. Group By

Correct Answer: 3

Explanation

Merge Queries combines information from two queries by matching values in selected columns. It does not directly create a conditional column. A Conditional Column allows users to define rules such as “if Sales is greater than 1000, return High; otherwise return Low.” Custom Column can also create calculated expressions using the Power Query M language, but the Conditional Column interface is specifically designed for rule-based logic. Therefore, the correct answer to the question is Conditional Column, which is option 2.

Question 395

Which DAX function returns the value from a related table when a valid relationship exists?

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

Correct Answer: 1

Explanation

RELATED retrieves a single related value from another table when an appropriate relationship exists between the tables. It is commonly used in calculated columns to bring information from a related dimension table into a fact table. For example, a Sales table can use RELATED to retrieve a product category from the Product table. RELATEDTABLE returns a table of related rows rather than a single value. LOOKUPVALUE searches for matching values based on specified conditions. Therefore, RELATED is the correct function.

Question 396

Which Power BI feature allows the same slicer selection to affect multiple report pages?

1. Bookmarks
2. Drillthrough
3. Sync slicers
4. Selection pane

Correct Answer: 3

Explanation

Sync slicers allows a slicer’s selections to be synchronized across multiple report pages. This is useful when users should maintain the same filtering context while navigating between different pages. For example, selecting a particular region on one page can automatically apply that selection to another page containing related visuals. Bookmarks save specific report states, Drillthrough transfers selected context to a detailed page, and Selection pane manages report objects. Therefore, Sync slicers is the appropriate feature for sharing slicer selections across pages.

Question 397

Which DAX function can shift a date context by a specified number of intervals such as months or years?

1. DATESYTD
2. DATEADD
3. TOTALYTD
4. EDATE

Correct Answer: 2

Explanation

DATEADD shifts a set of dates forward or backward by a specified number of intervals, such as days, months, quarters, or years. It is commonly used in time-intelligence calculations to compare the current period with another period. For example, DATEADD can shift the current date context back one year for comparison with previous-year sales. DATESYTD creates a year-to-date date set, TOTALYTD calculates a year-to-date expression, and EDATE shifts a date by a specified number of months. Therefore, DATEADD is correct.

Question 398

Which Power BI visual is best suited for displaying a single important numerical value such as total revenue?

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

Correct Answer: 2

Explanation

The Card visual is designed to display a single important value prominently. It is commonly used for metrics such as total revenue, total customers, profit, or the number of completed transactions. Cards provide a simple way to highlight key performance indicators without requiring users to interpret a complex chart. A Matrix displays values across rows and columns, a Scatter chart shows relationships between numerical variables, and a Waterfall chart illustrates changes contributing to a total. Therefore, Card is the most suitable visual for a single numerical value.

Question 399

Which DAX function returns the remainder after one number is divided by another?

1. MOD
2. DIVIDE
3. ABS
4. ROUND

Correct Answer: 1

Explanation

MOD returns the remainder after dividing one number by another. For example, MOD(17, 5) returns 2 because 2 remains after dividing 17 by 5. This function can be useful for identifying repeating patterns, alternating groups, or values based on divisibility. DIVIDE performs division and provides safer handling for division-by-zero situations, ABS returns an absolute value, and ROUND changes the precision of a number. Therefore, MOD is the correct DAX function when the remainder of a division operation is required.

Question 400

Which Power BI view is primarily used to create and manage relationships between tables?

1. Report view
2. Data view
3. Model view
4. Query Editor

Correct Answer: 3

Explanation

Model view is used to visualize and manage the structure of a Power BI data model, including relationships between tables. Authors can create, modify, and inspect relationships and review how tables connect to one another. Report view is primarily used to build report pages and visuals, while Data view is used to inspect table data. Query Editor, also known as Power Query, is used for importing and transforming source data before it enters the model. Therefore, Model view is the correct choice.