You have a workbook query that loads data from C:\Data\Users.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refresh the data from Users.xlsx. What should you do?
A.
From Query Editor, modify the Source step
B.
From the Insert tab in Excel, click My Add-ins, and then manage the add-ins
C.
From the Linked Table tab in Power Pivot, modify the Update Mode
D.
From the Data tab in Excel, click Connections, and then modify the properties of the connection
1. If we wanna continue to be able to refresh data based on “User(Raw data)” located in a shared folder, go with A(data Source setting).
2. If we wanna restrict Raw data information, go with A’s (data Source setting) permission (public or private).
3. If we wanna not show/delete any data behind the scenes, duplicate the original workbook, “File”-“Info”-“Check for Issue”-“Inspect Document”.
The answer appears to be A. See this link, it talks about how you can modify the source location when you move a file/table to a new location and need to update that location. The question is trying to be tricky to make you think you need to adjust the "Refresh" settings, but you cannot refresh the file if it is no longer connected to the workbook, so you must reconnect the work book and this is how you do it. https://exceloffthegrid.com/power-query-source-data-location/
In connection properties you can modify the connection string, therefore I like D as the answer. A appears it would also work as others have suggested.
I would say A is the idiot proff solution . I simply would update the source. If doing it manually, why not from the query editor? I don't see any benefit from doing it through the connection properties, unless something is automated... But this seems not to be the case here.
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
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.
mohroshdy
Highly Voted 5 years, 6 months agoThe_Marv
Highly Voted 5 years, 7 months agoCDL
Most Recent 4 years, 8 months agoWarpCore
4 years, 8 months agoWaltmas
4 years, 10 months agoWaltmas
4 years, 10 months agoCibrevN
5 years agoamar111
5 years, 1 month agoclaudia_learner
5 years, 1 month agoSkye
5 years, 4 months agonose
5 years, 4 months agocs3122
5 years, 4 months agoOye
5 years, 6 months agodinessa
5 years, 7 months agoimran
5 years, 8 months ago