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 26 discussion

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

You have 20 workbook queries that load 20 CSV files to a local computer.
You plan to send the workbook and the 20 CSV files to several users. The users will store the files in various locations.
You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible.
What should you do from Query Editor?

  • A. Append all the queries. Edit the source of the first query
  • B. Merge all the queries. Edit the source of the first query
  • C. For each query, create a new query that uses a reference. Modify the source of each new query
  • D. Create a parameter. Modify the source of each query to use the parameter
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
References:
https://www.howtoexcel.org/power-query/how-to-parameterize-your-power-query/
by prokocim at Feb. 24, 2020, 6:56 a.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
prokocim
Highly Voted 5 years, 4 months ago
Yes. Parameters. Each user will select a parameter with link to his path
upvoted 10 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