Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 541:

  HOTSPOT

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

  The Opportunity table contains a column named Qualification. The Qualification column contains values between 0 and 1.

  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 542:

  You need to create relationships to meet the reporting requirements of the customer service department.

  What should you create?

  A. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
  B. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
  C. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
  D. an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]
  D. an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]

  ---

  Explanation

  The customer service department requires a visual that can be filtered by both sales month and ship month independently.

  Need two date tables. Add a one-to-many relationship from both the Date tables to Sales table.

  https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

• Question 543:

  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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

  You need to recreate the Power View sheets as reports in the Power Bl service.

  Solution: Copy the workbook to Microsoft OneDrive for Business.

  From Excel, click Publish to Power Bl, and then click Upload

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  
  

• Question 544:

  HOTSPOT

  You have an organization dimension named DimOrganizations.

  You have four related tables 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 545:

  You are creating a Power BI single-page report.

  Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.

  You need to ensure that the users can consume content on a report page in a logical order.

  What should you configure on the report page?

  A. the layer order
  B. the X position
  C. the bookmark order
  D. the tab order
  D. the tab order

• Question 546:

  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 five reports and two dashboards in a workspace.

  You need to grant all organizational users read access to one dashboard and three reports

  Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group.

  Does this meet the goal?

  A. Yes
  B. No
  B. No