Microsoft
70-779 · Question #15
70-779 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
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 location. 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?
Options
- AMerge all the queries. Edit the source of the first query.
- BCreate a parameter. Modify the source of each query to use the parameter.
- CFor each query, create a new query that uses a reference. Modify the source of each new query.
- DAppend all the queries. Edit the source of the first query.
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.