Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 101:

  You have a query that returns the data shown in the following exhibit.

  

  You need to configure the query to display the data as shown in the following exhibit.

  

  Which step should you use in the query?

  A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")

  B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

  C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})

  D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

  Correct Answer: B

  Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

  

  Chart

  Note:

  Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table

  Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.

  Reference:

  https://docs.microsoft.com/en-us/power-query/unpivot-column

  https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

• Question 102:

  You use Power 81 Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.

  

  You need to resolve the error.

  What are two ways to achieve the goal? Each correct answer presents a complete solution

  NOTE: Each correct selection is worth one point.

  A. Split long running queries into subsets Of columns and use power Query to the queries

  B. Disable query folding on long running queries

  C. Reduce number of rows and columns returned by each query.

  D. Use Power Query to combine long running queries into one query.

  Correct Answer: BD

• Question 103:

  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 report that imports a date 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 the date foreign keys.

  Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  Creating two additional tables in Power Query can be a possible solution:

  Remove any inactive relationships.

  Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport. Create a copy of the role-playing

  table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.

  In the example, the Departure Airport table was created by using the following calculated table definition.

• Question 104:

  You plan to embed multiple visualization in a public website.

  Your Power BI infrastructure contains the visualizations configured as shown in the following table.

  

  Which two visualizations can you embed into the website? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.

  A. Visual1

  B. Visual2

  C. Visual3

  D. Visual4

  E. Visual5

  Correct Answer: BD

  References: https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

• Question 105:

  You have the visual shown in the exhibit. (Click the Exhibit tab.)

  

  You need to show the relationship between Total Cost and Total Sales over time.

  What should you do?

  A. Add a play axis.

  B. Add a slicer for the year.

  C. From the Analytics pane, add an Average line.

  D. Create a DAX measure that calculates year-over-year growth.

  Correct Answer: A

  When to use a slicer

  Slicers are a great choice when you want to:

  Display commonly used or important filters on the report canvas for easier access.

  Make it easier to see the current filtered state without having to open a drop-down list.

  Filter by columns that are unneeded and hidden in the data tables.

  Create more focused reports by putting slicers next to important visuals.

  Note: Suppose you want your report readers to be able to look at overall sales metrics, but also highlight performance for individual district managers and different time frames. You could create separate reports or comparative charts. You

  could add filters in the Filters pane. Or you could use slicers. Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

  Reference:

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

• Question 106:

  Your organization has a team of power users who recently created 20 Power BI dashboards.

  The power users share the dashboards with other users in the organization.

  When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

  

  You need to ensure that all the users can access the dashboards.

  What should you do first?

  A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

  B. From the Power BI Admin portal, modify the Privacy Settings.

  C. From the properties of each dashboard, modify the Share dashboard settings.

  D. Instruct each user to install Microsoft Office 2016.

  Correct Answer: A

  References: http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/

• Question 107:

  You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

  

  What occurred at 12:03:06 PM?

  A. A user pressed F5

  B. A new transaction was added to the data source.

  C. A user added a comment to a tile.

  D. The dashboard tile cache refreshed.

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

• Question 108:

  You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

  

  You need to modify the dashboard mobile layout to meet the following requirements:

  1.

  Only show single-value visuals.

  2.

  Minimize scrolling. What should you do?

  A. Remove the card visual, increase the size of the map and bar chart visuals

  B. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.

  C. Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.

  D. Decrease the size of the card visuals. Remove the map and bar chart visuals.

  Correct Answer: D

• Question 109:

  You embed a Power BI report in a Microsoft SharePoint Online page.

  A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".

  User1 is unable to view the report.

  You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

  You need to ensure that User1 can view the report form SharePoint Online.

  What should you do?

  A. Publish the app workspace.

  B. Edit the settings of the Power BI web part.

  C. Modify the members of the app workplace.

  D. Share the dashboards in the app workspace.

  Correct Answer: C

  References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo

• Question 110:

  You create the following step by using Power Query Editor.

  =Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine 1"})

  A row has a value of 21318 Lasalle Street in the AddressLine1 column.

  What will the value be when the step is applied?

  A. 1318

  B. 1319

  C. 21318 Lasalle Street

  D. 21319 Lasalle Street

  Correct Answer: D

  Example:

  Replace the text "ur" with the text "or" in the table.

  

  Reference: https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue