Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 51:

  You have a Power BI report that contains a stacked bar chart.

  You need to add a new field to the legend. The field must combine information from separate columns.

  What should you create?

  A. a calculated column
  B. a dynamic format string
  C. a measure
  D. a calculation group
  A. a calculated column

• Question 52:

  HOTSPOT

  You need to grant access to the business unit analysts.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: The Viewer role to the workspace

  The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can't browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to "Members can only view Power BI content".

  

  Box 2: Build

  The analysts must be able to build new reports from the dataset that contains the profit and loss data.

  Scenario: The reports must be made available to the board from powerbi.com.

  The analysts responsible for each business unit must see all the data the board sees,except the profit and loss data, which must be restricted to only their business unit's data.

  The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

• Question 53:

  You have a Microsoft Power BI 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. Increase the number of times that the dataset is refreshed.
  B. Split the visuals onto multiple pages.
  C. Change the imported dataset to DirectQuery.
  D. Implement row-level security (RLS).
  B. Split the visuals onto multiple pages.

  ---

  Explanation

  The report uses an imported dataset that contains one fact table. Setting the storage mode to Import is an irreversible operation.

• Question 54:

  You have a Power Bi model mat contains a table named Date. The Date table contains the following columns:

  1. Date

  2. Fiscal year

  3. Fiscal Quartet

  4. Month Name

  5. Calendar Year

  6. Week Number

  7. Month Number

  8. Calendar Quarter

  You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month.

  Which DAX function should you include in the table deflation?

  A. DATATABLE
  B. ADDCOLUMS
  C. SUMMARIZE
  D. CALCULATE
  C. SUMMARIZE

• Question 55:

  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:

  

  

• Question 56:

  You have a Power BI report that contains a clustered bar chart. The chart has an X-axis named Sales and a Y-axis named Year. The chart displays sales data for the years 2020 through 2024.

  You need to create a visual calculation to show a cumulative total of sales that is equal to the sum of the current year's sales plus all the sales from the previous year.

  Which DAX expression should you use?

  A. MOVINGAVERAGE([Sales], 4)
  B. RUNNINGSUM([Year])
  C. CALCULATE ( [Sales], 'Date' [Year] <= MAX ( 'Date'[Year] ) )
  D. RUNNINGSUM([Sales])
  D. RUNNINGSUM([Sales])

• Question 57:

  You have a query that returns the data shown in the following exhibit.

  

  You need to configure the query to display the data as shown in the following exhibit.

  

  Which step should you use in the query?

  A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
  B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
  C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})
  D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
  B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

  ---

  Explanation

  Power Query Unpivot columns: 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.

  

  Chart Note:

  Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table

  Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.

  https://docs.microsoft.com/en-us/power-query/unpivot-column

  https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

• Question 58:

  HOTSPOT

  You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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 59:

  You have a Power Bl report that contains a table visual.

  The visual contains a column.

  The column contains whole numbers ranging from of 1 to 20.

  You need to use conditional formatting to meet the following requirements:

  1. Visually compare the values without having to read the text containing the number.

  2. Show a different format for each distinct value

  3. Hide the numeric value of ColumnA.

  4. Minimize development effort.

  Which formatting should you use?

  A. background color
  B. font color
  C. icons
  D. data bars
  D. data bars

• Question 60:

  HOTSPOT

  You have a report in Power BI Desktop.

  You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

  

  

  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.