Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 331:

  You have the CSV file shown in the following table.

  You use Power Query Editor to preview the data in the file.

  You need to transform the data to meet the following requirements:

  The first column must contain the month.

  The second column must contain the year.

  The third column must contain the order amount for the month and year.

  Which transformation should you use first?

  A. unpivot

  B. pivot

  C. transpose

  D. remove

  Correct Answer: C

• Question 332:

  A user creates a Power B1 report named ReportA that uses a custom theme

  You create a dashboard named DashboardA.

  You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. From DashboardA upload a JSON theme.

  B. Publish ReportA to the Microsoft Power B1 Community theme gallery.

  C. From DashboardA create a custom theme.

  D. From ReportA save the current theme.

  E. Publish ReportA to Power Bl.

  Correct Answer: AE

• Question 333:

  You need to create a visual that compares profit across 10 product categories for a selected quarter.

  What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

  A. an area chart

  B. a clustered bar chart

  C. a line chart

  D. a funnel chart

  Correct Answer: B

• Question 334:

  You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

  From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

  Use Analytics views.

  Filter data from the cloud.

  Which connector should you use?

  A. OData queries

  B. Azure DevOps (Boards only)

  C. Azure DevOps Server (Boards only)

  D. OData feed

  Correct Answer: B

• Question 335:

  You are configuring a Power BI report for accessibility as shown in the following table.

  

  You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

  Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. First-level elements colors

  B. Theme colors

  C. Divergent colors

  D. Sentiment colors

  Correct Answer: BC

• Question 336:

  You have a Power B1 dataset that contains quarterly sales performance data.

  You need to enable managers to review the data in a format that meets the following requirements:

  Is optimized for printing.

  Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

  What should you create?

  A. a paginated report

  B. a template app

  C. an interactive report

  D. a dashboard

  Correct Answer: A

• Question 337:

  HOTSPOT

  You need to create a relationship in the dataset for RLS.

  What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: many-to-one

  Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.

  The Suppliers table has a Region column.

  Box 2: Suppliers table

• Question 338:

  HOTSPOT

  You need to create the Top Customers report.

  Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Top N

  Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

  Once you drag to SKU to Visual level filter you should get Top N option

  Note: The two most common filter types: automatic and manual.

  Then there are more advanced filters.

  Box 2: Visual

  Once you drag to SKU to Visual level filter you should get Top N option.

  Reference:

  https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

• Question 339:

  HOTSPOT

  You need to create a solution to meet the notification requirements of the warehouse shipping department.

  What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct select is worth one point:

  Hot Area:

  

  Correct Answer:

  

  Box 1: dashboard

  The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.

  You can set alerts to notify you when data in your dashboards changes beyond limits you set.

  Box 2: data alert

  Reference:

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

• Question 340:

  HOTSPOT

  You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

  For each of the following statement, select Yes if the statement is true, Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  1) NO - CustomerID in Orders is text ("VINET") while CustomerID in Customer Details is number ("1").

  2) YES - Relationship between Orders and Customer Details will be via column CustomerCRMID in Customer Details and CustomerID in Orders, which are both text.

  3) NO - the Orders table only contains shipping address, which is different from the billing address which should be used for sales region. Thus, it should come from Customer Details table.