Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 1:

  DRAG DROP

  You have a Microsoft Power BI workspace.

  You need to grant the user capabilities shown in the following table.

  

  The solution must use the principle of least privilege.

  Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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:

  

  

  ---

  Box 1: Member

  

  Incorrect Answers:

  Contributors can update the app metadata but not publish a new app or change who has permission to the app.

  Box 2: Contributor

  

  https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

• Question 2:

  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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have several reports and dashboards in a workspace.

  You need to grant all organizational users read access to a dashboard and several reports.

  Solution: You publish an app to the entire organization.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-apps

• Question 3:

  HOTSPOT

  You have a Fabric workspace that contains the items shown in the following table.

  

  You need to make content available to the management department and the accounting department at your company.

  The solution must meet the following requirements:

  1. The management department must have view access to the Headcount and Department Expenses reports.

  2. The management department must NOT be able to view any other current or future reports.

  3. The management department must NOT be able to build new reports by using the semantic models.

  4. The accounting department must only be able to view the Company Expenses report.

  5. The accounting department must be able to build new reports by using the Expenses semantic model.

  The solution must follow the principle of least privilege and minimize administrative effort.

  How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area.

  NOTE: Each collect selection is worth one point.

  

  

• Question 4:

  You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend.

  You need to include a visual that identifies which fields have the greatest impact on Spend.

  Which type of visual should you use?

  A. decomposition tree
  B. Q&A
  C. smart narrative
  D. key influences
  D. key influences

• Question 5:

  You have a Power B1 report that contains the visuals shown in the following table.

  

  You need to modify the location of each visual.

  What should you modify for each visual?

  A. the layer order
  B. the padding
  C. the position
  D. the tab order
  C. the position

• Question 6:

  DRAG DROP

  You are building a dataset from a JSON file that contains an array of documents.

  You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

  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.

  Select and Place:

  

  

  ---

  1- Convert list to table

  2- Expand Column

  3- Set Date type Here is an example:

  https://youtu.be/B4kzyxnhQfI

  The definition of the function which expand columns:

  https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

• Question 7:

  You have a Fabric tenant that hosts the semantic models shown in the following table.

  

  The auto date/time option or the model is enabled.

  You need to reduce the size of the model while maintaining the ability to analyze product sales by month and quarter.

  Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one pent.

  A. Create a Rate table and select Mark as Date Table.
  B. Disable the auto date/time option.
  C. Remove the relationship between the Product table and the Sales table.
  D. Disable the load on the Date table.
  E. Create a relationship between the Date table and the Sales table.
  B. Disable the auto date/time option.
  E. Create a relationship between the Date table and the Sales table.

• Question 8:

  You need to provide a solution to provide the sales managers with the required access.

  What should you include in the solution?

  A. Create a security role that has a table filter on the Sales Manager table where username = UserName().
  B. Create a security role that has a table filter on the Sales Manager table where username = sales_manager_id.
  C. Create a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName().
  D. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
  A. Create a security role that has a table filter on the Sales Manager table where username = UserName().

  ---

  Explanation

  Scenario: The region_id column can be managed by only one sales manager.

  You can use Username() or userprincipalname() in DAX with Row-Level Security.

  Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected].

  Incorrect Answers:

  B: sales_manager_id is an integer and cannot be converted to a string datatype.

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 9:

  HOTSPOT

  You are designing the data model for a Power BI semantic model.

  You have the following tables in the star schema.

  

  Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 10:

  You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.

  You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.

  Which report setting should you configure?

  A. Don't allow end user to save filters on this report.
  B. Change default visual interaction from cross highlighting to cross filtering.
  C. Enable the updated filter pane, and show filters in the visual header for this report.
  D. Allow users to add comments to this report.
  E. Choose the type of data you allow your end users to export.
  E. Choose the type of data you allow your end users to export.

  ---

  Explanation

  https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/