Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 111:

  You have a Power BI semantic model named Model1 that runs in Import storage mode.

  You need to reduce the size of Model1.

  Which two actions should you perform? (Choose two)

  Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. Upgrade to Power BI premium.
  B. Implement row-level security (RLS).
  C. Optimize the column data types.
  D. Change the active relationships between tables to inactive relationships.
  E. Summarize the detail data.
  C. Optimize the column data types.
  E. Summarize the detail data.

• Question 112:

  HOTSPOT

  You have a Power Bl semantic model that contains a table named Opportunity.

  The Opportunity table contains a column named Qualification

  The Qualification column contains values between 0 and V

  You need to build a new measure to score the opportunities on a scale of low, medium, and high.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 113:

  You are creating a new semantic model in Microsoft Power Bl 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?

  A. From the Modeling tab, select Manage Roles, and then add a role.
  B. From Options, select Data Load, and then select Clear Cache.
  C. From Power Query Editor, select Refresh Preview.
  D. From Data Source settings, select the data source, and then select Edit Permissions.
  D. From Data Source settings, select the data source, and then select Edit Permissions.

• Question 114:

  A user creates a Power B1 report named ReportA that uses a custom theme

  You create a dashboard named DashboardA.

  You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. From DashboardA upload a JSON theme.
  B. Publish ReportA to the Microsoft Power B1 Community theme gallery.
  C. From DashboardA create a custom theme.
  D. From ReportA save the current theme.
  E. Publish ReportA to Power Bl.
  A. From DashboardA upload a JSON theme.
  D. From ReportA save the current theme.

• Question 115:

  HOTSPOT

  You open powerbi.com as 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.

  

  

  ---

  References:

  https://docs.microsoft.com/en-us/power-bi/service-data-classification

• Question 116:

  You have a line chart that shows the number of employees in a department over time.

  You need to see the total salary costs of the employees when you hover over a data point.

  What is possible way to achieve this goal?

  A. Add a salary to the tooltips.
  B. Add a salary to the visual filters.
  C. Add salary to the drillthrough fields.
  A. Add a salary to the tooltips.

  ---

  Explanation

  Customize tooltips with aggregation or quick measures

  You can customize a tooltip by selecting an aggregation function.

  Select the arrow beside the field in the Tooltips bucket. Then, select from the available options.

  

  Note: Tooltips are an elegant way of providing more contextual information and detail to data points on a visual. You can customize tooltips in Power BI Desktop and in the Power BI service.

  When a visualization is created, the default tooltip displays the data point's value and category.

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips

• Question 117:

  DRAG DROP

  You have a 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 tie answer area and arrange them in the correct order.

  Select and Place:

  

  

• Question 118:

  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?

  A. Use the Test as role option to view data as the salesperson's user account.
  B. Use the Test as role option to view data as the Sales role.
  C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
  D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
  A. Use the Test as role option to view data as the salesperson's user account.

  ---

  Explanation

  Validate the roles within Power BI Desktop

  After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.

  

  The View as roles window appears, where you see the roles you've created.

  

  Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.

  You can also select Other user and supply a given user.

  Select OK.The report renders based on what that user can see.

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

• Question 119:

  You have a Power Bl report that uses row-level security (RLS).

  You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.

  What should you do?

  A. Add the Azure network security team as members of the RLS role.
  B. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
  C. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.
  D. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.
  B. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

  ---

  Explanation

  It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

• Question 120:

  HOTSPOT

  You have a Power BI semantic model.

  You need to create a column that will contain year-over-year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.