Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 42 discussion

Actual exam question from Microsoft's 70-778

Question #: 42
Topic #: 1

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd.
You create a new Power BI Desktop model that uses 120 tables from SQLDev.
You plan to publish the Power BI file to the Power BI service.
You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort.
What should you do from Query Editor before you publish the model?

A. Create a new connection to SQLProd, and then import the tables from SQLProd.
B. Delete the existing queries, and then add new data sources.
C. Configure the Data source settings.
D. Edit the source of each table query.

Show Suggested Answer

Suggested Answer: D 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data

by TiaanR at July 9, 2019, 10:04 a.m.

Comments

Submit Cancel

TiaanR

Highly Voted 5 years, 11 months ago

D will work, but C will be easier to do.

upvoted 27 times

...

SteveKarr

Highly Voted 5 years, 10 months ago

Ans should be C, as the Question explicitly asks to minimize effort.

upvoted 16 times

...

Rupangi

Most Recent 3 years, 6 months ago

correct answer is c

upvoted 1 times

...

EshaM

4 years, 4 months ago

hello guys this article (https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/)shows how to change data through Query Editor >>Data Source setting as well as through Query editor >> Query Setting >> Source. So both option C and D are justified. But its required least amount of administrative effort so will go for option C.

upvoted 1 times

...

cromastro

4 years, 9 months ago

It's C. The link given states this explicitly: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data#to-change-the-server-name-after-initial-connection

upvoted 1 times

...

ritzxell

4 years, 9 months ago

Definitely C I don't want to edit source for 120 tables I would rather do it once.

upvoted 1 times

...

LeoLee

4 years, 10 months ago

C is the correct answer

upvoted 1 times

...

Waltmas

4 years, 11 months ago

go to query editor, select your table and on the right hand side under Applied Steps click settings icon. i go with answer C

upvoted 1 times

...

Onkar26

4 years, 11 months ago

Correct Answer is C. Configure the Data source settings.

upvoted 2 times

...

Amitkhanna

5 years ago

clearly mention in the question last point "What should you do from Query Editor before you publish the model"? So answer is correct D

upvoted 6 times

Mange

4 years, 12 months ago

You can change the datasource settings from the Query Editor, so I go for C

upvoted 1 times

...

Echicken69

4 years, 12 months ago

I'm confused as both C & D are correct "Technically". C implies that you can go to File > Options and settings > Options then select the DataSource. Whereas D is saying Query Editor > Select the table > Change the Data Source from there. But then again you can just go in to the Query Editor > go to the first step of the query which is always "Source" and change it there instead of going through 120 tables and changing those sources... https://community.powerbi.com/t5/Desktop/How-to-replace-Data-Source-for-existing-report/td-p/58947#:~:text=%40ivyhai%20In%20power%20bi%20desktop,data%20sources%20and%20chnage%20source. The Applied Steps: Query Editor > SE

upvoted 1 times

...

EshaM

4 years, 4 months ago

Exactly because it literally asks you what should you do FROM Query editor. Query editor >> Query Settings >> Source >> Advance Editor >> edit the code from there....

upvoted 1 times

...

Eric777

5 years ago

I'm leaning toward C also. The question specifically says, "The solution must minimize administrative effort." Changing 120 settings does not minimize effort. The question also says, "You have two Microsoft SQL Server database servers . . .". We don't have vendor incompatability here either. Did we miss something? Also, the reference link actually says, "After you create a Power BI Desktop file with an explore live connection, there might be some cases where you want to switch the connection to a different server. For example, if you created your Power BI Desktop file when connecting to a development server, and before publishing to the Power BI service, you want to switch the connection to production server." So again, what did we miss?

upvoted 3 times

...

ArpanT

5 years ago

Has to be C

upvoted 1 times

...

maryl

5 years, 2 months ago

Even the referenced link doesn't confirm the answer. For example, if you created your Power BI Desktop file when connecting to a development server, and before publishing to the Power BI service, you want to switch the connection to production server. To change the server name: Select Edit Queries from the Home tab. In the SQL Server Analysis Services database window, enter the new Server name, and then select OK.

upvoted 1 times

...