Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?
AzureRookie
Highly Voted 4 years, 7 months agomirzotti
3 years, 7 months agoTarek007
Highly Voted 4 years, 6 months agojason69
4 years agouser12345678
2 years, 11 months agodmnantilla9
Most Recent 3 years, 3 months agoAshley090521
3 years, 5 months agoSudhansu21
3 years, 5 months agoPrat12
3 years, 6 months agoMarski
3 years, 7 months agoPatrickStr
3 years, 8 months agoasia2301
3 years, 9 months agobunilggg
4 years, 1 month agoKnoushore1
3 years, 11 months agotest_member
4 years, 3 months ago