PL-300 practice questions 341–350

1. Question 341 · 358 in bank

   Select 2

   You have a Power BI report named Report1. You plan to share Report1 with multiple users. You need to add the users to a group. Which two types of groups can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Asecurity group
   • Bdistribution group
   • CMicrosoft Teams team
   • DMicrosoft 365 group

   Show answer

   Answer: AD

   Explanation

   To share a Power BI report named Report1 with multiple users by adding them to a group, you can use the following types of groups: A. Security group D. Microsoft 365 group Both security groups and Microsoft 365 groups can be used to manage access to Power BI reports. Security groups are typically used for managing permissions and access control, while Microsoft 365 groups provide a collaborative workspace with shared resources, including access to Power BI reports. Distribution groups and Microsoft Teams teams are not typically used for managing access to Power BI reports in this context.

   Source: Adapted from community discussion — MANANDAVEY

   Next question

2. Question 342 · 358 in bank

   You need to create the dataset. Which dataset mode should you use?

   • AImport
   • BDirectQuery
   • CComposite
   • Dlive connection

   Show answer

   Answer: C

   Explanation

   Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly. In this case, Composite fits perfect. Source1 is 2GB, which is relatively too large for daily updates and way larger than Source2 which is only 5MB.

   Source: Adapted from community discussion — shakes103

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 343 · 358 in bank

   You need to configure access for the sales department users. The solution must the meet the security requirements. What should you do?

   • AShare each report to the Azure Active Directory group of the sales department.
   • BAdd the Azure Active Directory group of the sales department as an Admin of the reports workspace.
   • CDistribute an app to the users in the Azure Active Directory group of the sales department.
   • DAdd the sales department as a member of the reports workspace.

   Show answer

   Answer: C

   Explanation

   The answer is C. It's a trick question. It asks how the access for the sales department USERS needs to be set up. This requires RLS to work, and RLS won't work when they are member or admin. The requirements listed that require admin rights refer to the sales DEPARTMENT, not to the sales USERS.

   Source: Adapted from community discussion — ItsMeScripting

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 344 · 358 in bank

   HOTSPOT - You need to create a solution to meet the notification requirements of the warehouse shipping department. 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: dashboard - The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%. You can set alerts to notify you when data in your dashboards changes beyond limits you set. Box 2: data alert - Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

   Source: Adapted from community discussion — zvm

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 345 · 358 in bank

   You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

   • AOne to one
   • BMany to many
   • CMany to one
   • DOne to many

   Show answer

   Answer: D

   Explanation

   Please does anyone knows how to quickly understand the requirement of a case study. It is too long for me. I guess there is way around understanding it. Thank you!

   Source: Adapted from community discussion — Heshybay

   Next question

6. Question 346 · 358 in bank

   HOTSPOT - You need to create a measure that returns the percent of revenue by product category. How should you complete the measure? 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> [, ג€¦]]]) Box 2: REMOVEFILTERS - REMOVEFILTERS clear filters from the specified tables or columns. Box 3: DIVIDE - DIVIDE performs a division. Example: MEASURE FactInternetSales[%Sales] = DIVIDE([TotalSales], CALCULATE([TotalSales],REMOVEFILTERS())) Note: The RETURN keyword consumes variables defined in previous VAR statements. Reference: https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/removefilters-function-dax https://dax.guide/st/return/

   Source: Adapted from community discussion — ThariCD

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 347 · 358 in bank

   DRAG DROP - Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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

   Step 1: From BI Desktop, create four roles You can define roles and rules within Power BI Desktop. Step 2: From BI Desktop, add a Table Filter DAX Expression to the roles. To define security roles, follow these steps. 1. From the Modeling tab, select Manage Roles. 2. Select Manage Roles 3. From the Manage roles window, select Create. 4. Select Create 5. Under Roles, provide a name for the role. 6. Under Tables, select the table to which you want to apply a DAX rule. 7. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ג€Valueג€. After you've created the DAX expression, select the checkmark above the expression box to validate the expression. 8. Select Save. Step 3: From powerbi.com, add role members to the roles. You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. Step 4: From BI Desktop, publish the dataset to powerbi.com Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

   Source: Adapted from community discussion — fdsdfgxcvbdsfhshfg

   References

   • Microsoft Learn

   

   Next question

8. Question 348 · 358 in bank

   Which DAX expression should you use to get the ending balances in the balance sheet reports?

   • ACALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( 'Date'[Date] ) )
   • BCALCULATE ( SUM( BalanceSheet[BalanceAmount] ), DATESQTD('Date'[Date]) )
   • CFIRSTNONBLANK ('Date'[Date] SUM( BalanceSheet[BalanceAmount] ) )
   • DCALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE ('Date'[Date] ))

   Show answer

   Answer: A

   Explanation

   Balance is a semi-additive measure! It is summed by other dimensions but not over time. LASTDATE() returns the last date of the filtered period and that represents exactly what we need: the balance of the month if a month is filtered, the balance of the quarter if a quarter is filtered, and so on. SQLBI has a good example here: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/

   Source: Adapted from community discussion — fred92

   References

   • Microsoft Learn

   Next question

9. Question 349 · 358 in bank

   You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

   • Aa one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
   • Ba one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
   • Can additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
   • Dan additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]

   Show answer

   Answer: D

   Explanation

   GUYS ATTENTION! There were 6-7 new questions, one of them I remember was: Do you have a power BI Report Visual (foto of a visual dashboard report) What can you do to make it color user friendly for visual defficiency? Choose 2 options, options: Sentiment colors, Theme colors, Divergent colors, First-level colors. My answers were: Theme colors and divergent colors. Good luck!

   Source: Adapted from community discussion — DataEngDP

   Next question

10. Question 350 · 358 in bank

    You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

    • ACreate a security role that has a table filter on the Sales Manager table where username = UserName().
    • BCreate a security role that has a table filter on the Sales Manager table where username = sales_manager_id.
    • CCreate a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName().
    • DCreate a security role that has a table filter on the Sales_Manager table where name = UserName().

    Show answer

    Answer: A

    Explanation

    GUYS ATTENTION! There were 6-7 new questions, one of them I remember was: Do you have a power BI Report Visual (foto of a visual dashboard report) What can you do to make it color user friendly for visual defficiency? Choose 2 options, options: Sentiment colors, Theme colors, Divergent colors, First-level colors. My answers were: Theme colors and divergent colors. Good luck!

    Source: Adapted from community discussion — DataEngDP

    Next question

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

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