Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 11:

  HOTSPOT

  You attempt to use power Query Editor to create a custom column and receive the error message 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.

  

  

• Question 12:

  You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

  You need to reduce the size of the data model.

  What should you do?

  A. Round the hour of the Date column to startOfHour.
  B. Change the data type of the Date column to Text.
  C. Trim the Date column.
  D. Split the Date column into two columns, one that contains only the time and another that contains only the date.
  D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

  ---

  Explanation

  We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.

  https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

• Question 13:

  You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources:

  1. Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business

  2. Source2: An Azure SQL database on a virtual network

  3. Source3: A public website

  Which data sources require an on-premises data gateway?

  A. Source1 only
  B. Source2 only
  C. Source3 only
  D. Source1 and Source2 only
  E. Source2 and Source3 only
  F. Source1, Source2, and Source3
  B. Source2 only

• Question 14:

  HOTSPOT

  You have a Power BI report that contains a page. The page contains the following visuals:

  1. A card

  2. A matrix

  3. A bar chart

  You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix.

  The card and the bar chart must change when a user selects a cell in the matrix.

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

  

  

• Question 15:

  You have the visual shown in the Original exhibit. {Click the Original tab.)

  

  You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

  

  What should you add to the visual?

  A. a measure
  B. a trendline
  C. a forecast
  D. an Average line
  C. a forecast

  ---

  Explanation

  Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.

  

  https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

• Question 16:

  Which DAX expression should you use to get the ending balances in the balance sheet reports?

  A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )
  B. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )
  C. FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )
  D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )
  A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )

  ---

  Explanation

  Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.

  DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.

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

• Question 17:

  DRAG DROP

  You use Power Query Editor to load two queries named Query 1 and Query2 Query1 results in the following error.

  Query1 results in the following error.

  

  Query2 results in the following error.

  

  Which type of error occurred for each query? To answer, drag the appropriate error types to the correct queries. Each error type 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:

  

  

• Question 18:

  You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.

  A user wants to create a report by using the data In DS1 and publish the report to another workspace.

  You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.

  What should you do?

  A. Share RPT1 with the user.
  B. Add the user as a Viewer of Workspace1.
  C. Add the user as a member of Workspace1.
  D. Grant the Build permission for DS1 to the user.
  D. Grant the Build permission for DS1 to the user.

  ---

  Explanation

  Microsoft says: To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role.

  https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces

• Question 19:

  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 add a new column to the Product Subcategory table that uses the following formula.

  =if [Subcategory] =null then "NA" else [Subcategory] Which command should you use in Query Editor?

  A. Column From Examples
  B. Custom Column
  C. Invoke Custom Function
  D. Conditional Column
  D. Conditional Column

  ---

  Explanation

  References:

  http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

• Question 20:

  HOTSPOT

  You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.)

  

  You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.)

  

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

  NOTE: Each correct selection is worth one point.