Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 151:

  You have a Power BI report that contains a bar chart. The bar chart displays sales by country.

  You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader.

  What should you configure on the bar chart?

  A. conditional formatting
  B. alt text
  C. the tab order
  D. the layer order
  B. alt text

• Question 152:

  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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

  The tables have the following relationships:

  Sales[DueDate] and Date[Date]

  Sales[ShipDate] and Date[Date]

  Sales[OrderDate] and Date[Date]

  The active relationship is on Sales[DueDate].

  You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

  Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  References:

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

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

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

• Question 153:

  HOTSPOT

  You are building a financial report by using Power BI.

  You have a table named financials that contains a column named Date and a column named Sales.

  You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: CALCULATE

  Box 2: DATEADD

  Box 3: DIVIDE

  Example:

  NET_SALES QoQ% = IF( ISFILTERED('Calendar'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_QUARTER = CALCULATE( SUM('research ra_qtr_template'[NET_SALES]), DATEADD('Calendar'[Date].[Date], -1, QUARTER) ) RETURN DIVIDE( SUM('research ra_qtr_template'[NET_SALES]) - __PREV_QUARTER, __PREV_QUARTER ) )

  https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

• Question 154:

  In the Power BI service, you create an app workplace that contains several dashboards.

  You need to provide a user named [email protected] with the ability to edit and publish dashboards.

  What should you do?

  A. Modify the members of the app workspace.
  B. Configure security for the dataset used by the app.
  C. Share the dashboard, and then modify the Access settings of the dashboard.
  D. From the app workspace, click Update app, and then configure the Access settings.
  C. Share the dashboard, and then modify the Access settings of the dashboard.

• Question 155:

  DRAG DROP

  You receive revenue data that must be included in Microsoft Power BI reports.

  You preview the data from a Microsoft Excel source in Power Query as shown in the following exhibit.

  

  You plan to create several visuals from the data, including a visual that shows revenue split by year and product.

  You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

  Which three actions should you perform in sequence? 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:

  

  

  ---

  Step 1: Select Use Header as First Row.

  Step 2: Select Department and Product and Unpivot Other Columns

  Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.

  Step 3: Rename the Attribute column to Year and the Value column to Revenue.

  You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

  

  When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:

  Values (in blue on the left) are unpivoted into a new column (in blue on the right).

  Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.

• Question 156:

  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 Power BI report that imports a date table and a sales table from an Azure SQL database data source.

  The sales table has the following date foreign keys:

  1. Due Date

  2. Order Date

  3. Delivery Date

  You need to support the analysis of sales over time based on all the date foreign keys.

  Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 157:

  You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.

  You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.

  You need to ensure that the data is updated every morning. The solution must minimize configuration effort.

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

  NOTE: Each correct selection is worth one point.

  A. Configure the dataset to use the existing On-premises data gateway.
  B. Deploy an On-premises data gateway in personal mode.
  C. Set the refresh frequency to Daily.
  D. Configure the dataset to use the personal gateway.
  A. Configure the dataset to use the existing On-premises data gateway.
  C. Set the refresh frequency to Daily.

  ---

  Explanation

  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

• Question 158:

  HOTSPOT

  You are creating a Power 81 model to analyze inventory.

  You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.

  Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month

  You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

  How should you complete the measure? To answer select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point

  

  

• Question 159:

  You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

  The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

  The report is a single page that contains 15 AppSource visuals and 10 default visuals.

  Users say that the report is slow to load the visuals when they access and interact with the report.

  You need to recommend a solution to improve the performance of the report.

  What should you recommend?

  A. Replace the default visuals with AppSource visuals.
  B. Change any DAX measures to use iterator functions.
  C. Remove unused columns from tables in the data model.
  D. Change the imported dataset to DirectQuery.
  C. Remove unused columns from tables in the data model.

  ---

  Explanation

  DirectQuery: No data is imported or copied into Power BI Desktop. Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.

  Benefits of using DirectQuery

  There are a few benefits to using

  DirectQuery: DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.

  The 1-GB dataset limitation doesn't apply to DirectQuery.

  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

• Question 160:

  You have a Power B1 dataset that contains quarterly sales performance data.

  You need to enable managers to review the data in a format that meets the following requirements:

  1. Is optimized for printing.

  2. Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

  What should you create?

  A. a paginated report
  B. a template app
  C. an interactive report
  D. a dashboard
  A. a paginated report