Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 2

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Power Bl report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?

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.

You are creating a Power 81 model to analyze inventory.

You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.

Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

How should you complete the measure? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

You have the data lineage 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.

You have a Power Bl table named Customer that contains a field named Email Address.

You discover that multiple records contain the same email address.

You need to create a calculated column to identify which records have duplicate email addresses.

How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct 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

NOTE: Each correct selection is worth one point.

You plan to use Power BI to create a quarterly profit report that meets the following requirements:

• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage

• Compares profit margins across sales regions

Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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.

NOTE: Each correct selection is worth one point.

You have a Power Bl report.

You have the following tables.

You have the following DAX measure.

You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

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 data source that contains 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 type.

Does this meet the goal?