A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each
SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
·It must have a stale name as one of the report parameters.

·It must provide a daily summary of manufacturing activity of a selected state.
·It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.
Build one report for each state and instruct users to execute reports as needed.

B.
Use a report-specific data source that defines an expression-based connection string based on the state parameter.

C.
Build a centralized data repository, schedule a regular Extract Transform, and Load (ETL) process on all manufacturing data, and then use the repository to
generate the report.

D.
Use a shared data source that defines an expression-based connection string based on the state parameter.