nerdexam
Microsoft

70-450 · Question #86

You have a server that contains a default SQL Server 2005 instance. You need to install a SQL Server 2008 instance for a new application on the same server. The new application requires SQL Server…

The correct answer is B. Install SQL Server 2008 as a named instance. See the full explanation below for the reasoning.

Question

You have a server that contains a default SQL Server 2005 instance. You need to install a SQL Server 2008 instance for a new application on the same server. The new application requires SQL Server 2008 functionality. You need to ensure that both database instances are available for their respective certified third- party applications. The existing application environments remain unchanged. What should you do?

Options

  • AInstall SQL Server 2008 as the default instance.
  • BInstall SQL Server 2008 as a named instance.
  • CUpgrade the SQL Server 2005 application to use SQL Server 2008.
  • DUpgrade the SQL Server 2005 instance to a SQL Server 2008 instance.

How the community answered

(19 responses)
  • A
    5% (1)
  • B
    74% (14)
  • C
    5% (1)
  • D
    16% (3)

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice