Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 181:

  You have a report that includes a card visualization.

  You need to apply the following conditional formatting to the card while minimizing design effort.

  1. For values that are greater than or equal to 100, the font of the data label must be dark red.

  2. For values that are less than 100, the font of the data label must be dark gray.

  Which type of format should you use?

  A. Color scale
  B. Rules
  C. Field value
  B. Rules

• Question 182:

  You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.

  You pin the Sales by month visual to Dashboard1.

  In Report1, you change the Sales by month visual to a bar chart.

  You need to ensure that the bar chart displays on Dashboard', What should you do?

  A. Refresh the dataset used by Report1 and Dashboard1.
  B. Select Refresh visuals for Dashboard1.
  C. Edit the details for the dashboard tile Of Dashboar1.
  D. Pin the Sales by month bar chart to Dashboard1.
  D. Pin the Sales by month bar chart to Dashboard1.

• Question 183:

  HOTSPOT

  You need to create a measure that will return the percentage of late orders.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: CALCULATE

  CALCULATE evaluates an expression in a modified filter context.

  Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ...]]])

  Expression - The expression to be evaluated. filter1, filter2,... (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

  Box 2: FILTER

  FILTER returns a table that represents a subset of another table or expression.

  Syntax: FILTER(<table>,<filter>)

  Table- The table to be filtered. The table can also be an expression that results in a table.

  Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"

  Box 3: Orders[ShippedDate]> Orders[RequiredDate]

  Northwind Traders defines late orders as those shipped after the required shipping date.

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

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

• Question 184:

  You have a Fabric workspace named Workspace1 that contains two Power Bl reports named Report1 and Report2.

  You create a workspace app that contains both reports.

  You need to ensure that the app meets the following requirements:

  Report1 must be visible to all the users in your organization.

  Report2 must be visible to only a security group named Group1.

  What should you do next?

  A. Assign Group1 the Viewer role for Workspace1.
  B. Share Report1 with the built-in All users security group.
  C. Create an audience and assign Group1 to the audience.
  D. Allow access to the hidden content of the app.
  C. Create an audience and assign Group1 to the audience.

• Question 185:

  DRAG DROP

  You are preparing a financial report in Power BI.

  You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

  

  You need to prepare the data to support the following:

  1. Visualizations that include all measures in the data over time

  2. Year-over-year calculations for all the measures

  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:

  

  

  ---

  1. Use first row as header 2. Unpivot all columns other than "Measure"

  3. Rename "Attribute" to "Year"

  4. Change data type of "Year" to date (Date > Year)

  https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

• Question 186:

  You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount.

  You need to create the visual shown in the following exhibit.

  

  In which section of the Fields well should you place the measures?

  A. Columns
  B. Rows
  C. Values
  D. Drill through
  C. Values

• Question 187:

  You have a Power Bl model that contains the following data.

  

  The Date table relates to the Sales table by using the Date columns.

  The model contains the following DAX measure.

  Total Sales = SUM(Sales[Sale])

  You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

  Which DAX calculation should you use?

  A. CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))
  B. CALCULATE ([Total Sales], DATESQTD (Date[Date]))
  C. TOTALQTD ([Total Sales], Date[Date])
  D. CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))
  A. CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))

• Question 188:

  HOTSPOT

  You are using Microsoft Power Bl Desktop to profile data in Power Query Editor. Table data is displayed 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.

  

  

• Question 189:

  You have an on-premises Power BI Report Server.

  You plan to create a report in Power BI Desktop and publish the report to the report server.

  Which data source should the report use?

  A. Microsoft Azure SQL Database
  B. a Microsoft SQL Server database
  C. a Microsoft SQL Server Analysis Services (SSAS) database
  D. Microsoft Excel
  C. a Microsoft SQL Server Analysis Services (SSAS) database

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report

  https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources

• Question 190:

  You have a Power Bl model that contains two tables named Population and Date.

  The Population table contains two columns named Population Amount and Date Key.

  DateKey contains date values that represent the first day of a year and are used to create a many-to.

  The Power Bl model contains two measures that have the following definitions.

  1. Total Population = Sum ('Population'[Population Amount])

  2. 2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)

  You create a table visual that displays Date[Year] and [2023 Population].

  What will the table visual show?

  A. one row per year that contains blank values for every year except 2023
  B. one row per date that contains the population value for the corresponding year repeated in each row
  C. a single row for the year 2023 that contains the related population value
  D. one row per year that contains the same value repeated for each year
  D. one row per year that contains the same value repeated for each year