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

• Question 41:

  You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

  You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.

  What should you do?

  A. Select the column chart and set the donut chart interaction to None.

  B. Select the column chart and set the donut chart interaction to Filter.

  C. Select the donut chart and set the column chart interaction to Filter.

  D. Select the donut chart and set the column chart interaction to None.

  Correct Answer: B

• Question 42:

  You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

  A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

  B. From Power Bi Desktop, use the Auto date/time option when creating the reports.

  C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

  D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

  Correct Answer: C

• Question 43:

  You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.

  You publish the report to the Bl service.

  You need to be notified when the temperature rises above four degrees Celsius.

  What should you do?

  A. Pin a report page to a dashboard and set an alert on the page.

  B. Set an alert on a KPI visual in the report.

  C. Pin a card visual to a dashboard and set an alert on the tile.

  D. Pin a card visual to a dashboard and create a subscription.

  Correct Answer: A

• Question 44:

  You have a Microsoft Excel file in a Microsoft OneDrive folder.

  The file must be imported to a Power Bi dataset

  You need to ensure that the dataset can be refreshed in powefbi.com.

  Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Text/CSV

  B. Folder

  C. Excel Workbook

  D. SharePoint folder

  E. Web

  Correct Answer: DE

  -

  Copy and edit Path of the Excel file then use "Web" Connector: Option E

  -

  Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source: https://www.youtube.com/watch?v=GGHbbg6yi-A

• Question 45:

  You are creating a Power BI model that contains a table named Store. Store contains the following fields.

  You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?

  A. Set the data category of City. State/Province, and Country.

  B. Set Summarization for City. State/Province, and Country to Don't summarize

  C. Change the data type of City. State/Province, and Country.

  D. Create a calculated column that concatenates the values it City, State/Province, and Country.

  Correct Answer: A

• Question 46:

  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 47:

  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 48:

  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 49:

  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 50:

  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