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

 

Question 1

Which Power BI component is primarily used to create interactive reports and dashboards from analyzed data?

1. Power BI Desktop
2. Power Query
3. Power BI Gateway
4. Power BI Report Server

Correct Answer: 1

Explanation

Power BI Desktop is the primary authoring application used to connect to data, transform it, build data models, and create interactive reports. It provides tools for creating visualizations, applying filters, configuring relationships, and designing report pages. Power Query is mainly focused on data preparation, while the gateway supports connectivity between on-premises data and Power BI services. Power BI Report Server is designed for hosting reports within an organization. Therefore, Power BI Desktop is the appropriate component for creating interactive Power BI reports.

Question 2

You need to remove duplicate rows from a dataset before loading it into a Power BI model. Which Power Query feature should you use?

1. Group By
2. Remove Rows > Remove Duplicates
3. Split Column
4. Fill Down

Correct Answer: 2

Explanation

The Remove Duplicates feature in Power Query eliminates repeated rows from a dataset based on the selected columns. After selecting the relevant column or columns, you can choose Remove Rows and then Remove Duplicates. Power Query creates a transformation step that can be applied again whenever the data is refreshed. Group By is used to aggregate data, Split Column separates values, and Fill Down copies values into empty cells. Therefore, Remove Duplicates is the appropriate option for cleaning repeated records.

Question 3

A Power BI model contains Sales and Product tables. The Product table has one row for each product, while Sales contains multiple rows for each product. What relationship should normally exist between these tables?

1. One-to-one
2. Many-to-many
3. One-to-many
4. Many-to-one from Product to Sales

Correct Answer: 3

Explanation

A one-to-many relationship is appropriate when one row in the Product table can correspond to many rows in the Sales table. The Product table acts as the dimension or lookup table, while Sales acts as the fact table containing multiple transactions. The product key in Product should uniquely identify each product and relate to the corresponding product keys in Sales. This structure supports effective filtering and analysis in Power BI. A one-to-one relationship would not represent the repeated sales transactions correctly.

Question 4

Which DAX function should you use to calculate the total value of a SalesAmount column?

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

Correct Answer: 4

Explanation

The SUM function adds all numeric values in a specified column and is commonly used to calculate totals in Power BI. For example, a measure such as Total Sales = SUM(Sales[SalesAmount]) returns the total sales amount according to the current filter context. COUNT counts values, AVERAGE calculates the arithmetic mean, and DISTINCTCOUNT counts unique values. Because the requirement is to calculate the total value of the SalesAmount column, SUM is the appropriate DAX function for this calculation.

Question 5

You want a report visual to display sales performance by month in chronological order. Which field should generally be used to provide the month sequence?

1. A date field
2. A customer name
3. A product description
4. A sales amount

Correct Answer: 1

Explanation

A date field provides the chronological information needed to organize monthly sales correctly. Power BI can use date fields to create time-based groupings and sort months according to their actual calendar sequence. Using a date column also makes it easier to perform time intelligence calculations and analyze trends. Customer names, product descriptions, and sales amounts do not provide a reliable chronological sequence. A properly configured date table with appropriate date fields is generally preferred for consistent time-based reporting.

Question 6

Which Power Query transformation is most appropriate when a column contains values such as “New York, USA” and you need separate City and Country columns?

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

Correct Answer: 3

Explanation

Split Column is designed to divide one column into multiple columns based on a delimiter, number of characters, or other rules. In the example, the comma separates the city from the country, so the column can be split using the comma delimiter. This creates separate City and Country columns that can be used independently for filtering, grouping, and visualization. Merge Queries combines information from different tables, Pivot Column restructures data, and Replace Values changes specific values. Therefore, Split Column is the suitable transformation.

Question 7

You need to display the percentage of total sales represented by each product category. Which type of calculation is most appropriate?

1. A running total
2. A percentage-of-total measure
3. A row count
4. A minimum value calculation

Correct Answer: 2

Explanation

A percentage-of-total measure calculates each category’s sales as a proportion of overall sales. In Power BI, this can be created with DAX by dividing the category sales by the total sales while appropriately managing filter context. This calculation allows users to understand the contribution of each category to the complete business total. A running total tracks accumulated values over an ordered period, while row count and minimum calculations provide different types of information. Therefore, a percentage-of-total calculation directly meets the reporting requirement.

Question 8

Which Power BI visual is generally most suitable for showing the trend of sales over several months?

1. Pie chart
2. Treemap
3. Card
4. Line chart

Correct Answer: 4

Explanation

A line chart is well suited for displaying trends across a continuous or chronological axis such as months. It allows users to quickly identify increases, decreases, peaks, and fluctuations in sales over time. A pie chart is more appropriate for showing proportions, a treemap displays hierarchical categories, and a card highlights a single key value. When the primary goal is to analyze how sales change across multiple months, a line chart provides a clear and effective visual representation.

Question 9

Which Power BI feature allows users to filter a report based on a selected value directly from a visual control?

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

Correct Answer: 1

Explanation

A slicer is an interactive filtering control that allows report users to select values and filter other visuals on the report page. For example, a slicer containing product categories can allow users to select one or more categories and immediately view the corresponding sales information. Bookmarks capture report states, themes control visual formatting, and tooltips display additional information when users hover over visuals. Because the requirement is to provide an interactive filtering control, a slicer is the appropriate Power BI feature.

Question 10

A report contains a visual showing sales by region. You want users to select a region and move to another report page containing detailed information for that region. Which feature should you configure?

1. Drillthrough
2. Conditional formatting
3. Data labels
4. Small multiples

Correct Answer: 3

Explanation

Drillthrough allows users to move from a summary visual to a dedicated detail page filtered according to the selected value. A drillthrough page can contain detailed information about a particular region, customer, product, or other business entity. The destination page uses the selected field as its drillthrough filter. Conditional formatting changes the appearance of values, data labels display information directly on visuals, and small multiples divide a visual into separate panels. Therefore, drillthrough is the appropriate feature for navigating from regional summaries to detailed information.

Question 11

Which Power Query operation combines columns from two tables based on matching values in a key column?

1. Append Queries
2. Merge Queries
3. Unpivot Columns
4. Transpose

Correct Answer: 2

Explanation

Merge Queries combines data from two tables by matching values in one or more selected columns. It is similar to joining tables in a relational database. For example, a Sales table can be merged with a Product table using ProductID to bring product descriptions or categories into the Sales dataset. Append Queries instead combines rows from multiple tables, while Unpivot changes columns into attribute-value rows. Transpose switches rows and columns. Therefore, Merge Queries is the appropriate Power Query operation when combining columns using a matching key.

Question 12

Which DAX function returns the number of distinct values in a column?

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

Correct Answer: 3

Explanation

DISTINCTCOUNT returns the number of unique values in a column. It is useful when analyzing metrics such as the number of unique customers, products, invoices, or orders. For example, DISTINCTCOUNT(Sales[CustomerID]) can return the number of different customers represented in the current filter context. COUNT counts numeric values, COUNTA counts nonblank values, and SUM adds numeric values. Therefore, when the requirement specifically asks for the number of unique values rather than the total number of records, DISTINCTCOUNT is the appropriate DAX function.

Question 13

You need to change a column containing text values such as “1000” into a numeric data type in Power Query. What should you do?

1. Change the column’s data type to a numeric type
2. Create a bookmark
3. Add a report tooltip
4. Configure a relationship

Correct Answer: 1

Explanation

Power Query allows you to change the data type of a column directly. If values such as “1000” are stored as text but need to be used in mathematical calculations, the column should be converted to an appropriate numeric type such as Whole Number or Decimal Number. Correct data types improve calculations, filtering, sorting, and model behavior. Bookmarks, tooltips, and relationships do not convert the underlying values. Therefore, changing the column’s data type is the correct approach for converting numeric text into usable numeric data.

Question 14

Which visual is most appropriate for displaying a single key performance indicator such as total revenue?

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

Correct Answer: 3

Explanation

A Card visual is designed to display a single important value prominently, making it suitable for key performance indicators such as total revenue, total profit, customer count, or units sold. Cards provide a simple way for report users to see an important metric without interpreting a complex visualization. Scatter charts are useful for analyzing relationships between numerical variables, matrices display values across rows and columns, and ribbon charts can show changes in ranking. Therefore, a Card is the most suitable visual for displaying one primary KPI value.

Question 15

What is the primary purpose of a Power BI date table in a data model?

1. To store application passwords
2. To support consistent time-based analysis
3. To replace all fact tables
4. To store report themes

Correct Answer: 2

Explanation

A dedicated date table provides a consistent set of calendar attributes for time-based analysis. It can contain fields such as date, year, quarter, month, and day, allowing reports to filter and group data consistently. Date tables are particularly useful for DAX time intelligence calculations and comparisons across periods. They do not replace fact tables, store application passwords, or control report themes. A properly configured date table helps establish reliable relationships and supports calculations involving periods such as month-to-date, year-to-date, and prior-year values.

Question 16

Which Power BI feature can be used to save a specific report view, including filters and visual states, so users can return to it later?

1. Bookmarks
2. Relationships
3. Data categories
4. Query parameters

Correct Answer: 1

Explanation

Bookmarks capture the current state of a Power BI report page, including filters, slicer selections, and certain visual properties. They can be used to create navigation experiences, reset filters, or switch between different report views. For example, a bookmark can preserve a selected regional filter and allow users to return to that view later. Relationships define connections between tables, data categories provide semantic information about columns, and query parameters influence data retrieval. Therefore, bookmarks are the appropriate feature for saving and recalling report states.

Question 17

A dataset contains monthly sales columns such as January, February, March, and April. Which Power Query transformation can convert these columns into rows for easier analysis?

1. Merge Queries
2. Fill Down
3. Unpivot Columns
4. Remove Errors

Correct Answer: 3

Explanation

Unpivot Columns transform multiple columns into attribute-value rows. This is useful when data is stored in a wide format, such as having separate columns for January, February, March, and April. After unpivoting, the month names can become values in one column while their corresponding sales amounts appear in another column. This structure is generally easier to analyze and visualize. Merge Queries combines tables, Fill Down propagates values, and Remove Errors eliminates problematic records. Therefore, Unpivot Columns is the appropriate transformation for restructuring monthly columns.

Question 18

Which Power BI capability allows a report user to move from a year level to quarter, month, and day within a hierarchical visual?

1. Drill-down
2. Data refresh
3. Row-level security
4. Query folding

Correct Answer: 1

Explanation

Drill-down allows users to navigate through hierarchical levels within a visual. For example, a date hierarchy can contain Year, Quarter, Month, and Day levels. Users can start at the yearly view and drill down into quarters or months to examine increasingly detailed information. Data refresh updates the underlying data, row-level security controls access to data, and query folding relates to how Power Query transformations can be translated to the source system. Therefore, drill-down is the capability used to explore data from higher to lower hierarchy levels.

Question 19

You need to restrict report users so that each salesperson can view only the sales records assigned to them. Which Power BI security feature should you configure?

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

Correct Answer: 2

Explanation

Row-level security, or RLS, restricts the rows of data that users can access based on defined roles and filtering rules. For example, a salesperson can be assigned a role that filters the Sales table to records associated with that salesperson. When users access the published report, Power BI applies the relevant role and limits the data they can see. Conditional formatting changes visual appearance, bookmarks save report states, and drillthrough provides navigation to detail pages. Therefore, row-level security is the appropriate feature for restricting records by salesperson.

Question 20

Which Power BI service feature is used to automatically update a semantic model on a scheduled basis?

1. Data alerts
2. Report subscriptions
3. Scheduled refresh
4. Sensitivity labels

Correct Answer: 3

Explanation

Scheduled refresh allows a Power BI semantic model to be updated automatically at configured times. This is useful when the underlying data source changes regularly and report users need current information without manually refreshing the model. Depending on the data source and configuration, a gateway may also be required for accessing on-premises data. Data alerts notify users when conditions are met, subscriptions deliver report snapshots or links, and sensitivity labels help classify and protect information. Therefore, scheduled refresh is the appropriate feature for automatic model updates.