Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 441:

  HOTSPOT

  You are profiling data by using Power Query Editor.

  The AddressLine2 column in a table named Address is shown in the following exhibit.

  

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

  NOTE: Each correct selection is worth one point.

  

  

• Question 442:

  You have a data source that contain a column. The column contains case sensitive data.

  You have a Power BI semantic model in DirectQuery mode.

  You connect to the model and discover that it contains undefined values and errors.

  You need to resolve the issue.

  Solution: You implicitly convert the values into the required types.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 443:

  DRAG DROP

  You are creating a Power Bi model and report.

  You have a single table in a data mode) named Product Product contains the following fields:

  1. ID

  2. Name

  3. Color

  4. Category

  5. Total Sales

  You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

  How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  Select and Place:

  

  

• Question 444:

  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 an on-premises data gateway.

  You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

  Solution: You create aggregations to summarize results.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 445:

  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.
  D. From Power Bl Desktop, customize the current theme.

• Question 446:

  HOTSPOT

  You use Microsoft Power BI Desktop to review the data shown in the following exhibit.

  

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

  NOTE: Each correct selection is worth one point.

  

  

• Question 447:

  You are creating a visual to show the ranking of product categories by sales revenue.

  Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant Which approach provides the widest variety of visuals while adhering to the security policy?

  A. Use default visuals or custom visuals uploaded from a .pbiviz file.
  B. Use only default visuals.
  C. Use default or any custom visuals from the marketplace.
  D. Use default or certified custom visuals.
  C. Use default or any custom visuals from the marketplace.

• Question 448:

  You have a Q&A 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.
  B. Add airline as a synonym of carrier.

  ---

  Explanation

  Add synonyms to tables and columns: This step applies specifically to Q&A (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 Q&A 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.

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

• Question 449:

  HOTSPOT

  You have a dataset named Pens that contains the following columns:

  1. Unit Price

  2. Quantity Ordered

  You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

  Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: A scatter plot...

  A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the horizontal axis. It depends on the data the chart represents.

  Box 2: Automatically find clusters

  Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

• Question 450:

  You have a Power BI data model that contains a table named Employees. The table has the following columns:

  1. Employee Name

  2. Email Address

  3. Start Date

  4. Job Title

  You are implementing dynamic row-level security (RLS).

  You need to create a table filter to meet the following requirements:

  1. Users must see only their own employee data

  2. The DAX expression must work in both Power 81 Desktop and the Power BI service.

  Which expression should you use?

  A. [Email Address] - USERNAME()
  B. [Employee Name] - USERPRINCIPALNAME()
  C. [Employee Name] = USERNAME()
  D. [Email Address] = USERPRINCIPALNAME()
  D. [Email Address] = USERPRINCIPALNAME()