Exam MB-200 All Questions

View all questions & answers for the MB-200 exam

Exam MB-200 topic 2 question 2 discussion

Actual exam question from Microsoft's MB-200

Question #: 2
Topic #: 2

DRAG DROP -
You are a Dynamics 365 administrator. An Excel template with a pivot table is created for opportunities by a manager.
When a salesperson opens the Excel template in the My Opportunities view, they observe the following issues:
✑ The salesperson can view information for all salespeople.
✑ The salesperson does not see their current data.
You need ensure the salesperson can only see their information.
Which Excel PivotTable attributes should you use? To answer, drag the appropriate attributes to the correct settings. Each attribute 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.
Select and Place:

Show Suggested Answer

Suggested Answer:

by girish at Sept. 27, 2019, 1:01 a.m.

Comments

Submit Cancel

M4rv1n

Highly Voted 5 years, 8 months ago

Save file without data, it will not have data from others. Refresh at opening, it will refresh data with current user data

upvoted 17 times

...

itthuydoan

Highly Voted 5 years, 5 months ago

correct

upvoted 9 times

...

Mariusme

Most Recent 5 years ago

The answers are correct: https://trumpexcel.com/pivot-cache-excel/ this will give you a detailed explanation about what each option does.

upvoted 2 times

...

Ameen

5 years ago

In exam

upvoted 2 times

...

Caro

5 years, 4 months ago

https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates#BKMK_BestPractices

upvoted 4 times

...

Caro

5 years, 4 months ago

https://us.hitachi-solutions.com/blog/5-tips-using-excel-templates-dynamics-crm/

upvoted 2 times

...

mtalha86

5 years, 5 months ago

It means the mentioned answer is right?

upvoted 2 times

...

cleon

5 years, 6 months ago

If "Refresh Data When Opening the File" is checked from the beginning, it will not matter if the data is saved in the file as it is guaranteed that no other users' data will be saved.

upvoted 1 times

SoMuchConfusion

5 years, 5 months ago

Not necessarily. When first exported, if Save data with the file is checked, the file would contain all data visible to the user exporting it. Even if refresh when opened is checked, someone could potentially snoop the file contents in a text editor. Granted, I believe it's probably mostly in binary, but someone clever and determined enough may be able to get at data they should not with access to the file. I think the safest scenario is to also ensure the save data with file is unchecked.

upvoted 2 times

...

girish

5 years, 8 months ago

Can someone explain..

upvoted 1 times

arshad

5 years, 5 months ago

Exporting pivot table to an excel template having 2 options to "Check" or "Uncheck" for source data exported with template, if you export with data it would show same data to others else on refresh would load new data from pivot table data source itself.

upvoted 2 times

...