Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 41:

  You are reviewing a query that produces 10,000 rows in the Power Query Editor.

  You need to identify whether a column contains only unique values.

  Which two Data Preview options can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Column profile

  B. Column distribution

  C. Show whitespace

  D. Column quality

  E. Monospace

  Correct Answer: AB

  B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending

  order from the value with the highest frequency.

  By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).

  A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.

  Reference:

  https://docs.microsoft.com/en-us/power-query/data-profiling-tools

• Question 42:

  You plan to create the chart shown in the following exhibit.

  

  How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

  A. Create a horizontal line that has a fixed value of 24,000.

  B. Add a measure to the visual that uses the following DAX expression. Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],?40)

  C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

  D. Add a measure to the visual that uses the following DAX expression. Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

  Correct Answer: C

  The analytics feature enables you to show percentiles across groups specified along a specific axis.

  Example:

  1.

  Click on the analytics tab

  2.

  Select Percentile

  3.

  You can choose a specific percentile along with other formatting options.

  4.

  Drag a date or non-numeric dimension into the Axis of a column chart

  

  

  Add percentile lines to monitor daily revenue

  

• Question 43:

  You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using QandA. You have a table named Customer that has the following measure.

  Customer Count = DISTINCTCOUNT(Customer[CustomerID])

  Users frequently refer to customers as subscribers.

  You need to ensure that the users can get a useful result for "subscriber count" by using QandA. The solution must minimize the size of the model.

  What should you do?

  A. Add a description of "subscriber count" to the Customer Count measure.

  B. Set Summarize By to None for the CustomerlD column.

  C. Add a description of "Subscriber" to the Customer table.

  D. Add a synonym of "subscriber" to the Customer table.

  Correct Answer: B

  You can add synonyms to tables and columns.

  Note: This step applies specifically to QandA (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables

  and columns in the Power BI model.

  This step applies specifically to QandA (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and

  columns in the Power BI model.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

• Question 44:

  You have the following three versions of an Azure SQL database:

  1.

  Test

  2.

  Production

  3.

  Development

  You have a dataset that uses the development database as a data source.

  You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.

  Which should you do?

  A. Create a JSON file that contains the database server names. Import the JSON file to the dataset.

  B. Create a parameter and update the queries to use the parameter.

  C. Create a query for each database server and hide the development tables.

  D. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

  Correct Answer: B

  https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-strategy

• Question 45:

  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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

  You need to recreate the Power View sheets as reports in the Power Bl service.

  Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  We need to click "Import", not "Connect".

  References: https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

• Question 46:

  You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

  Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

  You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

  Which data modeling design should you use?

  A. Use the Auto Date/Time functionality in Microsoft Power Bl and do NOT import the Date table.

  B. Duplicate the Date query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

  C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

  D. Import the Date table twice in Power Query and create active relationships between Sales and both Date tables in the modeling view.

  Correct Answer: D

  Microsoft recommends defining active relationships whenever possible. They widen the scope and potential of how your model can be used by report authors, and users working with QandA.

  Refactoring methodology (example): Here's a methodology to refactor a model from a single role-playing dimension-type table, to a design with one table per role.

  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.

  Only one relationship can be active.

  Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active

  are automatically set.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

  https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

• Question 47:

  You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

  

  You import the tables.

  Which relationship should you use to link the tables?

  A. one-to-many from Customer to Transaction

  B. one-to-one between Customer and Transaction

  C. one-to-many from Transaction to Customer

  D. many-to-many between Customer and Transaction

  Correct Answer: A

  Each customer can have many transactions.

  For each transaction there is exactly one customer.

• Question 48:

  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 ID columns are unique to each row in query.

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

  Solution: You change the IOT DateTime column to the Date data type.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  B is correct because changing the IoT DateTime column to the Date data type alone will not meet the goal of analyzing IoT events by the hour and day of the year in power query.

• Question 49:

  You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.

  A user wants to create a report by using the data In DS1 and publish the report to another workspace.

  You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.

  What should you do?

  A. Share RPT1 with the user.

  B. Add the user as a Viewer of Workspace1.

  C. Add the user as a member of Workspace1.

  D. Grant the Build permission for DS1 to the user.

  Correct Answer: C

  Microsoft says: To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role. https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces

• Question 50:

  You are creating a report in Power BI Desktop.

  You load a data extract that includes a free text field named coll.

  You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.

  What should you do?

  A. In the report, add a DAX calculated column that calculates the length of col1

  B. In the report, add a DAX function that calculates the average length of col1

  C. From Power Query Editor, add a column that calculates the length of col1

  D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

  Correct Answer: D

  From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution