Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 411:

  HOTSPOT

  The data model must support the following analysis:

  

  The Sales table has the following columns.

  

  The data model must support the following analysis:

  1. Total sales by product by month in which the order was placed

  2. Quantities sold by product by day on which the order was placed

  3. Number Of sales transactions by quarter in which the order was placed

  For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

  

  

• Question 412:

  You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.

  The primary key of DimCustomer is CustomerID.

  FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value.

  You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.

  What should you create?

  A. an active, single-direction, many-to-one relationship
  B. an inactive, single-direction, one-to-many relationship
  C. an active, single-direction, one-to-many relationship
  D. an active, bi-directional, many-to-one relationship
  A. an active, single-direction, many-to-one relationship

• Question 413:

  DRAG DROP

  You have a Power BI semantic model.

  You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions.

  Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  

• Question 414:

  You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

  

  There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.

  

  The dataset takes a long time to refresh.

  You need to modify Posts and Traffic queries to reduce toad times.

  Which two actions will reduce the toad times? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"
  B. Remove the rows in Posts in which Post [Publish Date] is in the last seven days.
  C. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
  D. Remove Posts [Full Text] and Posts [Summary].
  E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''
  D. Remove Posts [Full Text] and Posts [Summary].
  E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

  ---

  Explanation

  D.These two columns are not used in the visuals and can be removed.

  E.Only blog posts rows are useful for the visuals.

  Incorrect:

  Three visuals need historical data.

  Traffic[Referring URL] is used in one of the visuals and therefore cannot be removed.

  These rows are used in 3 visuals.

• Question 415:

  You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.

  You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

  How should the visual interactions be set on the column chart when the bar chart is selected?

  A. no impact
  B. highlight
  C. filter
  B. highlight

  ---

  Explanation

  HIGHLIGHT as the question required us to "you see which portion of the total sales for the month belongs to the customer segment" -- in order to see WHICH portion, you need to still see the whole visual, highlight is most appropriate. If the requirement stated to ONLY SEE THE PORTION IT RELATES TO then filter would be appropriate.

• Question 416:

  HOTSPOT

  You publish the dataset to powerbi.com.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

• Question 417:

  You need to create the required relationship for the executive's visual.

  What should you do before you can create the relationship?

  A. Change the data type of <pdf2txt-u>Sales[region_id]</pdf2txt-u> to Whole Number.
  B. Change the data type of <pdf2txt-u>Sales[region_id]</pdf2txt-u> to Decimal Number.
  C. Change the data type of <pdf2txt-u>Sales[sales_id]</pdf2txt-u> to Text.
  D. In the Sales table, add a measure for <pdf2txt-u>Sum(sales_amount)</pdf2txt-u>.
  A. Change the data type of <pdf2txt-u>Sales[region_id]</pdf2txt-u> to Whole Number.

  ---

  Explanation

  Scenario: Executives require a visual that shows sales by region.

  Need to change the sales_id column from Varchar to Whole Number (Integer).

• Question 418:

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

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

  Solution: You remove the IoT GUID column and retain the IoT ID column.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 419:

  HOTSPOT

  You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

  You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

  

  The related dimension tables are imported into the model.

  Sales contains the data shown in the following table.

  

  You are evaluating how to optimize the model.

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  https://finance-bi.com/power-bi-basket-analysis/

• Question 420:

  A manager can represent only a single country.

  You need to use row-level security (RLS) to meet the following requirements:

  1. The managers must only see the data of their respective country.

  2. The number of RLS roles must be minimized.

  Which two actions should you perform? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
  B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
  C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
  D. Create one role for each country.
  E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.
  A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
  C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

  ---

  Explanation

  In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service.

  See

  https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670

  for more information.