What should you do from Query Editor?

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?
A . Merge all the queries. Edit the source of the first query.
B . Create a parameter. Modify the source of each query to use the parameter.
C . For each query, create a new query that uses a reference. Modify the source of each new query.
D . Append all the queries. Edit the source of the first query.

Answer: B

Latest 70-779 Dumps Valid Version with 101 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments