You have the data lineage shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

• A.Create an active relationship between the tables and select Assume referential integrity.
• B.Create an inactive relationship between the tables and select Assume referential integrity.
• C.Create an inactive relationship between the tables and select Apply security filter in both directions.
• D.Create an active relationship between the tables and select Apply security filter in both directions.

Correct Answer: D

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

Correct Answer:

1 - From Power BI Desktope, import the data from Excel, and select Table1 and Table2
2 - From Power Query Editor, append Table2 to Table1.
3 - From power Query Editor, select Table1, and then select Remove duplicates.

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *