Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 171:

  You have a table that contains sales data and approximately 1,000 rows.

  You need to identify outliers in the table.

  Which type of visualization should you use?

  A. area chart
  B. donut chart
  C. scatter plot
  D. pie chart
  C. scatter plot

  ---

  Explanation

  Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.

  https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc

• Question 172:

  HOTSPOT

  You are creating a Power Bi model in Power BI Desktop

  You need to create a calculated table named Numbers that will contain all the integers from -100 to 100.

  How should you complete the DAX calculation?

  To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.

  

  

• Question 173:

  You have a Power BI report named ReportA.

  You have a Power BI tenant that allows users to export data.

  You need to ensure that consumers of ReportA cannot effort any data from visuals.

  Which two actions should you perform? Each correct answer presents a complete solution.

  NOTE Each correct selection is worth one point.

  A. From Power BI Desktop, modify the Data Load settings
  B. From the answer BI service modify the Report settings.
  C. From Power BI Desktop modify the Report settings
  D. From the Power BI service, modify the dataset permissions.
  B. From the answer BI service modify the Report settings.
  D. From the Power BI service, modify the dataset permissions.

  ---

  
  

• Question 174:

  DRAG DROP

  You use Power Query Editor to Import three tables named Customers. Address, and Country.

  In the source system, not every customer has a related address, but every address has a related country.

  You need to merge all the tables into a single query. The solution must optimise query refresh performance.

  Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join 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 it worth one point.

  Select and Place:

  

  

• Question 175:

  You need to configure access for the sales department users.

  The solution must me meet the security requirements.

  What should you do?

  A. Add the sales department as a member of the reports workspace
  B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
  C. Distribute an app to the users in the Azure Active Directory group of the sales department.
  D. Share each report to the Azure Active Directory group of the sales department.
  C. Distribute an app to the users in the Azure Active Directory group of the sales department.

• Question 176:

  In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

  You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

  What should you do?

  A. Create an active relationship between the tables and select Assume referential integrity.
  B. Create an inactive relationship between the tables and select Assume referential integrity.
  C. Create an inactive relationship between the tables and select Apply security filter in both directions.
  D. Create an active relationship between the tables and select Apply security filter in both directions.
  D. Create an active relationship between the tables and select Apply security filter in both directions.

  ---

  Explanation

  By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi- directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

  

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 177:

  HOTSPOT

  You have the Power BI data model shown in the following exhibit.

  

  Select the appropriate yes or no.

  

  

• Question 178:

  You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.

  What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Sync the slicers across the pages.
  B. Replace the slicers with page-level filters.
  C. Replace the slicers with visual-level filters.
  D. Create a bookmark for each slicer value.
  E. Replace the slicers with report-level filters.
  A. Sync the slicers across the pages.
  E. Replace the slicers with report-level filters.

  ---

  Explanation

  Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter.

  You can sync a slicer and use it on any or all pages in a report.

  1. On the Power BI Desktop View menu, select Sync slicers.

  

  The Sync slicers pane appears between the Filters and Visualizations panes.

  

  https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

• Question 179:

  You have a Microsoft SharePoint Online site that contains several document libraries.

  One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

  You need to load only the manufacturing reports to a table for analysis.

  What should you do in Microsoft Power Bl Desktop?

  A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
  B. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
  C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
  D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
  B. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

  ---

  Explanation

  We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

  https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist

• Question 180:

  HOTSPOT

  You have a Power B1 report that contains the fields 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.