Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 61:

  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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: You write a DAX expression that uses the FILTER function.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

• Question 62:

  You have a Power Bi report for the procurement department. The report contains data from the following tables.

  

  There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

  

  You need to minimize the size of the dataset without affecting the visuals. What should you do?

  A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

  B. Merge Suppliers and Uneltems.

  C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

  D. Remove the Lineitems[Description] column.

  Correct Answer: D

• Question 63:

  You have a QandA visual that displays information from a table named Carriers as shown in the following exhibit.

  

  You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model. What should you do?

  A. Add a duplicate query named Airline.

  B. Add airline as a synonym of carrier.

  C. Rename the carrier column as airline in the Carriers query.

  D. Rename the query from Carriers to airlines.

  Correct Answer: B

  Add synonyms to tables and columns: 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 can be important. Even with straightforward table and column names, users of QandA ask questions using the vocabulary that first comes to them. They're not choosing from a predefined list of columns. The more sensible synonyms you add, the better your users' experience is with your report.

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

• Question 64:

  You open a query in Power Query Editor.

  You need to identify the percentage of empty values in each column as quickly as possible.

  Which Data Preview option should you select?

  A. Show whitespace

  B. Column profile

  C. Column distribution

  D. Column quality

  Correct Answer: D

  Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.

  Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities: Column quality Column distribution Column profile

  Reference: https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555

• Question 65:

  You have multiple dashboards.

  You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the

  dashboard design.

  What should you use?

  A. Active Directory groups

  B. tiles

  C. data classifications

  D. comments

  Correct Answer: A

• Question 66:

  You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access:

  1.

  External users can access the dashboard.

  2.

  Managers can access the dashboard and a manager-specific report.

  3.

  Employees can access the dashboard and a row-level security (RLS) constrained report.

  You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.

  What should you use?

  A. subscriptions

  B. comments

  C. alerts

  D. chat in Microsoft Teams

  Correct Answer: A

• Question 67:

  You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

  1.

  Customer ID

  2.

  CustomerName

  3.

  Address

  4.

  City

  5.

  ProvState

  6.

  Country

  You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.

  How should you configure the drill down in the bar chart?

  A. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

  B. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

  C. In the Axis field, add Country at the top, followed by ProvState, and then City.

  D. In the Value field, add Country at the top, followed by ProvState, and then City.

  Correct Answer: C

  https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18 https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

• Question 68:

  You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal?

  A. Add a salary to the tooltips.

  B. Add a salary to the visual filters.

  C. Add salary to the drillthrough fields.

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips https://technovids.com/power-bi-filters/

• Question 69:

  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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data

  from the Order table.

  Solution: You add a WHERE clause to the SQL statement.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  The WHERE clause has its effects before the data is imported.

  Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

• Question 70:

  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 BI and do NOT import the Date table.

  B. Duplicate the Date query in Power Query and use active relationships between both Date tables.

  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. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

  Correct Answer: D

  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