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.
Bạn đang xem 19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P145 PPSX