Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 301:

  HOTSPOT

  You are creating a column chart visualization.

  You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

  

  The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

  

  For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 302:

  HOTSPOT

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

  

  The indicator color for Total Sales will be based on % Growth to Last Year.

  The solution must use the existing calculations only.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Background color

  To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.

  In the Background color or Font color dialog box, select Field value from the Format by drop-down field.

  Box 2: Field value

  With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

• Question 303:

  HOTSPOT

  You are creating a quick measure as shown in the following exhibit.

  

  You need to create a monthly rolling average measure for Sales over time.

  How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Total Sales We select the field Total Sales

  Box 2: Date Select a date field.

  Box 3: Month Monthly periods.

  Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

• Question 304:

  HOTSPOT

  You are creating an analytics report that will consume data from the tables shown in the following table.

  

  There is a relationship between the tables.

  There are no reporting requirements on employee_id and employee_photo.

  You need to optimize the data model.

  What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Hide Optimize data by hiding fields and sorting visualization data

  Box 2: Delete The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.

  Reference: https://tessellationtech.io/optimizing-power-bi-reports/

• Question 305:

  HOTSPOT

  You are creating a Microsoft Power BI model that has two tables named CityData and Sales.

  CityData contains only the data shown in the following table.

  

  Sales contains only the data shown in the following table.

  

  CityData and Sales are related using a many-to-many relationship based upon the State column in each table.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 306:

  You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.

  You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

  Which of following two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Add the visual to the report.

  B. Ask a question by using QandA.

  C. Pin the visual to the dashboard.

  D. Use quick insights on the dashboard.

  Correct Answer: BC

• Question 307:

  In Power BI Desktop, you are creating a report that will contain three pages.

  You need to create a custom tooltip page and prepare the page for use.

  Which three actions should you perform? Each correct answer presents part of the solution.

  A. Configure filters on the target visual.

  B. For the target page, set Allow use as tooltip to On.

  C. Add and configure visuals on the tooltip page.

  D. For the tooltip page, set Allow use as tooltip to On.

  E. For the tooltip page, configure filters.

  Correct Answer: BCD

  You can create a custom tooltip page that shows more details about the selected category, such as this:

  To create a custom tooltip page and prepare it for use, you need to perform these three actions34:

  Add and configure visuals on the tooltip page. You can add any visuals, images, or other items that you want to show on the tooltip page. You can also format them as you like.

  For the tooltip page, set Allow use as tooltip to On. This will enable Power BI to recognize this page as a tooltip page. You can also change the Page size to Tooltip to fit your content better.

  For the target visual, set Tooltip type to Report page. This will allow you to select which report page you want to use as a custom tooltip for your visual. You can also filter your tooltip by fields from your target visual.

• Question 308:

  You are creating a query to be used as a Country dimension in a star schema.

  A snapshot of the source data is shown in the following table.

  

  You need to create the dimension.

  The dimension must contain a list of unique countries.

  Which two actions should you perform? Each correct answer presents part of the solution.

  A. Remove duplicates from the Country column.

  B. Remove duplicates from the City column.

  C. Remove duplicates from the table.

  D. Delete the City column.

  E. Delete the Country column.

  Correct Answer: AD

  To create a dimension table for Country from your source data, you need to perform these two actions34:

  Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.

  Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.

• Question 309:

  You have a Power Bl report that contains a page. The page contains the following:

  1.

  A shape named Shape 1

  2.

  A card named Sales Summary

  3.

  A clustered bar chart named Sales by Region

  You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

  A. Tab order in the Selection pane

  B. Layer order in the Selection pane

  C. Maintain layer order in the General visual settings

  D. Vertical alignment in the Canvas settings

  Correct Answer: B

  You use Power Query Editor to preview the data shown in the following exhibit.

  You confirm that the data will always start on row 3, and row 3 will always contain the column names.

  You use Power Query Editor to preview the data shown in the following exhibit.

  

• Question 310:

  You have a Rawer Bl report That imports a dace table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

  1.

  Due Date

  2.

  Order Date

  3.

  Delivery Date

  You need to support the analysis of sales over time based on all three dates at the same time.

  Solution:

  1.

  From the Fields pane, you rename the date table as Due Date.

  2.

  You use a DAX expression to create Order Date and Delivery Date as calculated tables.

  3.

  You create active relationships between the sales table and each date table.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A