BenchMark Quizzes by MDFT Pro

Connect Data Engineers To Correct Database

MDFT Academy is managing training solutions using multiple Azure SQL Server databases. Each client company has its own database provisioned in an Azure subscription managed by MDFT Academy.

The data engineers are interested in building a report to measure student performance using Power BI Desktop. Each client company may have different requirements for building the report. Each data engineer should work to build a report for a specific company, using a different database from their peers.

How should you support the data engineers to connect to the correct database for each company?

Choose all correct answers from the options below.

Explanations for each answer:

Create a new parameter in the report with the database connection details is correct. Parameters allow data engineers to change data sources from Power Query and switch databases in Power BI Service without republishing.
Create a PBIDS file for each company and send it to the data engineers is correct. PBIDS files simplify database connections by containing all connection details, requiring only credentials from the data engineers.
Create a read-write XMLA endpoint for each customer is incorrect. XMLA endpoints are for connecting to published datasets in Power BI service workspaces, not for connecting to source databases.
Share the Azure SQL Server connection string directly with all engineers via email is incorrect. Sharing connection strings via email is insecure and does not provide a managed or scalable solution for database access.

Learn more about Power BI data source management:

Power BI Database Connections

Exam Preparation Quiz

Connect Data Engineers To Correct Database