Exam 70-779 topic 1 question 44 discussion

Actual exam question from Microsoft's 70-779

Question #: 44
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: From Query Editor, you edit the source of each table query.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by tho at Nov. 23, 2019, 2:49 a.m.

Comments

Submit Cancel

tho

Highly Voted 5 years, 6 months ago

By amending the source in the Query Editor could achieve the same goal too though it is not the best solution.

upvoted 11 times

...

Vermonster

Highly Voted 5 years, 3 months ago

A is correct... Using "data source settings" is certainly more efficient but you could achieve the same result by modifying the source of each query

upvoted 7 times

...

CDL

Most Recent 4 years, 8 months ago

Both Correct. Data Source setting --> efficient Each Query Source --> forever (repetitive moves)

upvoted 2 times

...

lyniguez

4 years, 8 months ago

technically correct, A would work but take forever

upvoted 3 times

...

Eric777

5 years ago

In order for B to be correct, there needs to be some verbiage in the question that says something to the effect, "You must do this in the most effecient manner possible." - or something along those lines. B works, just not the best option.

upvoted 4 times

...

tho

5 years, 6 months ago

Upload the reference https://exceloffthegrid.com/power-query-source-data-location/

upvoted 4 times

...