ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam
Go to Exam

Exam 70-779 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-779
Question #: 54
Topic #: 1
[All 70-779 Questions]

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?

  • A. Modify the workbook connections
  • B. Configure the PivotTable Options
  • C. Modify the relationships
  • D. Refresh the data connection
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Waltmas at July 28, 2020, 2:08 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Waltmas
Highly Voted 4 years, 10 months ago
in cases where we find uniform figures,we need to look at the relationships
upvoted 9 times
...
CDL
Most Recent 4 years, 8 months ago
Becoz no year column in “fSales”, so we need to create a relationship between fSales and dDate.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel