You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax

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

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

• A.Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
• B.Publish the reports to a different workspace other than the one hosting the datasets.
• C.Publish the reports in an app and grant the HR managers access permission.
• D.Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Comment: *

Name: *

Email: *

Verification: *

You use Power Query Editor to preview customer feedback data.
You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:
* What the customers most often provide feedback about
* Whether the customers like your company's product
* The language of the feedback
Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service may be used once, more than once. or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

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

Comment: *

Name: *

Email: *

Verification: *