Analyzing and Visualizing Data with Microsoft Excel — Question 49

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 edit the source of each table query.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The proposed solution does not meet the goal because changing the source in Query Editor will result in the loss of the existing transformations applied to the tables. To preserve the transformations while connecting to the new data source, a different approach such as using a data source reference or maintaining the transformations in a separate layer would be necessary. Therefore, the correct answer is No.