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

 

Question 301

Which DAX function can return the rank of a product based on its sales amount?

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

Correct Answer: 1

Explanation

RANKX is used to calculate the ranking of an expression across the rows of a specified table or evaluation context. For example, it can rank products according to their total sales, allowing a report to identify the highest- and lowest-performing products. RANKX can also support ascending or descending ranking depending on the required analysis. SUMX performs row-by-row calculations and aggregation, TOPN returns a specified number of top rows, and ORDERBY is used in ordering expressions. Therefore, RANKX is the appropriate DAX function for ranking products.

Question 302

Which Power Query feature allows you to create a column based on conditions such as if-then-else rules?

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

Correct Answer: 2

Explanation

Conditional Column creates a new column by applying rules based on conditions. For example, sales amounts can be classified as “High,” “Medium,” or “Low” depending on predefined thresholds. Power Query provides an interface for defining these conditions without requiring the user to manually write the complete M expression. Custom Column is more flexible when a custom formula is required, while Group By creates summaries and Merge Columns combines existing fields. Therefore, Conditional Column is the appropriate feature for creating values based on logical conditions.

Question 303

Which DAX function can return the top five rows from a table according to a specified expression?

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

Correct Answer: 3

Explanation

TOPN returns the top specified number of rows from a table according to one or more expressions used for ordering. For example, TOPN(5, Products, [Total Sales], DESC) can return the five products with the highest sales values. This function is useful for creating top-product analyses, rankings, and focused reporting scenarios. FILTER creates a table based on conditions, VALUES returns values in the current context, and DISTINCT returns unique values. Therefore, TOPN is the appropriate DAX function when a limited set of highest-ranking rows is required.

Question 304

Which Power BI relationship cardinality describes a situation where one customer can have many sales transactions?

1. One-to-one
2. Many-to-many
3. One-to-many
4. Many-to-one

Correct Answer: 3

Explanation

A one-to-many relationship means that one record in one table can correspond to multiple records in another table. In a typical sales model, a single customer in the Customer dimension can have many related transactions in the Sales fact table. The CustomerID would normally be unique in the Customer table but repeated across multiple Sales records. One-to-one allows only one matching record on each side, while many-to-many allows multiple records on both sides. Therefore, one-to-many correctly describes the customer-to-sales relationship.

Question 305

Which DAX function can evaluate an expression over a table and return the maximum result?

1. MAXX
2. MAX
3. SUMX
4. AVERAGEX

Correct Answer: 1

Explanation

MAXX evaluates an expression for each row of a table and returns the highest resulting value. It is useful when the maximum cannot be obtained directly from an existing column and must instead be calculated from row-level expressions. For example, MAXX can evaluate Quantity multiplied by Unit Price for every transaction and then return the largest calculated amount. MAX directly finds the largest value in a column, while SUMX and AVERAGEX calculate totals and averages. Therefore, MAXX is correct for row-by-row maximum calculations.

Question 306

Which Power BI storage mode stores data in the model while also allowing certain tables to use DirectQuery behavior?

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

Correct Answer: 2

Explanation

Dual storage mode allows a table to behave as either Import or DirectQuery depending on how it is used in a query. It is commonly used in composite models where dimension tables can benefit from being available in both modes. This can help Power BI optimize queries involving imported and DirectQuery tables. Import stores data in the Power BI model, while DirectQuery queries the underlying source. A live connection connects to an existing semantic model or Analysis Services source. Therefore, Dual is the correct storage mode.

Question 307

Which DAX function can return a Boolean result indicating whether exactly one value is present in the current filter context?

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

Correct Answer: 2

Explanation

HASONEVALUE checks whether a column has exactly one distinct value in the current filter context and returns TRUE or FALSE. It is useful when a calculation or display should behave differently depending on whether the user has selected one specific value. SELECTEDVALUE can return the actual selected value when only one exists, while VALUES returns a table of values. ISFILTERED checks whether a column or table is being directly filtered. Therefore, HASONEVALUE is the appropriate function when a Boolean test for a single value is required.

Question 308

Which Power Query transformation combines the contents of multiple columns into one column?

1. Merge Columns
2. Split Column
3. Append Queries
4. Group By

Correct Answer: 1

Explanation

Merge Columns combines values from two or more selected columns into a single column. Power Query can use a chosen separator, such as a space, comma, or hyphen, when combining the values. For example, separate First Name and Last Name columns can be merged into a Full Name column. Split Column performs the opposite type of operation by separating one column into multiple columns. Append Queries combines rows from queries, while Group By summarizes records. Therefore, Merge Columns is the appropriate transformation for combining column values.

Question 309

Which DAX function can return a table containing dates from the beginning of the current year through the selected date?

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

Correct Answer: 3

Explanation

DATESYTD returns a table containing dates from the beginning of the year through the last date in the current filter context. It is useful when building custom year-to-date calculations with functions such as CALCULATE. For example, CALCULATE([Total Sales], DATESYTD(‘Date'[Date])) can calculate sales accumulated from the start of the year. DATEADD shifts a date context, TOTALYTD directly calculates a year-to-date expression, and SAMEPERIODLASTYEAR returns the corresponding period from the previous year. Therefore, DATESYTD is correct for returning the year-to-date date table.

Question 310

Which Power BI visual is designed to display a single important metric prominently?

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

Correct Answer: 2

Explanation

A Card visual is designed to display a single summarized value prominently. It is commonly used for key metrics such as total sales, profit, customer count, or order quantity. Cards are useful when the report user needs to see an important number immediately without analyzing a larger chart. A KPI visual can compare performance against a target or status, while a Matrix displays structured data and a Waterfall chart shows cumulative changes. Therefore, Card is the appropriate visual for presenting one important metric clearly.

Question 311

Which DAX function can return the previous day based on the current date context?

1. PREVIOUSDAY
2. PREVIOUSMONTH
3. DATEADD
4. DAY

Correct Answer: 1

Explanation

PREVIOUSDAY returns a table containing dates from the previous day relative to the current date context. It can be used in time-intelligence calculations when comparing daily performance with the immediately preceding day. For example, a measure can use PREVIOUSDAY to calculate yesterday’s sales and compare them with today’s sales. PREVIOUSMONTH works with monthly periods, DATEADD can shift dates by various intervals, and DAY extracts the day number from a date. Therefore, PREVIOUSDAY is the appropriate function for referencing the previous day.

Question 312

Which Power Query transformation can remove columns that are not needed in the final dataset?

1. Filter Rows
2. Remove Columns
3. Group By
4. Replace Values

Correct Answer: 2

Explanation

Remove Columns eliminates selected columns from a Power Query table. It is useful during data preparation when source files contain fields that are unnecessary for analysis, contain sensitive information that should not be loaded, or add unnecessary model complexity. Removing unused columns can also reduce the amount of data loaded into the Power BI model. Filter Rows removes records rather than columns, Group By creates summaries, and Replace Values changes cell contents. Therefore, Remove Columns is the correct transformation when unwanted fields need to be eliminated.

Question 313

Which DAX function can return the corresponding period from the previous year?

1. PREVIOUSYEAR
2. DATEADD
3. SAMEPERIODLASTYEAR
4. YEAR

Correct Answer: 3

Explanation

SAMEPERIODLASTYEAR returns a table containing dates from the corresponding period one year earlier. It is commonly used to compare current sales, profit, or other measures with the equivalent period from the previous year. For example, a measure can use CALCULATE with SAMEPERIODLASTYEAR to calculate prior-year sales under the current date selection. PREVIOUSYEAR returns the previous year period, DATEADD shifts dates according to a specified interval, and YEAR extracts the year number. Therefore, SAMEPERIODLASTYEAR is the appropriate function for this comparison.

Question 314

Which Power BI feature allows a visual to display additional information when a user hovers over a data point?

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

Correct Answer: 2

Explanation

Tooltips display additional information when users hover over data points in Power BI visuals. A report author can add fields to a visual’s tooltip configuration or create a dedicated tooltip page containing additional visuals and information. This allows users to obtain more detail without leaving the current report page. Drillthrough navigates to another page, Bookmarks save report states, and Slicers provide interactive filtering. Therefore, Tooltip is the appropriate Power BI feature for showing supplementary information when a user hovers over a visual element.

Question 315

Which DAX function can return the first date in the current filter context?

1. FIRSTDATE
2. FIRSTNONBLANK
3. MIN
4. STARTOFYEAR

Correct Answer: 1

Explanation

FIRSTDATE returns the first date in the current filter context for the specified date column or expression. It can be useful when identifying the beginning of a selected period or when building calculations that depend on the first date available in the current context. FIRSTNONBLANK searches for the first value associated with a nonblank expression, while MIN returns the smallest value in a broader numerical or date context. STARTOFYEAR returns a table containing the beginning of the year. Therefore, FIRSTDATE is the correct function.

Question 316

Which Power Query feature allows you to change the data type of a selected column?

1. Detect Data Type
2. Change Type
3. Replace Values
4. Format Column

Correct Answer: 2

Explanation

Change Type allows Power Query users to assign a specific data type to a column, such as text, whole number, decimal number, date, or logical. Correct data types are important because they determine how values can be transformed, modeled, and analyzed in Power BI. For example, a date column should use a date data type so that time-intelligence operations can work correctly. Detect Data Type can identify types automatically, while Replace Values changes values. Therefore, Change Type is the appropriate transformation for manually assigning a column’s data type.

Question 317

Which DAX function can return the current date without including the current time?

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

Correct Answer: 2

Explanation

TODAY returns the current date as a date value without including the current time. It is useful for calculations that need to compare report data with the current day, such as determining whether an order is overdue or calculating the age of records. NOW returns both the current date and time, while DATE creates a date from specified year, month, and day values. UTCNOW returns the current date and time in Coordinated Universal Time. Therefore, TODAY is the appropriate DAX function for the current date only.

Question 318

Which Power BI feature allows users to move from a summary visual to a separate page containing details for the selected value?

1. Drill-down
2. Drillthrough
3. Page navigation
4. Tooltip

Correct Answer: 2

Explanation

Drillthrough allows users to navigate from a summary visual to a dedicated detail page filtered according to the selected data point. For example, selecting a particular customer in a sales report can open a customer detail page showing transactions, products, and other relevant information. Drill-down changes hierarchy levels within the same visual, Page navigation moves between pages without applying a selected data context, and Tooltips display additional information during hovering. Therefore, Drillthrough is the appropriate feature for navigating to contextual detail pages.

Question 319

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

1. SUM
2. SUMX
3. CALCULATE
4. TOTALYTD

Correct Answer: 2

Explanation

SUMX is an iterator that evaluates an expression for each row in a specified table and then adds the results together. It is especially useful when the amount to be 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 sales-value column exists. SUM directly adds values from a column, CALCULATE modifies filter context, and TOTALYTD performs year-to-date calculations. Therefore, SUMX is the correct function.

Question 320

Which Power BI feature allows report authors to save a particular configuration of filters, visibility, and visual states for later use?

1. Bookmarks
2. Themes
3. Sync slicers
4. Field parameters

Correct Answer: 1

Explanation

Bookmarks save the current state of a Power BI report page, including selected filters, slicer states, visibility settings, and other supported report configurations. They can be used to create navigation experiences, show and hide groups of visuals, or provide different predefined views of the same report page. Themes control visual formatting, Sync slicers coordinates slicer selections across pages, and Field parameters allow users to change fields dynamically. Therefore, Bookmarks are the appropriate feature for saving and restoring specific report states.