nerdexam
Microsoft

70-518 · Question #88

70-518 Question #88: Real Exam Question with Answer & Explanation

The correct answer is A. Use SQL Server 2008 Management Studio to deploy the production databases. B. Use VSDBCMD to deploy the production databases.. See the full explanation below for the reasoning.

Question

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.)

Options

  • AUse SQL Server 2008 Management Studio to deploy the production databases.
  • BUse VSDBCMD to deploy the production databases.
  • CUse a Visual C# SQL CLR Database Project.
  • DUse a SQL Server 2008 Database Project.

Community Discussion

No community discussion yet for this question.

Full 70-518 Practice
You are designing an n-tier solution that connects to a Microsoft... | 70-518 Q#88 Answer | NerdExam