Smartly Prepare Exam with Free Online PL-300 Practice Test

You are creating a dashboard by using the Power Bl service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?

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

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

performance.

Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and

then delete the IoT GUID and IoT ID columns.

Does this meet the goal?

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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove Errors. Does this meet the goal?

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?