YOU ARE RESPONSIBLE FOR A LARGE-CAPACITY SERVER THAT HAS A DEFAULT...

19. You are responsible for a large-capacity server that has a default instance of

SQL Server 2008 installed and hosts databases for multiple applications

belonging to several of your customers. A new database needs to be moved to

the server, which has a different collation, and the collation of TempDB needs

to match it. You can’t change the collation for your existing TempDB because

it will affect all the applications. What could you do?

A. Create another TempDB with the right collation and configure the new

database to use it

B. Configure the database to use a different TempDB on a remote server

C. Install a new instance for the database with a default collation the same as

the database

D. A separate server with a separate instance is the only option

Correct Answer & Explanation: C. You can have only one TempDB database

per instance, and it might be feasible to install a second instance on a large

capacity server.

Incorrect Answers & Explanations: A, B, D. Answer A is incorrect; you can

have only one TempDB per instance. Answer B is incorrect because you

cannot configure to use a remote TempDB. Answer D is incorrect because it

isn’t the only option.