Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 261:

  HOTSPOT

  Your company has affiliates who help the company acquire customers.

  You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.

  The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

  

  You need to develop a measure to support the visual.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: CALCULATE

  Start with CALCULATE and use a SUMX.

  CALCULATE evaluates an expression in a modified filter context.

  Box 2: SUM

  Box 3: TOPN

  TOPN returns the top N rows of the specified table.

  Box 4: [TransactionDate]

  TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...])

  The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.

  https://docs.microsoft.com/en-us/dax/topn-function-dax

• Question 262:

  You have the dashboard shown in the following exhibit.

  

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

  

  What should you do?

  A. Create and apply a custom dashboard theme.
  B. Change the colors of the visuals in the report.
  C. Apply the Dark dashboard theme.
  D. Upload a snapshot image of the dashboard.
  A. Create and apply a custom dashboard theme.

  ---

  Explanation

  The visual colors can't be changed on the dashboard from a report after the visual has already been pinned. Applying a dashboard custom theme will do it.

• Question 263:

  You have a Power Bl workspace that contains several reports.

  You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.

  What should you do?

  A. Grant the Read permission for the datasets to the user.
  B. Add the user as a Viewer of the workspace.
  C. Share the reports with the user.
  D. Create a row-level security (RLS) role and add the user to the role.
  E. Add the user as a member of the workspace.
  E. Add the user as a member of the workspace.

• Question 264:

  DRAG DROP

  Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

  Start of repeated scenario

  You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  You plan to use Power BI to import data from 2013 to 2015.

  Product Subcategory [Subcategory] contains NULL values.

  End of repeated scenario.

  You implement the Power BI model.

  You need to edit the Product Category table query to match the desired Power BI model.

  How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.

  You may need to frag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

• Question 265:

  You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.

  What should you do?

  A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
  B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
  C. Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
  A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

• Question 266:

  You have a Power B1 report. The report contains a line chart that displays sales data for several regions.

  You need to add an element to the report that will enable users to filter the sales data to include only a selected region.

  Which two elements achieve the goal? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. a slicer visual
  B. a drillthrough filter
  C. a table visual
  D. a card visual
  E. a Key Performance Indicator (KPI) visual
  A. a slicer visual
  C. a table visual

• Question 267:

  HOTSPOT

  You create a Power Bl dataset that contains the table shown in the following exhibit.

  

  You need to make the table available as an organizational data type In Microsoft Excel.

  How should you configure the properties of the table? To answer select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 268:

  You have a Microsoft Fabric eventhouse named Eventhouse1 that contains high-velocity and high-volume data from IoT devices.

  Eventhouse1 can be queried to deliver data to reports in near-real-time (NRT).

  You plan to use Power BI Desktop to create a report that will contain both historical and live data.

  You need to connect to Eventhouse1. The solution must minimize development effort.

  What should you do?

  A. Build a composite model.
  B. Use DirectQuery connectivity mode.
  C. Use Import connectivity mode.
  A. Build a composite model.

• Question 269:

  HOTSPOT

  You have a Power BI semantic model that contains the following table named Employees.

  

  An employee is considered active if the TermDate column for that employee contains no value.

  You need to create a DAX measure that will count the number of active employees.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 270:

  You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete.

  What should you use?

  A. SQL Server Profiler
  B. Performance Analyzer in Power BI Desktop
  C. Query Diagnostics in Power BI
  D. Microsoft Edge DevTools
  B. Performance Analyzer in Power BI Desktop

  ---

  Explanation

  Use Power BI Desktop Performance Analyzer to optimize reports. In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer