PL-300 practice questions 51–60

1. Question 51 · 358 in bank

   You are building a Power BI report that uses data from an Azure SQL database named erp1. You import the following tables.

   

   You need to perform the following analyses: ✑ Orders sold over time that include a measure of the total order value Orders by attributes of products sold

   

   The solution must minimize update times when interacting with visuals in the report. What should you do first?

   • AFrom Power Query, merge the Order Line Items query and the Products query.
   • BCreate a calculated column that adds a list of product categories to the Orders table by using a DAX function.
   • CCalculate the count of orders per product by using a DAX function.
   • DFrom Power Query, merge the Orders query and the Order Line Items query.

   Show answer

   Answer: D

   Explanation

   I'm very sure it's D. It's the Header/Detail Schema, and the most optimal way is to flatten the header into the detail table.

   Source: Adapted from community discussion — PinkZebra

   Next question

2. Question 52 · 358 in bank

   You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis. What should you do?

   • AGet data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.
   • BGet data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
   • CGet data from a SharePoint folder, enter the site URL, and then select Combine & Load.
   • DGet data from a SharePoint list, enter the site URL, and then select Combine & Load.

   Show answer

   Answer: A

   Explanation

   We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

   Source: Adapted from community discussion — fred92

   Next question

3. Question 53 · 358 in bank

   DRAG DROP - You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

   

   Sheet2 contains the following table named Table2.

   

   You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

   

   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. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

   Source: Adapted from community discussion — emmanuelkech

   

   Next question

4. Question 54 · 358 in bank

   You need to update the Power BI model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual. What should you create?

   • Aa group
   • Ba calculated table
   • Ca hierarchy
   • Da calculated column

   Show answer

   Answer: C

   Next question

5. Question 55 · 358 in bank

   You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different folder. When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data. You need to ensure that the data in File1 refreshes properly. What should you do?

   • AChange the data source.
   • BClear the permissions of File1.
   • CExport a PBIDS file.
   • DModify the permissions for File1.

   Show answer

   Answer: A

   Next question

6. Question 56 · 358 in bank

   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:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Top N - 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. Box 2: Visual - The reports must show historical data for the current calendar year and the last three calendar years. Applying specific measures to the visual-level filter of a visualization is a very powerful technique to completely customize the items shown in a report. The presence of this filter requires special measures in order to display values related to items not included in the visual level filter. Reference: https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

   Source: Adapted from community discussion — MauDV

   

   Next question

7. Question 57 · 358 in bank

   You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

   • Apie chart
   • Bscatterplot
   • Cbar chart

   Show answer

   Answer: C

   Explanation

   The report must show "The percentage of orders that were shipped late by country and shipping region", so I think that the Bar chart fits better

   Source: Adapted from community discussion — Fer079

   Next question

8. Question 58 · 358 in bank

   You have a Power BI report named Report that contains the following tables.

   

   For the last three days, refresh in Power BI has failed, and you receive the following error message: “You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.” You need to resolve the error and ensure that query response times are minimized for end users. What should you do?

   • AMerge the Sales person and invoice tables based on the SalesPersonId column.
   • BChange the invoice table to a DirectQuery table and read the data live from the source, retaining only the dimension tables as import tables.
   • CReduce the size of the invoice table by summarizing sales by Product, Sales person, Calendar, and Customer.
   • DChange the invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table.

   Show answer

   Answer: D

   Next question

9. Question 59 · 358 in bank

   HOTSPOT - You need to create a KPI visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   The sales managers require a visual to analyze sales performance versus sales targets. Box 1: Sales[sales_amount] Value; The main measure which we want to evaluate Example: Sales = sum(FactInternetSales[SalesAmount]) Box 2: Date[month] Trend; How Value perfoms in a time period, is it going upward, downwardג€¦? You can use Months as trend axis. Box 3: Targets[sales_target] Target; What we want to compare the Value with Reference: https://radacad.com/kpi-visual-in-power-bi-explained

   

   Next question

10. Question 60 · 358 in bank

    Select 2

    You have a table named DIMCountries that contains a column named Country as shown in the following table.

    

    You plan to use DIMCountries as a dimension in a report. You need to ensure that the Country column in DIMCountries lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

    • AChange Data category to Country.
    • BRemove duplicate values.
    • CApply a clean transform.
    • DReplace the empty fields.
    • EApply a Capitalize Each Word transform.

    Show answer

    Answer: BE

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 51. 358 questions available.