PL-300 practice questions 351–358

1. Question 351 · 358 in bank

   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?

   • ACreate a DAX calculated column that retrieves the region manager from the Weekly_Returns table based on the sales_region_id column.
   • BApply row-level security (RLS) to the Region table based on the sales manager username.
   • CConfigure a bi-directional relationship between Region and Sales_Region.
   • DIn the Region table, create a hierarchy that has the manager name, and then the sales manager name.

   Show answer

   Answer: D

   Explanation

   D seems to be correct because the Executives will only be able to see Region managers and Sales managers that report to them in a hierarchy, besides there is nothing to measure there so A is actually wrong

   Source: Adapted from community discussion — Ebenanatalo

   Next question

2. Question 352 · 358 in bank

   What should you do to address the existing environment data concerns?

   • Aa calculated column that uses the following formula: ABS(Sales[sales_amount])
   • Ba measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
   • Ca measure that uses the following formula: SUM(Sales[sales_amount])
   • Da calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

   Show answer

   Answer: B

   Explanation

   The error in the formula for B it's probably just a typo. D option would work on the missing values, but not with the negative values

   Source: Adapted from community discussion — nmosq

   Next question

3. Question 353 · 358 in bank

   You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

   • AFORMAT('Date'[date],"MMM YYYY")
   • BFORMAT('Date'[date_id],"MMM") & " " & FORMAT('Date'[year], "#")
   • CFORMAT('Date'[date_id],"MMM YYYY")
   • DFORMAT('Date'[date],"M YY")

   Show answer

   Answer: A

   Explanation

   What is confusing here is the fact that there is a date_id defined in the format yyyymmdd. Therefore, some people would tend to select C. However, I do not quite understand why this info is even given to us. I would have expected this field ID to be... an ID, not a date?

   Source: Adapted from community discussion — NuriaIzard

   Next question

4. Question 354 · 358 in bank

   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 statements, select Yes if the statement is true. Otherwise, select No. 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: Yes - Need to link the tables for: 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: No - It should be set to Integer. Box 3: No - Can use the Region field of the Customer Details table. The Orders table only has the ShipRegion field

   Source: Adapted from community discussion — ThariCD

   

   Next question

5. Question 355 · 358 in bank

   HOTSPOT - You need to create a measure that will return the percentage of late orders. How should you complete the DAX expression? 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: CALCULATE - CALCULATE evaluates an expression in a modified filter context. Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ג€¦]]]) expression - The expression to be evaluated. filter1, filter2,.. - (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions. Incorrect: * COUNTX - Counts the number of rows that contain a non-blank value or an expression that evaluates to a non-blank value, when evaluating an expression over a table. * CALCULATETABLE evaluates a table expression in a modified filter context. Syntax: CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, ג€¦]]]) Expression - The table expression to be evaluated. Box 2: FILTER - FILTER returns a table that represents a subset of another table or expression. Syntax: FILTER(<table>,<filter>) Box 3: Orders[ShippedDate] > Orders[RequiredDate] Northwind Traders defines late orders as those shipped after the required shipping date. Reference: https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/filter-function-dax

   

   Next question

6. Question 356 · 358 in bank

   You need to minimize the size of the dataset. The solution must meet the report requirements. What should you do?

   • AGroup the Categories table by the CategoryID column.
   • BRemove the QuantityPerUnit column from the Products table.
   • CFilter out discontinued products while importing the Products table.
   • DChange the OrderID column in the Orders table to the Text data type.

   Show answer

   Answer: B

   Explanation

   B is correct. QuantityPerUnit column from the Products table is not necessary for the analysis. Discontinued products may not be filtered out because OrderDetails can still have foreign key referencing to them (historical data must be kept).

   Source: Adapted from community discussion — Hoeishetmogelijk

   Next question

7. Question 357 · 358 in bank

   You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

   • AFrom Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
   • BFrom Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
   • CFrom Power BI Desktop, use the Auto date/time option when creating the reports.
   • DFrom Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

   Show answer

   Answer: A

   Explanation

   Auto date/time does not meet the criteria: The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements. The correct answer is A

   Source: Adapted from community discussion — fdsdfgxcvbdsfhshfg

   Next question

8. Question 358 · 358 in bank

   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:

   

   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: many-to-many - Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table. With composite models, you can establish a many-to-many relationship between tables, which removes requirements for unique values in tables. It also removes previous workarounds, such as introducing new tables only to establish relationships. Box 2: Orders table - The Orders table has a ShipRegion column. Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

   Source: Adapted from community discussion — Fer079

   

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

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