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

Exam MB-200 All Questions

View all questions & answers for the MB-200 exam
Go to Exam

Exam MB-200 topic 3 question 4 discussion

Actual exam question from Microsoft's MB-200
Question #: 4
Topic #: 3
[All MB-200 Questions]

You export a Microsoft Excel workbook from Dynamics 365. The workbook contains 10,000 rows of data. You email the workbook and a description of the data to another user.
The user reports that they can only see 500 rows of data.
You need to determine why the user cannot view all the data.
Why is the user unable view all available data?

  • A. You exported a static worksheet. The user does not have the appropriate security role in Dynamics 365 to see all records.
  • B. You exported a PivotTable worksheet. The user does not have the appropriate security role in Dynamics 365 to see all records.
  • C. You created a chart in Dynamics 365 Customer Engagement and exported the chart.
  • D. You ran a report in Dynamics 365 Customer Engagement and then saved the report as an Excel file.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by KeithCachia at Aug. 29, 2019, 6:18 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
mgharably
Highly Voted 5 years, 7 months ago
the answer is B If 50 records user is seeing then static page only If 500 then it is dynamic and user is seeing according to his security role
upvoted 38 times
ESP2020
4 years, 8 months ago
This is the correct answer :) Moderator should change the actual answer on the screen to this, that is the correct one. Please, do it for avoiding mistakes. Thanks!!
upvoted 2 times
...
Ameen
5 years, 4 months ago
Privacy notice If you use Microsoft Dynamics 365 (online), exporting data to a static worksheet creates a local copy of the exported data and stores it on your computer. The data is transferred from Dynamics 365 (online) to your computer by using a secure connection, and no connection is maintained between this local copy and Dynamics 365 (online). When you export to a dynamic worksheet or PivotTable, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view. An administrator determines whether or not an organization’s users are permitted to export data to Excel by using security roles.
upvoted 3 times
Ameen
5 years, 4 months ago
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-pivottable
upvoted 2 times
...
...
...
KeithCachia
Highly Voted 5 years, 8 months ago
Data exported from a report (SSRS) contain static data. This means that they do not observe the Dynamics security model after the report is exported to Excel. Once a user saves a report to Excel, PDF, Word etc. anyone will be able to view the data (even if they do not have access Dynamics 365). With a pivot table data is refreshed when the file is opened and uses the user credentials to retrieve the data. This will limit the result according to the records the user has access to.
upvoted 21 times
...
Karlomanio
Most Recent 4 years, 8 months ago
I think actually the answer is A. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-pivottable It doesn't have to be a pivot table for this to be true
upvoted 1 times
sravthi
4 years, 8 months ago
I think A is not right. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/basics/export-excel-static-worksheet You can email a static exported worksheet to anyone, or store it in a shared file. Anyone who opens the file will see all the data in the file, whether or not they are a Dynamics 365 Customer Engagement (on-premises) user or have privileges to view the data in Dynamics 365 Customer Engagement (on-premises).
upvoted 2 times
...
...
AneeG
4 years, 10 months ago
In my exam. B is the answer
upvoted 2 times
...
mkhaleel
4 years, 11 months ago
The Correct Answer is B , Pivot table since the user can specify to refresh the Data when open the excel
upvoted 4 times
...
Harish1509
5 years, 2 months ago
If the recipients are in the same domain as you, and are Dynamics 365 Customer Engagement (on-premises) users, you can email a dynamic Excel file, or store it as a shared file. When recipients open the dynamic file, they will see data they have permission to view in Dynamics 365 Customer Engagement (on-premises), so the data they see may be different from what you see
upvoted 1 times
...
Ayeenm
5 years, 3 months ago
in exam
upvoted 1 times
...
ned
5 years, 3 months ago
Its B. I wonder from where Examtopics get answers from.
upvoted 4 times
jnicophene
5 years, 3 months ago
Most likely Microsoft.. They often give out wrong answers
upvoted 3 times
javier
5 years, 2 months ago
I´m using an exam simulator that has the exact same answer
upvoted 1 times
...
...
...
arshad
5 years, 4 months ago
It's B only, with Pivot Table if data source wasn't unchecked while export then connection would refresh and reload data on reopening of file
upvoted 4 times
...
FahadShaikh
5 years, 5 months ago
IN exam
upvoted 6 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago