Exam 70-779 topic 1 question 45 discussion

Actual exam question from Microsoft's 70-779

Question #: 45
Topic #: 1

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: You create a new connection to Production1, and then you import the tables.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by lyniguez at Sept. 11, 2020, 3:09 p.m.

Comments

Submit Cancel

CDL

4 years, 8 months ago

B, No. new connection --> new Query, but we are asked to keep transformation, which means same Query but changing the data source only (step 1 in Query, OR, primary interface tab -->"Data Source Setting").

upvoted 1 times

...

PowerBIconsultant12

4 years, 8 months ago

B is correct. Why? "The solution must maintain the existing transformations."

upvoted 3 times

...

lyniguez

4 years, 9 months ago

B is correct

upvoted 4 times

...