Microsoft Microsoft Certified: Data Analyst Associate PL-300 Questions & Answers

• Question 21:

  You have the following table named Location.

  

  The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

  

  You need to ensure that the map displays the country locations. What should you do?

  A. Replace the values in the GeoCode column with postal codes or zip codes.

  B. Change the name of the GeoCode column to Country.

  C. Change the name of the Location table to Country.

  D. Change the Default Summarization of the GeoCode column.

  E. Add a Geoportal column to the Location table.

  F. Change the Data Type of the GeoCode column.

  Correct Answer: B

  References: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

• Question 22:

  You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

  You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

  What should you do?

  A. Change the data type of the Logged column to Date.

  B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

  C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

  D. Apply a transform to extract the first 11 characters of the Logged column.

  Correct Answer: C

• Question 23:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

  You need to create a reference line to show which employees are above the median salary.

  Solution: You create an average line by using the Salary measure.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead create a percentile line by using the Salary measure and set the percentile to 50%.

  Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

  Reference:

  https://dash-intel.com/powerbi/statistical_functions_percentile.php

• Question 24:

  You have the dashboard shown in the following exhibit.

  

  You need to modify the dashboard to display as shown in the following exhibit.

  

  What should you do?

  A. Create and apply a custom dashboard theme.

  B. Change the colors of the visuals in the report.

  C. Apply the Dark dashboard theme.

  D. Upload a snapshot image of the dashboard.

  Correct Answer: A

  The visual colors can't be changed on the dashboard from a report after the visual has already been pinned. Applying a dashboard custom theme will do it.

• Question 25:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You remove the loT GUID column and retain the loT ID column.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 26:

  You import a Power Bl dataset that contains the following tables:

  1.

  Date

  2.

  Product

  3.

  Product Inventory

  The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.

  

  The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

  A. Change Summarization for DateKey to Don't Summarize.

  B. Change the data type of UnitCost to Integer.

  C. Remove the relationship between Date and Product Inventory.

  D. Remove MovementDate.

  Correct Answer: D

  The DateKey and MovementDate columns have the same information. Movementdate can be removed.

• Question 27:

  You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company. The reports display the data configured as shown in the following table.

  

  You need to ensure that the users of the reports can locate the correct report by using natural language queries. What should you do?

  A. From the properties of the dataset, create four Featured QandA Questions.

  B. From the Format settings of the reports, modify the Page Information.

  C. From the properties of the dataset, modify the QandA and Cortana settings.

  D. From the properties of the workspace, modify the Language Settings.

  Correct Answer: C

  References: https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview

• Question 28:

  You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

  What should you do?

  A. Create a theme as a PBIVIZ file and import the theme into Power Bl Desktop.

  B. Create a theme as a JSON file and import the theme into Power Bl Desktop.

  C. From Power Bl Desktop, use a built-in report theme.

  D. From Power Bl Desktop, customize the current theme.

  Correct Answer: D

• Question 29:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

  others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI model that contains two tables named Sales and Date. Sales contains four

  columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

  The tables have the following relationships:

  Sales[DueDate] and Date[Date]

  Sales[ShipDate] and Date[Date]

  Sales[OrderDate] and Date[Date]

  The active relationship is on Sales[DueDate].

  You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

  Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  References: https://docs.microsoft.com/en-us/dax/calculate-function-dax https://docs.microsoft.com/en-us/dax/count-function-dax

  https://docs.microsoft.com/en-us/dax/userelationship-function-dax

• Question 30:

  You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

  A line chart that shows the number of defective products manufactured by day. A KPI visual that shows the current daily percentage of defective products manufactured.

  You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

  What should you create?

  A. a QandA visual

  B. a subscription

  C. a smart narrative visual

  D. an alert

  Correct Answer: D

  Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can be set on tiles pinned from report visuals or from Power BI QandA, and only on gauges, KPIs, and cards.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/consumer/end-user-alerts