Selected PL-300 Microsoft Certified: Power BI Data Analyst Associate Questions Answers

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.

• All the rows of data must be maintained.

• Administrative effort must be minimized.

What should you do in Power Query Editor?

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.

You need to ensure that you can analyze sales by product category.

How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What 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.

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?