Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 141:

  You have a semantic model that uses a live connection to a semantic model in the Power BI service. You need to create a Power BI report named RPT1 that only uses the live connection.

  Which three components can you add to RPT1?

  Note:Each correct answer presents a complete solution.

  A. a report measure
  B. a new column
  C. a calculated table
  D. a calculated column
  E. a new table
  A. a report measure
  C. a calculated table
  D. a calculated column

• Question 142:

  HOTSPOT

  The table has the following columns.

  

  You need to add a column that will be used to sort the Year Month column chronologically.

  

  

• Question 143:

  You have the following three versions of an Azure SQL database:

  1. Test

  2. Production

  3. Development

  You have a dataset that uses the development database as a data source.

  You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.

  Which should you do?

  A. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
  B. Create a parameter and update the queries to use the parameter.
  C. Create a query for each database server and hide the development tables.
  D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
  B. Create a parameter and update the queries to use the parameter.

  ---

  Explanation

  https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy

• Question 144:

  DRAG DROP

  You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

  

  You plan to build a data model for a Power Bl report.

  You need to prepare the data so that it is available to the model in the format shown in the following table.

  

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

  You have a Power BI report that contains the table shown in the following exhibit.

  

  The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.

  You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

  What should you do?

  A. Move the conditional formatting icons to a tooltip report.
  B. Add alt text that lists the values in the table.
  C. Change the icons to use a different shape for each color.
  D. Remove the icons and use red, yellow, and green background colors instead.
  C. Change the icons to use a different shape for each color.

• Question 146:

  You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship.

  The Sales table contains the following columns:

  1. Date

  2. Product

  3. SalesAmount

  You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.

  Which DAX expression should you use?

  A. CALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
  B. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30, Max('Date'[Date]))
  C. CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
  D. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
  B. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30, Max('Date'[Date]))

• Question 147:

  HOTSPOT

  You have a Power Bl semantic model that contains the data sources shown in the following table.

  

  You need to configure the privacy levels of the data sources.

  What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.

  NOTE: Each correct answer is worth one point.

  

  

• Question 148:

  You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.

  The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

  

  You need to modify the dashboard mobile layout to meet the following requirements:

  1. Only show single-value visuals.

  2. Minimize scrolling.

  What should you do?

  A. Remove the card visual, increase the size of the map and bar chart visuals
  B. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.
  C. Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.
  D. Decrease the size of the card visuals. Remove the map and bar chart visuals.
  D. Decrease the size of the card visuals. Remove the map and bar chart visuals.

• Question 149:

  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 decrease the dashboard cache update frequency.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 150:

  HOTSPOT

  You have the Performance analyzer results 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.