Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 131:

  HOTSPOT

  You have a Power Bl report named Orders that supports the following analysis:

  1. Total sales over time

  2. The count of orders over time

  3. New and repeat customer counts

  The data model size is nearing the limit for a dataset in shared capacity.

  The model view for the dataset is shown in the following exhibit.

  

  The data view for the Orders table is shown in the following exhibit.

  

  The Orders table relates to the Customers table by using the CustomerID column.

  The Orders table relates to the Date table by using the OrderDate column.

  For each of the following statements, select Yes if the statement is true, Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

• Question 132:

  You have a semantic model named Model1.

  You need to ensure that users can verify that the data in Model1 meets corporate standards.

  What should you do?

  A. Create an image of Model1.
  B. Promote Model1.
  C. Certify Model1.
  D. Apply a sensitivity label to Model1.
  C. Certify Model1.

• Question 133:

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

  

  You need to make the visual more accessible to users who have color vision deficiency.

  What should you do?

  A. Change the font color of values in the Sales column to white.
  B. Change the red background color to orange.
  C. Add additional measures to the table values.
  D. Add icons to represent the sales status of each product.
  D. Add icons to represent the sales status of each product.

• Question 134:

  HOTSPOT

  You have a Power BI imported dataset that contains the data model 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 135:

  You are configuring a Power BI report for accessibility as shown in the following table.

  

  You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

  Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. First-level elements colors
  B. Theme colors
  C. Divergent colors
  D. Sentiment colors
  B. Theme colors
  C. Divergent colors

• Question 136:

  DRAG DROP

  In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

  Every Product has a ProductSubCategory.

  Not every ProductsubCategory has a parent ProductCategory.

  You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

  How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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:

  

  

• Question 137:

  You create a Power BI workspace named Workspace1.

  You publish a semantic model and a report to Workspace1.

  You need to configure Workspace1 to meet the following requirements:

  1. Provide access to a group named Sales.

  2. Ensure that Sales can invite other users to Workspace1.

  3. Follow the principle of least privilege.

  Which role should you assign to Sales?

  A. Contributor
  B. Member
  C. Admin
  D. Viewer
  B. Member

• Question 138:

  You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database.

  The Order Header table relates to the Order Details table by using a column named Order ID in each table.

  You need to combine the tables into a single query that contains the unique columns of each table.

  What should you select in Power Query Editor?

  A. Merge queries
  B. Append queries
  C. Combine files
  A. Merge queries

• Question 139:

  HOTSPOT

  You are creating a Microsoft Power BI model that has two tables named CityData and Sales.

  CityData contains only the data shown in the following table.

  

  Sales contains only the data shown in the following table.

  

  CityData and Sales are related using a many-to-many relationship based upon the State column in each table.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

• Question 140:

  You are developing a sales report that will have multiple pages. Each page will answer a different business question.

  You plan to have a menu page that will show all the business questions.

  You need to ensure that users can click each business question and be directed to the page where the question is answered.

  The solution must ensure that the menu page will work when deployed to any workspace.

  What should you include on the menu page?

  A. Create a text box for each business question and insert a link.
  B. Create a button for each business question and set the action type to Bookmark.
  C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
  B. Create a button for each business question and set the action type to Bookmark.

  ---

  Explanation

  When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state

  - Visual selection state (such as cross-highlight filters)

  - Sort order - Drill location

  - Visibility of an object (by using the Selection pane)

  - The focus or Spotlight modes of any visible object