Analyzing and Visualizing Data with Microsoft Excel — Question 85

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 have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same tables as Test1, but only a subset of the data.
You add Test1 as a data source, and you select 10 tables. You configure several transformations.
You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.
Solution: From Query Editor, you configure the Data source settings.
Does this meet the goal?

Answer options

Correct answer: A

Explanation

The proposed solution meets the requirement because configuring the Data source settings in Query Editor allows you to switch the data source to Production1 while retaining the existing transformations applied to the tables. Option B, No, is incorrect because it suggests that the solution does not achieve the goal, which it does.