Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 141:

  You have a report that contains a bar chart and a column chart. The bar chart shows customer count by

  customer segment. The column chart shows sales by month.

  You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

  How should the visual interactions be set on the column chart when the bar chart is selected?

  A. no impact

  B. highlight

  C. filter

  Correct Answer: B

  HIGHLIGHT as the question required us to "you see which portion of the total sales for the month belongs to the customer segment" -- in order to see WHICH portion, you need to still see the whole visual, highlight is most appropriate. If the requirement stated to ONLY SEE THE PORTION IT RELATES TO then filter would be appropriate.

• Question 142:

  You have the dataset shown in the following exhibit.

  

  You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?

  A. Add a Top N filter to the visual.

  B. Configure the Sales Profit measure to use the RANKX function.

  C. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

  D. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.

  Correct Answer: A

  Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.

  Note:

  Select the Column you want to display the Top Sales Profit Then change the Filter Type of that Column to Top N Fill in Top / Bottom number field And lastly drag to the By Value filed your Sales Profit

  Reference:

  https://www.tutorialgateway.org/power-bi-top-10-filters/

• Question 143:

  You are developing a sales report that will have multiple pages. Each page will answer a different business question.

  You plan to have a menu page that will show all the business questions.

  You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.

  What should you include on the menu page?

  A. Create a text box for each business question and insert a link.

  B. Create a button for each business question and set the action type to Bookmark.

  C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.

  Correct Answer: B

  When you create a bookmark, the following elements are saved with the bookmark:

  - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state

  -Visual selection state (such as cross-highlight filters)

  -Sort order - Drill location

  -Visibility of an object (by using the Selection pane)

  -The focus or Spotlight modes of any visible object

• Question 144:

  You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,

  You need to connect to BI Finance and create a report.

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

  NOTE: Each correct selection is worth one point.

  A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.

  B. From Power BI Desktop, connect to a Dataverse data source.

  C. From the Power BI service, create a new report and select a published dataset

  D. From Power Bl Desktop, connect to a shared dataset

  Correct Answer: BC

• Question 145:

  You create a report by using Microsoft Power BI Desktop.

  The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.

  You plan to publish the report to the Power BI Service.

  What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

  A. a subscription

  B. a scheduled refresh of the dataset

  C. an OData feed

  D. an On-premises data gateway

  Correct Answer: D

  When you've created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.

• Question 146:

  You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

  

  Which type of visual should you use?

  A. QandA

  B. decomposition tree

  C. smart narrative

  D. key influencers

  Correct Answer: B

  The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It is also an artificial intelligence (AI) visualization, so

  you can ask it to find the next dimension to drill down into based on certain criteria.

  This makes it a valuable tool for ad hoc exploration and conducting root cause analysis.

  Example:

  

• Question 147:

  You have a Power BI report that contains four pages.

  All the pages contain a slicer for a field named Country,

  You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages,

  What should you do?

  A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

  B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

  C. Sync the Country slicer on page 1, page 2, and page 3,

  D. Move the Country slicer from page 2 and page 3 to page 1.

  Correct Answer: C

• Question 148:

  You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace.

  What should you do?

  A. From the Power BI Admin portal, click Usage metrics.

  B. From the Office 365 Admin center, click Users.

  C. From the Office 365 Admin center, click Groups.

  D. From the Power BI Admin portal, click Tenant settings.

  Correct Answer: C

  References: https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

• Question 149:

  You are building a Power BI report to analyze customer segments.

  You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.

  Which type of visualization should you use?

  A. decomposition tree

  B. funnel chart

  C. QandA

  D. key influencers

  Correct Answer: A

  The key influencers visual is a great choice if you want to:

  See which factors affect the metric being analyzed. Contrast the relative importance of these factors. For example, do short-term contracts affect churn more than long-term contracts?

  Note: The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. For example, suppose you want to figure out

  what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time.

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

• Question 150:

  You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?

  A. Viewer

  B. Contributor

  C. Member

  D. Admin

  Correct Answer: C

  Member role allows adding members or other with lower permissions to the workspace.

  

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