CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Free PL-300 Exam Braindumps (page: 14)

Page 13 of 85
PDF with 356 Questions

You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements:
• The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.
• The orders must be filtered to the selected CustomerID value.
• Users must select the CustomerID value from a list.
• The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. an Orders query that has a filter on CustomerID
  2. a Customers query that has a filter on CustomerID
  3. an Orders query that has a single column containing a list of customers
  4. a Customers query that has a single column containing a list of customer IDs
  5. a parameter for CustomerID that uses a query to populate the suggested values
  6. a parameter for CustomerID that uses manually entered values to populate the suggested values

Answer(s): A,D,E



You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

  1. In the report, add a DAX calculated column that calculates the length of col1
  2. In the report, add a DAX function that calculates the average length of col1
  3. From Power Query Editor, add a column that calculates the length of col1
  4. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Answer(s): D



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






Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

PL-300 Exam Discussions & Posts