Analyzing and Visualizing Data with Microsoft Power BI — Question 15

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because editing the source of each table query allows you to point to the tables in SQLProd without needing to redo the entire model. Option A would require re-importing all tables, which increases administrative effort. Option B involves deleting existing queries, which is unnecessary and inefficient. Option C does not specifically address linking the model to SQLProd's tables directly.