Online Access Free PL-300 Exam Questions

You a-e using Power BI Desktop 10 profile data in Power Query Editor.
You need to review the percentage of errors and the maximum value of each column.
Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

What determines the answer is the need to review the percentage of errors and the maximum value of each column. The selections in the retained answer exhibit are the verified configuration. This is a shaping operation in Power Query. Performing it in the applied steps produces correctly typed, named, and structured columns before loading, which keeps report and model logic focused on analysis. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. The current PL-300 study guide places this under the objective " Evaluate data, including data statistics and column properties " .
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: " Evaluate data, including data statistics and column properties " | Study guide: https://learn.microsoft.com/en- us/credentials/certifications/resources/study-guides/pl-300

You have a Power BI workspace that contains a single report named Sales.
You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:

The retained answer-area mapping contains the correct selections. The required outcome is to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard. Editing only the source report does not necessarily update an existing dashboard tile ' s type, placement, theme, or phone layout. 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. In Microsoft ' s current exam outline, the corresponding objective is " Create dashboards " .
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

You have a sales system that contains the tables shown in the following table.

The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?

• A.CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DateID] ))
• B.(SUM('Sales'[sales_amount]) - CALCULATE(SUM('Sales'[sales_amount] ), SAMEPERIODLASTYEAR('Date'[DateID])))/ CALCULATE(SUM('Sales'[sales_amount] ), SAMEPERIODLASTYEAR('Date'[DateID]))
• C.CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID] ))
• D.SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount] ), SAMEPERIODLASTYEAR(
  ' Date ' [DateID])

You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?

• A.Q & A
• B.key influencers
• C.funnel chart
• D.decomposition tree

You have a Power BI report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

• A.Move the conditional formatting icons to a tooltip report
• B.Add alt text that lists the values in the table.
• C.Remove the icons and use red, yellow, and green background colors instead
• D.Change the icons to use a different shape for each color.