Power BI 4

You use Power Query Editor to preview the data shown in the following exhibit.You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
1. Select the discount column

2. 2. Select the price column

3. 3. For the discount column, change the Data type to Decimal Number

4. 4. For the discount column, change the Data Type to Whole number

5. 5. Select Replace Errors to replace each error value errors with 0.05

• 1 - 5 - 3

• 1 - 5 - 4

• 2 - 5 - 3

• 2 - 5 - 4

You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit.

• error values in the source data , A&1

• mismatch data types, A&1

• mismatch data types, A1

• NULL values, 1A

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

• You do not have permissions to the file.

• An incorrect privacy level was used for the data source.

• The file is locked.

• The referenced file was moved to a new location.

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?

• • Select Replace Errors.

• Edit the query in the Query Errors group

• • Select Remove Errors.

• • Select Keep Errors

You have a Power BI semantic model that contains the data sources shown in the following table.

• Private, Public

• Organizational, Private

• Organizational, Public

• Private, Organizational

You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

• Use Analytics views.
• Filter data from the cloud.

Which connector should you use?

• • OData queries

• • Azure DevOps (Boards only)

• Azure DevOps Server (Boards only)

• • OData Feed

You use Power Query Editor to preview the data shown in the following exhibit.
You confirm that the data will always start on row 3, and row 3 will always contain the column names.
How should you shape the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

• Keep Top Rows, Replace values

• Remove errors, Rename

• Remove top rows, Use first rows as headers

• Remove top rows, Replace values

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?

• Yes

• No

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 change the semantic model mode.
Does this meet the goal?

• Yes

• No

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 normalize casing in the source query or Power Query Editor.
Does this meet the goal?

• Yes

• No