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 itB. Configure the database to use a different TempDB on a remote serverC. Install a new instance for the database with a default collation the same as the databaseD. A separate server with a separate instance is the only option