Which two actions should you recommend?

You are designing an n-tier solution that connects to a Microsoft SQL Server 2008
database. You plan to deploy the database to development machines and to a staging
database server from within Microsoft Visual Studio 2010. You plan to set up separate build
configurations for development and staging. You also plan to deploy to multiple production
database servers managed by an outside vendor. You must not allow the outside vendor to
access the visual Studio projects. You need to recommend an approach for configuring and
deploying the production database servers. Which two actions should you recommend?
(Each correct answer presents part of the solution. Choose two.)

You are designing an n-tier solution that connects to a Microsoft SQL Server 2008
database. You plan to deploy the database to development machines and to a staging
database server from within Microsoft Visual Studio 2010. You plan to set up separate build
configurations for development and staging. You also plan to deploy to multiple production
database servers managed by an outside vendor. You must not allow the outside vendor to
access the visual Studio projects. You need to recommend an approach for configuring and
deploying the production database servers. Which two actions should you recommend?
(Each correct answer presents part of the solution. Choose two.)

A.
Use SQL Server 2008 Management Studio to deploy the production databases.

B.
Use VSDBCMD to deploy the production databases.

C.
Use a SQL Server 2008 Database Project.

D.
Use a Visual Basic SQL CLR Database Project.



Leave a Reply 0

Your email address will not be published. Required fields are marked *