PL-300 practice questions 331–340

1. Question 331 · 358 in bank

   You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report. The solution must prevent other reports from being affected. What should you do?

   • AClear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.
   • BApply row-level security (RLS) to the shared dataset.
   • CSelect the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.
   • DSelect the Don't allow end users to export any data from the service or Report Server Export data option for the report.

   Show answer

   Answer: D

   Explanation

   To set this options: in Power BI Desktop -> File -> Options and Settings -> Options Current File -> Report Settings There you'll find "Export data" section and 3 options. The last one is "Don't allow end users to export any data from the service or Report server" In PBI service, you can also allow or forbid to export data, but there the only option to prevent data from beeing exportet is "None".

   Source: Adapted from community discussion — fred92

   Next question

2. Question 332 · 358 in bank

   You have a Power BI workspace named Workspace1 and a group named Group1. You need to ensure that the members of Group1 are notified when there are issues in Workspace1. The solution must follow the principle of least privilege. What should you do?

   • AAssign Group1 the Admin role.
   • BUpdate the contact list to include Group1.
   • CAssign Group1 the Contributor role for Workspace1.
   • DAssign Group1 the Member role for Workspace1.

   Show answer

   Answer: B

   Explanation

   Answer: B. Update the contact list to include Group1. By adding Group1 to the workspace contact list, you ensure that they receive notifications about issues (like refresh failures) without giving them unnecessary privileges in the workspace. This follows the principle of least privilege because the group is only being notified; they are not granted extra permissions (such as Contributor, Member, or Admin) unless required.

   Source: Adapted from community discussion — HUSSAIN_ALYAFEI

   Next question

3. Question 333 · 358 in bank

   You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

   • AChange the data type of Sales[region_id] to Whole Number.
   • BChange the data type of Sales[region_id] to Decimal Number.
   • CIn the Sales table, add a measure for Sum(sales_amount).
   • DChange the data type of Sales[sales_id] to Text.

   Show answer

   Answer: A

   Explanation

   A. Change the data type of Sales[region_id] to Whole Number. is correct, because the data type is INTEGER in Sales Region, Region_Manager and Targets.

   Source: Adapted from community discussion — Booster21

   Next question

4. Question 334 · 358 in bank

   You create a Power BI workspace named Workspace1. You publish a semantic model and a report to Workspace1. You need to configure Workspace1 to meet the following requirements: • Provide access to a group named Sales. • Ensure that Sales can invite other users to Workspace1. • Follow the principle of least privilege. Which role should you assign to Sales?

   • AContributor
   • BMember
   • CAdmin
   • DViewer

   Show answer

   Answer: B

   Explanation

   The correct answer is member, but also note that the next least privilege to view is not member it is contributor Admin Full control (manage access, content, and settings). More permissions than needed. Member Can invite users, edit and create content, and publish apps. Meets all requirements. Contributor Can edit and create content but cannot invite users. Viewer View-only access; cannot invite users or edit content.

   Source: Adapted from community discussion — f133b89

   Next question

5. Question 335 · 358 in bank

   You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection?

   • AImport that uses a Microsoft account
   • BImport that uses a database credential
   • CDirectQuery that uses a database credential
   • DDirectQuery that uses the end-user's credentials

   Show answer

   Answer: C

   Explanation

   I think it should be: C. DirectQuery that uses a database credential If you used the credentials of the user (D) then all users would need to be created in the database.

   Source: Adapted from community discussion — Mizaan

   References

   • Microsoft Learn

   Next question

6. Question 336 · 358 in bank

   You are creating a new semantic model in Microsoft Power BI Desktop. You connect to a recently used data source and receive an error message indicating that the password is expired. You need to update the credentials for the data source. What should you do?

   • AFrom Data Source settings, select the data source, and then select Edit Permissions.
   • BFrom Options, select Data Load, and then select Clear Cache.
   • CFrom Power Query Editor, select Refresh Preview.
   • DFrom the Modeling tab, select Manage Roles, and then add a role.

   Show answer

   Answer: A

   Next question

7. Question 337 · 358 in bank

   You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source. You attempt to refresh the data and receive the following error message. Expression.Error: The column ‘Cost’ of the table wasn't found. What is a possible cause of the error?

   • AThe Cost column was renamed in the data source.
   • BThe privacy level of the data source does not allow combining the data with other data sources.
   • CThe data in the Cost column cannot be converted into the target data type.
   • DThe source file was moved to a new location.

   Show answer

   Answer: A

   Next question

8. Question 338 · 358 in bank

   You have a Power BI tenant that contains a workspace named WS1. WS1 contains the following items: • A semantic model named SM1. • A report named RPT1 that is connected to SM1. • A report named RPT2 that is connected to SM1. • A report named RPT3 that is connected to SM1. • A dashboard named DB1 that contains content from RPT1 and RPT2. You need to grant workspace access to a group named Group1. The solution must meet the following requirements: • Group1 must be able to view RPT1, RPT2, and DB1. • Group1 must be prevented from viewing RPT3. • Group1 must be prevented from creating new reports and dashboards by using SM1. • Group1 must be prevented from sharing the reports and dashboards to other users. • Administrative effort must be minimized. What should you do?

   • APublish an app.
   • BAssign Group1 the Viewer role for WS1.
   • CStore PBIX files in a shared folder in Microsoft OneDrive.
   • DShare each item individually.

   Show answer

   Answer: A

   Explanation

   ✅ A. Publish an app. Explanation: Publishing an app in Power BI allows you to control which reports and dashboards are accessible to a specific audience while keeping administrative effort minimal. This approach meets all the given requirements: ✅ Group1 can view RPT1, RPT2, and DB1 (you can include only these reports in the app). ✅ Group1 is prevented from viewing RPT3 (since RPT3 will not be included in the app). ✅ Group1 cannot create new reports or dashboards using SM1 (viewers of the app cannot modify the dataset). ✅ Group1 cannot share reports and dashboards (app viewers cannot share content). ✅ Minimal administrative effort (you only need to manage access to the app instead of configuring individual report permissions).

   Source: Adapted from community discussion — MANANDAVEY

   Next question

9. Question 339 · 358 in bank

   HOTSPOT - You have a Power BI semantic model named Model1 that will be used to support reports viewed in the Power BI service. Model1 contains data from the following sources: • An Azure SQL database that is accessible only via a private endpoint • A Microsoft Excel file stored in Microsoft SharePoint Online • A Microsoft SQL Server database in a private datacenter You need to publish Model1 and schedule the model to refresh 12 times a day. How many data sources require a data gateway, and which license mode will the workspace require to support the scheduled refresh? 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

10. Question 340 · 358 in bank

    DRAG DROP - You have a Power BI semantic model. You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions. 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.

    

    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

    Correct Sequence: 1. From Microsoft Power BI Desktop, create a new RLS role by using a DAX filter. • You must first define the RLS roles and the corresponding DAX filters in Power BI Desktop to determine how data is restricted for different users. 2. Publish the semantic model. • After creating the RLS roles, you need to publish the semantic model to the Power BI Service to apply these roles in the cloud environment. 3. From the Power BI service, assign the new RLS role to the users. • Once the model is published, you assign the roles to specific users or groups in the Power BI Service to enforce RLS.

    Source: Adapted from community discussion — b2775a4

    

    Next question

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

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