nerdexam
Microsoft

70-779 · Question #112

You have a data model that has the following tables. You create a PivotTable. The data displayed in the PivotTable is shown in the following table. You need to ensure that the correct data is…

The correct answer is C. Modify the relationships. See the full explanation below for the reasoning.

Question

You have a data model that has the following tables. You create a PivotTable. The data displayed in the PivotTable is shown in the following table. You need to ensure that the correct data is displayed. What should you do?

Exhibit

70-779 question #112 exhibit

Options

  • AModify the workbook connections
  • BConfigure the PivotTable Options
  • CModify the relationships
  • DRefresh the data connection

How the community answered

(58 responses)
  • A
    5% (3)
  • B
    3% (2)
  • C
    81% (47)
  • D
    10% (6)

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice