Exam 70-779 topic 1 question 30 discussion

D is the right one..... I tested it and works fine!!!

I think the right answer is C.

Why people love to sabotage. Many people are here to make others confused. If you ain’t done the test please do not comment.

Tested - D is correct Run the Document Inspector and Clear Embedded Data from the Data Model

This link is helpful to understand the document inspector specifically designed to make a document ready for sharing. The question is unfortunately confusing as to what data needs to be removed since the document inspector does not remove the connection to the databases that the pivot chart and pivot table is linked to. D is, though, the closest to the right answer. See https://support.microsoft.com/en-us/office/remove-hidden-data-and-personal-information-by-inspecting-documents-presentations-or-workbooks-356b7b5d-77af-44fe-a07f-9aa4d085966f#ID0EAACAAA=Excel

Seems D is the right answer.

Right answer is C

I tested, the answer should be C, run the Document Inspector and remove the embedded data, it will remove data from data model, however as long as the user can connect to the Server, the data can be retrieved from server to Excel after refresh.

D for sure

The right answer is D - Document Inspector allows you to remove data from the Data Model (which is the point of the question). Chaning the credentials will make it impossible to refresh the data but won't delete the existing data from the data model.

Definitely C : https://support.office.com/en-us/article/Make-changes-to-an-existing-data-source-in-Power-Pivot-9CB508D3-1A83-4D83-A944-700CE41332B6 The article above explains that to keep a data model but prevent the data from being visualised one needs to "Change the authentication method or the credentials used to access the data".

The Correct Answer is D

Right answer is D