PL-300 practice questions 131–140

1. Question 131 · 358 in bank

   You have a Power BI report for the procurement department. The report contains data from the following tables.

   

   There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

   

   You need to minimize the size of the dataset without affecting the visuals. What should you do?

   • AMerge Suppliers and LineItems.
   • BRemove the LineItems[Description] column.
   • CRemove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month.
   • DGroup LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price].

   Show answer

   Answer: B

   Explanation

   Questions like these scare me. Huge description, and such a simple answer, makes me think if there is a trick here. Why Microsoft why!?

   Source: Adapted from community discussion — scotchtapebunny

   Next question

2. Question 132 · 358 in bank

   Select 2

   You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

   

   There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.

   

   The dataset takes a long time to refresh. You need to modify Posts and Traffic queries to reduce load times. Which two actions will reduce the load times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • ARemove the rows in Posts in which Posts[Publish Date] is in the last seven days.
   • BRemove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€.
   • CRemove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL].
   • DRemove Posts[Full Text] and Posts[Summary].
   • ERemove the rows in Traffic in which Traffic[Referring URL] does not start with ג€/ג€.

   Show answer

   Answer: BD

   Explanation

   E is not correct. There are perfectly valid blog hits that won't have a referring URL, so filtering those rows removes valid hits that need to be counted. The answer is D & B. It feels a bit unnatural to me to be pulling rows instead of columns, but all the visuals we're talking about here involve blog hits specifically, so pulling the non-blog website traffic out of the dataset appears to be the right path forward.

   Source: Adapted from community discussion — itenginerd

   Next question

3. Question 133 · 358 in bank

   You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails. The primary key of DimCustomer is CustomerID. FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value. You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance. What should you create?

   • Aan active, single-direction, many-to-one relationship
   • Ban inactive, single-direction, one-to-many relationship
   • Can active, single-direction, one-to-many relationship
   • Dan active, bi-directional, many-to-one relationship

   Show answer

   Answer: A

   Next question

4. Question 134 · 358 in bank

   HOTSPOT - You are creating a quick measure as shown in the following exhibit.

   

   You need to create a monthly rolling average measure for Sales over time. How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   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

   I checked this pre-populated "Days" value in the period field is the default value when you are selecting the "Rolling average" quick measure in PBI Desktop... maybe this should be blank by default requesting the user to select the period

   Source: Adapted from community discussion — jaume

   

   Next question

5. Question 135 · 358 in bank

   You have a Power BI model that contains a table named Expenses. The table contains the following columns: • Date • Amount • Category • Expense ID • Employee ID Expenses are recorded by employees, and each expense has a unique expense ID. You need to create a DAX measure that will calculate the total amount of expenses. Which DAX expression should you use?

   • ASum(‘Expenses’[Amount])
   • BMax(‘Expenses’[Amount])
   • CSum(‘Expenses’[Expense ID])
   • DCount(‘Expenses’[Amount])

   Show answer

   Answer: A

   Next question

6. Question 136 · 358 in bank

   You have the Power BI data model shown in the following exhibit.

   

   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?

   • ACalculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
   • BTOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
   • CCalculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
   • DSUM(Sales[Sales])

   Show answer

   Answer: C

   Explanation

   "PREVIOUSYEAR: Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context." This means, if my date data ranges from 2007/08/05 -2007/09/05. The last date in this column is 2007/09/05. The returned column would be 365 date from 2006/01/01 to 2006/12/31. for SAMEPERIODLASTYEAR, the result would only be 2006/08/05 -2006/09/05

   Source: Adapted from community discussion — ZSun

   Next question

7. Question 137 · 358 in bank

   Select 2

   You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.

   

   You need to resolve the error. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AReduce the number of rows and columns returned by each query.
   • BSplit log running queries into subsets of columns and use Power Query to merge the queries.
   • CUse Power Query to combine log running queries into one query.
   • DDisable query folding on long running queries.

   Show answer

   Answer: AB

   Explanation

   A reduces the amount of results that you're getting back, therefore reduces query time, and reduces the chances of a timeout occuring. B basically does the same, and is a solution for when you really need al columns and rows: instead of getting one large table back, you'll get multiple smaller ones, then you can combine those after loading. C does exactly the opposite, making the resulting table even larger. D will not help either, as query folding basically expands on the 'select * from ' that Power BI fires to the database. It can, for instance, add a where-clause to that statement if you're filtering in Power Query. That also reduces query time. Source for query folding: https://learn.microsoft.com/en-us/power-query/power-query-folding

   Source: Adapted from community discussion — semauni

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

8. Question 138 · 358 in bank

   You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

   

   You import the tables. Which relationship should you use to link the tables?

   • Aone-to-many from Transaction to Customer
   • Bone-to-one between Customer and Transaction
   • Cmany-to-many between Customer and Transaction
   • Done-to-many from Customer to Transaction

   Show answer

   Answer: D

   Explanation

   D is the correct answer. Each customer can have multiple transactions (one-to-many relationship), as a customer can make multiple transactions over time.

   Source: Adapted from community discussion — Igetmyrole

   Next question

9. Question 139 · 358 in bank

   You have a query in Power Query Editor that contains the following data.

   

   You need to transform the data to appear as shown in the following table.

   

   What should you do?

   • ASplit the Classes column into rows by using a delimiter.
   • BUnpivot the Classes column.
   • CExtract the text between delimiters in the Classes column.
   • DConvert the Classes column into a list.

   Show answer

   Answer: A

   Next question

10. Question 140 · 358 in bank

    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. From Power Query Editor, you profile the data shown in the following exhibit.

    

    The IoT GUID and IoT ID columns are unique to each row in the query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the IoT DateTime column into a column named Date and a column named Time. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: A

    Explanation

    The correct answer is A. Splitting datetime column will improve the perfomance even if it generates one more column, having less unique values in separated date and time columns will achieve better compression.

    Source: Adapted from community discussion — HemantGorle

    References

    • Microsoft Learn

    Next question

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

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