Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 21:

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

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

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

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

  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

• Question 26:

  You have a Power Bl report that uses row-level security (RLS).

  You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.

  What should you do?

  A. Add the Azure network security team as members of the RLS role.

  B. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

  C. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

  D. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

  Correct Answer: B

  It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

• Question 27:

  You have a Power BI tenant.

  You have reports that use financial datasets and are exported as PDF files.

  You need to ensure that the reports are encrypted.

  What should you implement?

  A. dataset certifications

  B. row-level security (RLS)

  C. sensitivity labels

  D. Microsoft Intune policies

  Correct Answer: C

  General availability of sensitivity labels in Power BI.

  Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports,

  dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings. This way

  your sensitive data remains protected no matter where it is.

  Reference:

  https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and- introducing-new-capabilities/

• Question 28:

  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 add a WHERE clause to the SQL statement.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• 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 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: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 30:

  You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend.

  You need to include a visual that identifies which fields have the greatest impact on Spend.

  Which type of visual should you use?

  A. decomposition tree

  B. QandA

  C. smart narrative

  D. key influences

  Correct Answer: D