Microsoft PL-300 Exam (page: 11)
Microsoft Power BI Data Analyst
Updated on: 25-Dec-2025

Viewing Page 11 of 68

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?

  1. Publish the reports in an app and grant the HR managers access permission.
  2. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
  3. Publish the reports to a different workspace other than the one hosting the datasets.
  4. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer(s): A



You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

  1. Viewer
  2. Admin
  3. Contributor
  4. Member

Answer(s): D



You have a Power BI query named Sales that imports the columns shown in the following table.
Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. Remove the rows in which Sales[Status] has a value of Canceled.
  2. Remove Sales[Sales_Date].
  3. Change the data type of Sale[Delivery_Time] to Integer.
  4. Split Sales[Sale_Date] into separate date and time columns.
  5. Remove Sales[Canceled Date].

Answer(s): A,E



You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
You import the tables.
Which relationship should you use to link the tables?

  1. one-to-many from Transaction to Customer
  2. one-to-one between Customer and Transaction
  3. many-to-many between Customer and Transaction
  4. one-to-many from Customer to Transaction

Answer(s): D



You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

  1. From Model view, set the Subject and Body columns to Hidden.
  2. Remove the Subject and Body columns during the import.
  3. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Answer(s): B



Viewing Page 11 of 68



Share your comments for Microsoft PL-300 exam with other users:

sam 7/17/2023 6:22:00 PM

cannot evaluate yet
Anonymous


Gerard 6/29/2023 11:14:00 AM

good so far
Anonymous


Naveed 8/28/2023 2:48:00 AM

good questions with simple explanation
UNITED STATES


adi 10/30/2023 11:51:00 PM

nice data dumps
Anonymous


Isaac 10/28/2023 2:30:00 PM

great case study
UNITED STATES


ciken 8/24/2023 2:55:00 PM

help so much
Anonymous


Sonia 7/23/2023 4:03:00 PM

very helpfull
UNITED STATES


Anon 10/25/2023 10:48:00 PM

some of the answers seem to be inaccurate. q10 for example shouldnt it be an m custom column?
MALAYSIA


Mayur Shermale 11/23/2023 12:22:00 AM

its intresting, i would like to learn more abouth this
JAPAN