Question 103 of 388
Single answerYou have the following three versions of an Azure SQL database:- Test- Production- DevelopmentYou have a dataset that uses the development database as a data source.You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.Which should you do?
ACreate a JSON file that contains the database server names. Import the JSON file to the dataset.
✓BCreate a parameter and update the queries to use the parameter.
CCreate a query for each database server and hide the development tables.
DSet the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
✓
Correct Answer: B
Create a parameter and update the queries to use the parameter.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.