Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 211:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

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

  DRAG DROP

  You have the Power BI data model shown in the following exhibit.

  

  Select and Place:

  

  Correct Answer:

  

• Question 213:

  DRAG DROP

  You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

  

  The solution must minimize development effort

  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:

  

  Correct Answer:

  

• Question 214:

  DRAG DROP

  You receive annual sales data that must be included in Power BI reports.

  From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

  

  You need to create a report that meets the requirements:

  1.

  Visualizes the Sales value over a period of years and months

  2.

  Adds a Slicer for the month

  3.

  Adds a Slicer for the year

  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:

  

  Correct Answer:

  

• Question 215:

  DRAG DROP

  You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

  

  Sheet2 contains the following table named Table2.

  

  You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

  

  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:

  

  Correct Answer:

  

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

• Question 216:

  DRAG DROP

  You are modifying a Power Bi model by using Power Bl Desktop.

  You have a table named Sales that contains the following fields.

  

  You have a table named Transaction Size that contains the following data.

  

  You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.

  How should you complete the code? 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 drag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 217:

  DRAG DROP

  You plan to create a report that will display sales data from the last year for multiple regions

  You need to restrict access to individual rows of the data on a per region-basis by using roles.

  Which four 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:

  

  Correct Answer:

  

  You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions. To define security roles, follow these steps.

  1.

  Import data into your Power BI Desktop report (Step 1)

  2.

  From the Modeling tab, select Manage Roles.

  3.

  From the Manage roles window, select Create. (Step 2)

  4.

  Under Roles, provide a name for the role.

  5.

  Under Tables, select the table to which you want to apply a DAX rule.

  6.

  In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = ג€Valueג€(Step 3)

  7.

  After you've created the DAX expression, select the checkmark above the expression box to validate the expression.

  8.

  Select Save.

  Step 3: Assign Users to the role.

  You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service.

  After you've created your roles, test the results of the roles within Power BI Desktop.

  Step 4: Publish the report.

  Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

• Question 218:

  DRAG DROP

  You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.

  You have a Power Bl dashboard named DashboardA that has QandA enabled.

  You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.

  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:

  

  Correct Answer:

  

• Question 219:

  DRAG DROP

  You have a Power Bl workspace that contains a single-page report named Sales.

  You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.

  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:

  

  Correct Answer:

  

  An entire report page can be pinned to a dashboard, which is called pinning a live tile. It's called a live tile because you can interact with the tile on the dashboard. Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard.

  Step 2: Open the Sales report Step 3: Pin the page.

  1.

  Open a report in Editing view.

  2.

  With no visualizations selected, from the menu bar, select Pin to a dashboard.

  3.

  Pin the tile to an existing dashboard or to a new dashboard. Notice the highlighted text: Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed.

  4.

  Select Pin live. A Success message (near the top right corner) lets you know the page was added, as a tile, to your dashboard.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

  

• Question 220:

  DRAG DROP

  You have a Power B1 data model that contains two tables named Products and Sales.

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

  You have a report that contains a report-level filter for Products.

  You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.

  How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content

  NOTE: Each correct selection is worth one point

  Select and Place:

  

  Correct Answer: