Microsoft PL-300 Exam Dumps

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?

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 have a Power Bl report
You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
• A card that shows the number of records
• A bar chart that snows total transaction amount by territory
• A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory
You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?