You have a Power B1 model that contains a table named Date. The table has the following columns.

Correct Answer:

see the expalanation for the answer below.
Explanation:
Answer is below.

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: *

You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?

• A.In a DAX function, create two calculated columns named Machine and User by using the substitute function.
• B.From Power Query Editor, split the Machine-User column by using a delimiter.
• C.From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
• D.in a DAX function, create two measures named Machine and User by using the substitute function.

Comment: *

Name: *

Email: *

Verification: *

You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

• A.Show whitespace
• B.Column profile
• C.Column distribution
• D.Column quality

Comment: *

Name: *

Email: *

Verification: *

You have a Power B1 report that contains the visuals shown in the following table.

You need to modify the location of each visual.
What should you modify for each visual?

• A.the tab order
• B.the padding
• C.the position
• D.the layer order

Comment: *

Name: *

Email: *

Verification: *