Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 471:

  You have a collection of reports for the HR department of your company.

  You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

  Which type of visualization should you use?

  A. scatter chart
  B. ribbon chart
  C. line chart
  D. key influences
  C. line chart

  ---

  Explanation

  The best data for forecasting is time series data or uniformly increasing whole numbers.

  The line chart has to have only one line.

  Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.

  https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

• Question 472:

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

  You have a data source that contains a column. The column contains case sensitive data.

  You have a Power BI semantic model in DirectQuery mode.

  You connect to the model and discover that it contains undefined values and errors.

  You need to resolve the issue.

  Solution: You Normalize casing in the source query or Power Query Editor.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 473:

  HOTSPOT

  You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.

  The Products table is a dimension table that contains the following columns:

  1. ProductID

  2. ProductName

  The OrderHistory table is a fact table that contains the following columns:

  1. OrderID

  2. ProductID

  3. OrderDate

  The Date table is a dimension table that contains the following columns:

  1. Year

  2. Date

  3. Week

  4. Month

  You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.

  Which cardinality should you configure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct answer is worth one point.

  

  

• Question 474:

  You have a Power Bl report that contains the table shown in the following exhibit.

  

  The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.

  You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

  What should you do?

  A. Add alt text that lists the values in the table.
  B. Change the icons to use a different shape for each color.
  C. Remove the icons and use red, yellow, and green background colors instead
  D. Move the conditional formatting icons to a tooltip report
  B. Change the icons to use a different shape for each color.

• Question 475:

  You have the Power Bl model shown in the following exhibit.

  

  There are four departments in the Departments table.

  You need to ensure that users can see the data of their respective department only.

  What should you do?

  A. Create a row-level security (RLS) role for each department, and then define the membership of the role.
  B. Create a DepartmentID parameter to filter the Departments table.
  C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.
  D. Create a slicer that filters Departments based on DepartmentID.
  A. Create a row-level security (RLS) role for each department, and then define the membership of the role.

• Question 476:

  HOTSPOT

  You have a Power BI report that contains the table visual shown in the following exhibit.

  

  You need to modify the visual to display as shown in the following exhibit.

  

  How should you configure the visual? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 477:

  You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.

  File1 Is moved to a different folder.

  When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data.

  You need to ensure that the data in File1 refreshes properly.

  What should you do?

  A. Modify the permission for R.
  B. Export a PBIDS file.
  C. Clear the permissions of File1.
  D. Change the data source.
  D. Change the data source.

• Question 478:

  You have a Power BI report named Report1. You plan to share Report1 with multiple users.

  You need to add the users to a group.

  Which two types of groups can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. security group
  B. distribution group
  C. Microsoft Teams team
  D. Microsoft 365 group
  A. security group
  D. Microsoft 365 group

• Question 479:

  HOTSPOT

  You have a query that contains customer data in Power Query Editor 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.

  

  

• Question 480:

  You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode.

  You need to update the model to change the storage mode of Table1 to DirectQuery.

  What should you do?

  A. Delete Table1. and then add the table to the model again in DirectQuery storage mode.
  B. From Power Query Editor, duplicate the query for Table1.
  C. From Model view, change the storage mode of Table1 to DirectQuery
  D. Add an aggregation table to the model.
  C. From Model view, change the storage mode of Table1 to DirectQuery