You are designing an ASP.NET Web application in Microsoft Visual Studio 2010. You plan
to deploy the application to multiple branch offices within your company. Each branch office
requires different settings for SQL Server connections. You need to centrally manage the
automatic configuration for each branch deployment. Which two approaches could you
recommend? (Each correct answer presents a complete solution. Choose two.)

A.
Store the connection strings in the database.

B.
Use MSDeploy.

C.
Use a separate web.config file for each branch office.

D.
Use configuration transformations.

Explanation: