PL-300 practice questions 311–320

1. Question 311 · 358 in bank

   You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network. You plan to publish the report to the Power BI Service. What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

   • Aan OData feed
   • Ban On-premises data gateway
   • Ca subscription
   • Da scheduled refresh of the dataset

   Show answer

   Answer: B

   Explanation

   My answer here is D. The gateway is required when publishing if the plan is to publish the report. You cannot publish a report that uses an SSAS as a datasource. But that is not the question to answer here. The question is "What should you implement to ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?" and you need to schedule a refresh in order to get the most up-to-date data from the cube.

   Source: Adapted from community discussion — CookieMingkee

   References

   • Microsoft Learn

   Next question

2. Question 312 · 358 in bank

   You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region. You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?

   • AUse the Test as role option to view data as the salesperson's user account.
   • BUse the Test as role option to view data as the Sales role.
   • CInstruct the salesperson to open the report in Microsoft Power BI Desktop.
   • DFilter the data in the reports to match the intended logic in the filter on the sales transaction table.

   Show answer

   Answer: A

   Explanation

   Answer should be A, to be able to see what the specific salesperson sees (and compare it to what she should see) you should test the report as that user account since the RLS is dynamic and based on the user accounts.

   Source: Adapted from community discussion — ThariCD

   References

   • Microsoft Learn

   Next question

3. Question 313 · 358 in bank

   You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

   • AMicrosoft Information Protection sensitivity labels
   • Btiles
   • Ccomments
   • DActive Directory groups

   Show answer

   Answer: A

   Next question

4. Question 314 · 358 in bank

   HOTSPOT - You have a dataset that has the permissions 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. 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: use Analyze in Excel - Build permission applies to datasets. When you give users Build permission, they can build new content on your dataset, such as reports, dashboards, pinned tiles from Q&A, paginated reports, and Insights Discovery. Users also need Build permissions to work with the data outside Power BI: To export the underlying data. To build new content on the dataset such as with Analyze in Excel. To access the data via the XMLA endpoint. Box 2: grant the Read permission for The Corp group has read, share and rebuild permissions. As a property of the Power BI App, you can allow users to share the app and underlying dataset with share permissions. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions https://data-marc.com/2021/07/30/transform-a-local-into-a-global-power-bi-solution-request-access-to-content/

   Source: Adapted from community discussion — fred92

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 315 · 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 have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Explanation

   This should be A. Yes, from the documentation a suggestion made there to share with more than 100 separate users is to "Share with a user group that contains all the users."

   Source: Adapted from community discussion — ThariCD

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 316 · 358 in bank

   DRAG DROP - You have a Power BI table named Customer that contains a field named Email Address. You discover that multiple records contain the same email address. You need to create a calculated column to identify which records have duplicate email addresses. How should you complete the DAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. 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

   You are to count the number of rows having same email address. 1. Declare a variable and call it any name you prefer 2. Calculate the row count on the table 3. Apply filter to ALL of the values in the table under the column name email address and equate it to the variable. You may need to read up filter functions for a proper understanding of how it works.

   Source: Adapted from community discussion — iccent2

   

   Next question

7. Question 317 · 358 in bank

   You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the users the Build permission for the dataset. What should you do next?

   • ACertify the dataset used by the report.
   • BChange the default visual interaction for the report.
   • CFor the report, change the Export data setting to None.
   • DFor the report, change the Export data setting to Summarized data, data with current layout and underlying data.

   Show answer

   Answer: C

   Explanation

   C is the correct answer. Note the part of the question that says "ONLY by connecting directly to the dataset." As mentioned in https://www.designmind.com/blog/business-intelligence/export-underlying-data-in-power-bi, "You should export summarized data when you want to see the relevant data in the visualization." Therefore, D cannot be the right answer, as summarized data is not obtained from connecting directly to the dataset, but rather by effectively filtering the dataset based on the contents of the visualization. Additionally, the "data with current layout and underlying data" part is irrelevant - by allowing Summarized data to be exported, we allow forms of analyzing data other than connecting directly to the dataset, and thus fail the requirements of the question.

   Source: Adapted from community discussion — glenman0202

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

8. Question 318 · 358 in bank

   You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

   • AUpload the Excel file to a Power BI workspace.
   • BCreate a subscription to the report.
   • CDeploy an on-premises data gateway.
   • DEdit the data source credentials.

   Show answer

   Answer: C

   Explanation

   For on-premises data sources we need a data gateway. We have a Microsoft Excel file on a file server, so the answer is C.

   Source: Adapted from community discussion — dorypl300

   Next question

9. Question 319 · 358 in bank

   HOTSPOT - You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements: • Create reports that use the HR dataset. • Publish the reports to WorkspaceB. • Prevent the ability to modify the HR dataset. • Prevent the ability to add users to Workspaces. What should you do? 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

   Answer is correct. To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. You also need at least the Contributor role on the source and destination workspaces. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role.

   Source: Adapted from community discussion — Shalaleh

   References

   • Microsoft Learn

   

   Next question

10. Question 320 · 358 in bank

    Select 2

    You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the BI Finance dataset, but you do NOT have permissions for the workspace. You need to connect to BI Finance and create a report. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

    • AFrom the Power BI service, create a dataflow to the dataset by using DirectQuery.
    • BFrom Power BI Desktop, connect to a Dataverse data source.
    • CFrom the Power BI service, create a new report and select a published dataset.
    • DFrom Power BI Desktop, connect to a shared dataset.

    Show answer

    Answer: CD

    Explanation

    C. From the Power BI service, create a new report and select a published dataset. With Build permission on the dataset, you can create a new report in the Power BI service and select the BI Finance dataset as the basis for your report. D. From Power BI Desktop, connect to a shared dataset. You can also use Power BI Desktop to connect to the BI Finance dataset if it's shared. The Build permission enables you to use the dataset to create new content in Power BI Desktop.

    Source: Adapted from community discussion — Dsbuff

    Next question

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

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