PL-300 practice questions 81–90

1. Question 81 · 358 in bank

   HOTSPOT - You have a Power BI semantic model. You need to create a column that will contain year-over-year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue. How should you complete the DAX formula? 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

   

   Next question

2. Question 82 · 358 in bank

   HOTSPOT - You use Microsoft Power BI Desktop to review the data shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. 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 would suggest : 1. Auto Date/Time Auto Date/Time is a Power BI feature that automatically creates a Date Hierarchy (Year, Quarter, Month, Day) when a Date column is present. In the provided screenshot, the Date table has an automatically generated hierarchy, indicating that Auto Date/Time was enabled. Marking a table as a Date table disables Auto Date/Time, removing any automatically generated date hierarchies. 2. The MonthEndDate Date Hierarchy from the Data Table Auto Date/Time was used, removing it will delete automatically created hierarchies (e.g., MonthEndDate Date Hierarchy).

   Source: Adapted from community discussion — Aeffat17

   References

   • Microsoft Learn

   

   Next question

3. Question 83 · 358 in bank

   HOTSPOT - You have a Power BI semantic model that contains two tables named Sales and Forecast. Both tables contain a date column. You need to create a calculated table that will cover the range of dates in both tables. 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.

   

   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

   

   Next question

4. Question 84 · 358 in bank

   You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

   

   Model1 contains the following measure. Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date])) You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual. Which value will appear in the card visual?

   • A10
   • B15
   • C35
   • D60

   Show answer

   Answer: B

   Explanation

   The PREVIOUSYEAR function does not sum all values up to May 9, 2023. Instead, it shifts the filter context to the entire previous year relative to the current filter context. Since the filter context is restricted to May 9, 2024, the PREVIOUSYEAR function shifts the filter to May 9, 2023.

   Source: Adapted from community discussion — 5bf040d

   Next question

5. Question 85 · 358 in bank

   Select 2

   You have a Power BI query named Expenses that imports the following data.

   

   Users only use the date portion of the TransactionDate value when performing data analysis. You need to minimize the model size without affecting the analysis. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AChange the data type of the TransactionDate column to Date.
   • BChange the data type of the PostDate column to Date.
   • CRemove the PostDate column.
   • DRemove the TransactionID column.

   Show answer

   Answer: AC

   Next question

6. Question 86 · 358 in bank

   DRAG DROP - You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables.

   

   The model has the following relationships: ✑ There is a one-to-one relationship between Sales_Region and Region_Manager. ✑ There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. ✑ There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports. 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. 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

   Step 1: Merge [Sales_Region] and [Sales_Manager] by using an inner join. Inner Join: Returns the rows present in both Left and right table only if there is a match. Otherwise, it returns zero records. Note: Sales_Region and Sales_manager There is a one-to-one relationship between Sales_Region and Region_Manager. There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager. Step 2: Merge [Region_Manager] and [Manager] by using inner join. Only managers who are associated to a sales region must be included in the reports. Note: Region_Manager and Manager. There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager. Step 3: Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager] Reference: https://www.tutorialgateway.org/joins-in-power-bi/

   Source: Adapted from community discussion — Nurgul

   

   Next question

7. Question 87 · 358 in bank

   You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

   • AChange any DAX measures to use iterator functions.
   • BEnable visual interactions.
   • CReplace the default visuals with AppSource visuals.
   • DSplit the visuals onto multiple pages.

   Show answer

   Answer: D

   Explanation

   D is the correct answer. Because our report page contains a large number of visuals (both default and AppSource visuals) and users are experiencing slow load times, splitting the visuals onto multiple pages can help. This way, each page loads a subset of visuals, reducing the initial load time and improving the overall performance of the report. Users can navigate between pages to access different sets of visuals.

   Source: Adapted from community discussion — Igetmyrole

   Next question

8. Question 88 · 358 in bank

   HOTSPOT - You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

   

   The related dimension tables are imported into the model. Sales contains the data shown in the following table.

   

   You are evaluating how to optimize the model. 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 - Those two columns not need in the analysis. Box 2: No - Can remove the surrogate key OrderDateKey from the analysis. Box 3: No - Tax charged not relevant for the analysis.

   Source: Adapted from community discussion — cnmc

   

   Next question

9. Question 89 · 358 in bank

   You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 - If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

   • AThe user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.
   • BThe user will receive an error and will not be able to see the data in the report.
   • CThe user will only see data for which the State Province value is Kentucky.
   • DThe user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

   Show answer

   Answer: A

   Explanation

   Answer should be A, from the Microsoft documentation (https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance): "When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters." This means that you would see all data where either Role1 OR Role2 applies, so the answer is A not D.

   Source: Adapted from community discussion — ThariCD

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 90 · 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. You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table. Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: B

    Explanation

    A, should be correct. We have concept of Query Folding. If we apply the steps and it can be converted to Native Query then it will execute as is. By development process it might mean by building Power BI Report, the view might be production view and as it is having 100 Million record. We cannot update the view for Power BI development.

    Source: Adapted from community discussion — BiLearn

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Next question

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

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