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?

• A.Select Keep Errors
• B.Select Remove Errors.
• C.Edit the query in the Query Errors group.
• D.Select Replace Errors

Comment: *

Name: *

Email: *

Verification: *

A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
The managers must only see the data of their respective country.
The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
• B.Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
• C.For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
• D.Create one role for each country.
• E.For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Comment: *

Name: *

Email: *

Verification: *

You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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 solu 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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

Correct Answer:

Reference:
https://tessellationtech.io/optimizing-power-bi-reports/

Comment: *

Name: *

Email: *

Verification: *