Microsoft Power BI Data Analyst PL-300 Exam Questions

Page: 1 / 14
Total 470 questions
Question 1

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from the Power BI service. they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?



Answer : C

The supported selection is C (data classifications). The key constraint is to identify dashboards that contain PII while minimizing configuration work and changes to the dashboard design. Sensitivity labels and related classifications communicate handling requirements on Power BI items with minimal visual redesign. They are intended for identifying and governing sensitive business information. This directly matches the current study-guide objective 'Apply sensitivity labels'. Visual formatting or RLS can limit views but does not attach the information-classification and downstream handling signal supplied by a sensitivity label. This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/enterprise/service-security-sensitivity-label-overview | PL-300 objective: 'Apply sensitivity labels' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You create a new query that Reference DataSourceExcel.

Does this meet the goal?



Answer : B

A query parameter centralizes a reusable value such as a server, database, path, or filter. Referencing it from each Source step removes duplicated hard-coded values and makes later changes controlled and consistent. The key constraint is to evaluate whether this proposal meets the goal: You create a new query that Reference DataSourceExcel. Answer B (No). The proposal - You create a new query that Reference DataSourceExcel - does not deliver the required result. The relevant current PL-300 study-guide bullet is 'Create and modify parameters'. Copying a path into every Source step leaves multiple values to maintain; a report parameter or custom visual does not replace the Power Query source expression.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/power-query-query-parameters | PL-300 objective: 'Create and modify parameters' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power BI service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power BI, and then click Upload

Does this meet the goal?



Answer : B

The key constraint is to evaluate whether this proposal meets the goal: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power BI, and then click. Select B (No). The proposed action - Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power BI, and then click Upload - does not satisfy the stated goal. A broader role would grant unnecessary authoring or administration, while Viewer cannot create or publish workspace content. Power BI workspace roles separate viewing, authoring, publishing, and administration. The correct assignment follows least privilege: give the user the capability stated in the scenario without also granting content or access-management rights. The current skills outline describes this competency as 'Assign workspace roles'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces | PL-300 objective: 'Assign workspace roles' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 4

Your company has training videos that are published to Microsoft Stream.

You need to surface the videos directly in a Microsoft Power BI dashboard.

Which type of tile should you add?



Answer : D

The deciding requirement in this question is to surface the videos directly in a Microsoft Power BI dashboard. Pinned dashboard tiles are service objects rather than live copies of every report setting. Changes to a source visual type are not automatically substituted into an existing tile unless the supported live-page behavior is used. The verified answer is D (web content). Editing only the source report does not necessarily update an existing dashboard tile's type, placement, theme, or phone layout. Microsoft lists this skill in the current PL-300 outline as 'Create dashboards'. This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-tiles | PL-300 objective: 'Create dashboards' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 5

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?



Answer : D

A model hierarchy provides an ordered drill path. Placing manager above sales manager lets the executive visual move from the broader management level to the individual sales-management level without duplicating the fields in every visual. The scenario is asking for a way to select the next action needed to meet the reporting requirements of the executives. The correct answer is D (In the Region table, create a hierarchy that has the manager name, and then the sales manager name). The relevant current PL-300 study-guide bullet is 'Configure table and column properties'. Changing a visual alone does not assign semantic meaning to a field, and changing the underlying values is unnecessary when a model property supplies the required behavior.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-field-list | PL-300 objective: 'Configure table and column properties' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 6

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?



Answer : B

The verified expression produces the requested scalar result under report filtering. It uses model relationships and DAX context semantics instead of shifting a dynamic calculation into a static source or calculated column. Choose B (CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(DimDate[Date]))). The relevant context is that you plan to create a measure to return the total sales Of March 2021 when March 2022 is selected. An alternative that changes the source or creates a stored column either ignores filter context or increases model size without meeting a dynamic measure requirement. This rationale is anchored to the PL-300 objective 'Create single aggregation measures'.

Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: 'Create single aggregation measures' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Question 7

You have a Power BI Desktop semantic mode) that contains a table named Sales. Sales contains the following columns:

; OrderDate

; OrderlD

; ProductID

; SalesAmount

You create a visual that shows the SalesAmount field over time.

You discover an outlier in the SalesAmount column.

You need to ensure that the outlier influences the visual as little as possible. The solution must ensure that the visual still displays overall trends in the data.

What should you do?



Answer : D

The supported selection is D (For the SalesAmount field, set the aggregate type to Median). Each Power BI visual encodes a different relationship. The field wells, filters, and formatting must preserve the intended comparison, trend, hierarchy, or composition without implying a conclusion the data does not support. The deciding requirement in this question is to ensure that the outlier influences the visual as little as possible. The solution must ensure that the visual still displays overall trends in the data. The other visual or configuration choices encode a different task, lose the required interaction, or fail one of the stated display constraints. For exam alignment, this is assessed under 'Detect outliers and anomalies' in the current study guide.

Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualizations-overview | PL-300 objective: 'Detect outliers and anomalies' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300


Page:    1 / 14   
Total 470 questions