You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.
What should you do?

• A.Add the Weekly_Returns data to the Sales table by using RELATED DAX functions.
• B.In the Weekly_Returns table, create a new calculated column named date_id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
• C.Create a new table based on the Date table where date_id is unique, and then create a many-to-many relationship to Weekly_Return.

Comment: *

Name: *

Email: *

Verification: *

You have an API that returns more than 100 columns. The following is a sample of column names.
* client_notified_timestamp
* client_notified_source
* client_notified_sourceid
* client_notified_value
* client_responded_timestamp
* client_responded_source
* client_responded_sourceid
* client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Box 1: Table.RemoveColumns
When you do "Remove Columns" Power Query uses the Table.RemoveColumns function Box 2: List.Select Get a list of columns.
Box 3: Text.EndsWith

Comment: *

Name: *

Email: *

Verification: *

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.

Correct Answer:

Explanation
1. Pin items from report to Dashboard.
2. Open Dashboard.
3. Change the dashboard view to Phone view.
4. Rearrange, resize the visuals.

Comment: *

Name: *

Email: *

Verification: *

You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?

• A.Create a text box for each business question and insert a link.
• B.Create a button for each business question and set the action type to Bookmark.
• C.Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.

Comment: *

Name: *

Email: *

Verification: *

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.

A sample of the data in Orders is shown in the following table.

You need to create the following new table.

You must use Customer as the first table.
Which join kind should you use?

• A.Inner
• B.Right Outer
• C.Left Outer
• D.Right Anti
• E.Left Anti

Comment: *

Name: *

Email: *

Verification: *