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, 4 months agomirzotti
3 years, 4 months agoTarek007
Highly Voted 4 years, 3 months agojason69
3 years, 9 months agouser12345678
2 years, 8 months agodmnantilla9
Most Recent 3 years agoAshley090521
3 years, 2 months agoSudhansu21
3 years, 2 months agoPrat12
3 years, 3 months agoMarski
3 years, 4 months agoPatrickStr
3 years, 4 months agoasia2301
3 years, 5 months agobunilggg
3 years, 9 months agoKnoushore1
3 years, 8 months agotest_member
4 years ago