Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 451:

  DRAG DROP

  Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data?

  To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  

• Question 452:

  You create a Power BI report named Summary1. You discover that Summary1 is slow.

  You run Performance analyzer to identify performance metrics for Summary1.

  Which two metrics display the execution duration in Performance analyzer? (Choose two)

  Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

  A. Top Operations
  B. DAX query
  C. Server requests
  D. Dependencies
  E. Visual display
  B. DAX query
  E. Visual display

• Question 453:

  You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

  You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

  What should you recommend?

  A. Merge tables by using Power Query.
  B. Hide unused columns in the model.
  C. Split the model into multiple models.
  D. Transpose.
  A. Merge tables by using Power Query.

  ---

  Explanation

  Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.

  When you have one or more columns that you'd like to add to another query, you merge the queries.

  Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.

  CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

• Question 454:

  HOTSPOT

  You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

  You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

  1. Create reports that use the HR dataset.

  2. Publish the reports to WorkspaceB.

  3. Prevent the ability to modify the HR dataset.

  4. Prevent the ability to add users to WorkspaceB.

  What should you do? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 455:

  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 an on-premises data gateway.

  You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

  Solution: You increase Automatic page refresh intervals.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 456:

  You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

  

  A one-to-many relationship exists between the tables.

  The auto date/time option for the data model is enabled.

  You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

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

  NOTE: Each correct answer is worth one point.

  A. Create a relationship between the Date table and the Sales table.
  B. Disable the auto date/time option.
  C. Create a Date table and select Mark as Date Table.
  D. Disable the load on the Date table.
  E. Remove the relationship between the Product table and the Sales table.
  A. Create a relationship between the Date table and the Sales table.
  C. Create a Date table and select Mark as Date Table.

  ---

  Explanation

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

  Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases

• Question 457:

  HOTSPOT

  You are creating a line chart in a Power Bl report 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.

  

  

  ---

  Box 1: an average reference line

  With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights.

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

  Box 2: Axis

  The question is about drill-down and not drill-through.

  https://radacad.com/drill-down-and-up-in-power-bi-explained

  "For example, in the visual below I have SalesAmount as the Value of the column chart, and the Date field (OrderDate) as the X-Axis.

  Date hierarchy in a Power BI visual

  This will lead to seeing drill down/up buttons on the top of the visual (or at the bottom of it if the visual is touched at the very top of the report)"

• Question 458:

  You have a Power BI semantic model that contains two queries.

  You discover that a report based on the model has performance issues.

  You plan to use Power Query to reduce the data loaded to the model.

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

  NOTE: Each correct answer is worth one point.

  A. Apply group by and summarize techniques.
  B. Combine the queries by using Append.
  C. Remove unnecessary columns and rows.
  D. Combine the queries by using Merge.
  E. Create a new query group.
  A. Apply group by and summarize techniques.
  C. Remove unnecessary columns and rows.

• Question 459:

  For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.

  The data model contains several measures

  You need to create a Power BI report from the existing data.

  The solution must minimize development effort.

  Which type of data source should you use?

  A. Power BI dataset
  B. a SharePoint folder
  C. Power BI dataflows
  D. an Excel workbook
  A. Power BI dataset

• Question 460:

  HOTSPOT

  You have a Power BI model that contains a table named Date. The table has the following columns.