單項(xiàng)選擇題

You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）

A.Place each database in a separate instance running on SQL2.
B.Place each database in a separate instance running on SQL3.
C.Place both databases in a single instance running on SQL2.
D.Place both databases in a single instance running on SQL3.

你可能感興趣的試題

單項(xiàng)選擇題

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

A.Install a separate instance of SQL Server 2005 for each of the databases on a single server.
B.Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
C.Import the data from each of the databases into a single database in an instance of SQL Server 2005.
D.Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

單項(xiàng)選擇題

You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）

A.Specify that each server must have one instance for each customer.
B.Specify that each server must each have only one instance.
C.Specify that each server must have one instance for each database that is hosted on that server.
D.Specify that each server must have one instance for each customer who has one or more databases that are hosted on that server.

You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）

你可能感興趣的試題

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

You need to design a strategy for identifying the number of instances that any one SQL Server 2005 computer will support. What should you do？（）