Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 271:

  You have a Microsoft Excel file in a Microsoft OneDrive folder.

  The file must be imported to a Power Bi dataset

  You need to ensure that the dataset can be refreshed in powefbi.com.

  Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Text/CSV
  B. Folder
  C. Excel Workbook
  D. SharePoint folder
  E. Web
  D. SharePoint folder
  E. Web

  ---

  Explanation

  - Copy and edit Path of the Excel file then use "Web"

  Connector: Option E

  - Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source:

  https://www.youtube.com/watch?v=GGHbbg6yi-A

• Question 272:

  HOTSPOT

  You have a semantic model that contains a table named Sales. The table contains the following columns:

  1. Order ID

  2. Product ID

  3. Sales Date

  4. Sales Amount

  You need to create a DAX measure that will return the total sales amount for the same dates from the previous year.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 273:

  You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

  

  Model1 contains the following measure.

  Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date]))

  You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual.

  Which value will appear in the card visual?

  A. 10
  B. 15
  C. 35
  D. 60
  D. 60

• Question 274:

  You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

  You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.

  What should you do?

  A. Select the column chart and set the donut chart interaction to None.
  B. Select the column chart and set the donut chart interaction to Filter.
  C. Select the donut chart and set the column chart interaction to Filter.
  D. Select the donut chart and set the column chart interaction to None.
  B. Select the column chart and set the donut chart interaction to Filter.

  ---

  Explanation

  Filters remove all but the data you want to focus on.

  Note: Enable the visual interaction controls.

  1. Select a visualization to make it active.

  2. Display the Visual Interactions options.

  3. In Power BI Desktop, select Format > Edit interactions.

  

  4. To display the visualization interaction controls, select Edit interactions. Power BI adds filter and highlight icons to all of the other visualizations on the report page. We can see that the tree map is cross-filtering the line chart and the map, and is cross-highlighting the column chart. You can now change how the selected visualization interacts with the other visualizations on the report page.

  

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

• Question 275:

  DRAG DROP

  You use Power Query Editor to preview customer feedback data.

  You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

  1. What the customers most often provide feedback about

  2. Whether the customers like your company's product

  3. The language of the feedback

  Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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 276:

  You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.

  You use Power Query to load a query that contains both renamed and custom columns.

  Later, you attempt to reload the query and receive the following error message.

  Expression.Error: The column 'Category' of the table wasn't found.

  What are two possible causes of the error? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. The column was removed from the source file.
  B. The column was renamed in the source file.
  C. The file is no longer in the specified location.
  D. The data type of the column was changed.
  A. The column was removed from the source file.
  B. The column was renamed in the source file.

• Question 277:

  You plan to use Power B1 to create sales invoices for customers. The solution must meet the following requirements:

  1. Sales invoices must be exported in a PDF format

  2. The PDF exports must show all columns and rows clearly.

  What should you create?

  A. a paginated report that contains a table
  B. an interactive report that contains a matrix
  C. a dashboard that contains a table
  D. an inlet active report that contains a table
  A. a paginated report that contains a table

• Question 278:

  HOTSPOT

  Vou have a Power BI semantic model that contains the following table named Employees.

  

  An employee is considered active if the TermDate column for that employee contains no value.

  You need to create a DAX measure that will count the number of active employees.

  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.

  

  

• Question 279:

  You import a large dataset to Power Query Editor.

  You need to identify whether a column contains only unique values.

  Which two Data Preview options can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point

  A. Show whitespace
  B. Column distribution
  C. Column profile
  D. Column quality
  E. Monospaced
  A. Show whitespace
  D. Column quality

• Question 280:

  HOTSPOT

  You have a semantic model that has the relationships 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.