PL-300 practice questions 91–100

1. Question 91 · 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: You write a DAX expression that uses the FILTER function. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Also, common sense, we are trying to import a sample of the data meaning that the data is not yet on Power BI, so where are we going to filter with DAX? On the SQL server? That is not possible hence the answer B is correct.

   Source: Adapted from community discussion — iccent2

   Next question

2. Question 92 · 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: You add a WHERE clause to the SQL statement. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   In my opinion the goal can only be met if you for example know the Id of an item and then filter for this. So the goal can be met but it an ugly solution.

   Source: Adapted from community discussion — rashjan

   Next question

3. Question 93 · 358 in bank

   DRAG DROP - You are preparing a financial report in Power BI. You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

   

   You need to prepare the data to support the following: ✑ Visualizations that include all measures in the data over time ✑ Year-over-year calculations for all the measures Which four 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-query/unpivot-column

   Source: Adapted from community discussion — ThariCD

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

4. Question 94 · 358 in bank

   You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

   • APublish the reports in an app and grant the HR managers access permission.
   • BCreate a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
   • CPublish the reports to a different workspace other than the one hosting the datasets.
   • DAdd the HR managers as members of the existing workspace that hosts the reports and the datasets.

   Show answer

   Answer: A

   Explanation

   Option A (Publish the reports in an app and grant the HR managers access permission) would be the best option to provide the HR managers with access to the reports while restricting them from modifying the layout. By publishing the reports in an app and granting the HR managers access permission, you can assign them specific roles and permissions that restrict their access to the underlying data while allowing them to view and interact with the reports. The RLS configuration can be set up to ensure that the HR managers can only see data from their own sales region.

   Source: Adapted from community discussion — RazaTheLegend

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 95 · 358 in bank

   HOTSPOT - You are creating an analytics report that will consume data from the tables shown in the following table.

   

   There is a relationship between the tables. There are no reporting requirements on employee_id and employee_photo. You need to optimize the data model. What should you configure for employee_id and employee_photo? 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: Hide - Need in the relation, so cannot delete it. Box 2: Delete - Reference: https://community.powerbi.com/t5/Desktop/How-to-Hide-a-Column-in-power-Bi/m-p/414470

   Source: Adapted from community discussion — MayurV19

   

   Next question

6. Question 96 · 358 in bank

   HOTSPOT - You plan to create Power BI dataset to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL database. View1 contains the columns shown in the following table.

   

   View2 contains the columns shown in the following table.

   

   The views can be related based on the Class ID column. Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID. You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis: ✑ The count of classes that occur by period ✑ The count of students in attendance by period by day ✑ The average number of students attending a class each month In which table should you include the Teacher First Name and Period Number fields? 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: Teacher fact - Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns. Note: Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact. Box 2: Attendance fact - Incorrect: ג€" Dimension tables describe business entities the things you model. Entities can include products, people, places, and concepts including time itself. The most consistent table you'll find in a star schema is a date dimension table. A dimension table contains a key column (or columns) that acts as a unique identifier, and descriptive columns. Reference: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

   Source: Adapted from community discussion — Hoeishetmogelijk

   

   Next question

7. Question 97 · 358 in bank

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

   

   There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do?

   • ACreate a slicer that filters Departments based on DepartmentID.
   • BCreate a row-level security (RLS) role for each department, and then define the membership of the role.
   • CCreate a DepartmentID parameter to filter the Departments table.
   • DTo the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.

   Show answer

   Answer: B

   Explanation

   B is the correct answer. To ensure that users can see the data of their respective department only, we should implement low-level security (RLS). Here is how it works: - Create a separate RLS role for each department. - Define the membership of each role by specifying which DepartmentID(s) each role can access. - Assign users to the appropriate RLS role based on their department affiliation. This way, each user will only be able to see data related to their respective department, as per the RLS rules you define.

   Source: Adapted from community discussion — Igetmyrole

   Next question

8. Question 98 · 358 in bank

   In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured. You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings. What should you do?

   • ACreate an inactive relationship between the tables and select Apply security filter in both directions.
   • BCreate an active relationship between the tables and select Apply security filter in both directions.
   • CCreate an inactive relationship between the tables and select Assume referential integrity.
   • DCreate an active relationship between the tables and select Assume referential integrity.

   Show answer

   Answer: B

   Explanation

   I passed the exam today (948/1000). My answer was: - Create an active relationship between the tables and select Apply security filter in both directions

   Source: Adapted from community discussion — SamuComqi

   Next question

9. Question 99 · 358 in bank

   HOTSPOT - You have a column named UnitsInStock as shown in the following exhibit.

   

   UnitsInStock has 75 non-null values, of which 51 are unique. 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. 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: 75 rows - Is nullable allows NULL values in the column. Box 2: reduce - Reference: https://blog.crossjoin.co.uk/2019/01/20/is-nullable-column-property-power-bi/

   Source: Adapted from community discussion — ThariCD

   

   Next question

10. Question 100 · 358 in bank

    HOTSPOT - You have a Power BI report. You have the following tables.

    

    You have the following DAX measure. Accounts := CALCULATE ( DISTINCTCOUNT (Balances[AccountID]), LASTDATE ('Date'[Date]) 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: No - It will show the total number of accounts that were live at the last day of the year only. Note: DISTINCTCOUNT counts the number of distinct values in a column. LASTDATE returns the last date in the current context for the specified column of dates. Box 2: No - It will show the total number of accounts that were live at the last day of the month only. Box 3: Yes - Reference: https://docs.microsoft.com/en-us/dax/distinctcount-function-dax https://docs.microsoft.com/en-us/dax/lastdate-function-dax

    Source: Adapted from community discussion — shakes103

    References

    • Microsoft Learn

    

    Next question

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

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