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.

Correct Answer:

Explanation:
Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).
Note:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Comment: *

Name: *

Email: *

Verification: *

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

1 - From Power BI Desktop, publish the dataset to powerbi.com.
2 - From Power BI Desktop, create four roles.
3 - From Power BI Desktop, add a Table Filture.......
4 - From powerbi.com,add role members to the roles.

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:

Explanation

Table Description automatically generated
Box 1: Hide
Optimize data by hiding fields and sorting visualization data
Box 2: Delete
The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/

Comment: *

Name: *

Email: *

Verification: *

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader.
You need to ensure that the users can consume the content on a report page in a logical order.
What should you configure in Microsoft Power Bl Desktop?

• A.the bookmark order
• B.the layer order
• C.the tab order
• D.the X position

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Comment: *

Name: *

Email: *

Verification: *