单项选择题

YouneedtodesigntheconsolidationplanforSQL1，SQL2，andSQL3……

You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）

A.one SQL Server 2005 computer with one instance
B.two SQL Server 2005 computers， each with two instances
C.two SQL Server computers， one with one instance and one with three instances
D.one SQL Server 2005 computer with two instances

<上一题目录下一题>

热门试题

单项选择题YouneedtodesigntheconsolidationstrategyforthePromotionsandPartnersdatabases.Youwanttochooseastrategythatresultsinthebestdatabaseperformancewhilemaintainingthepermissionsofendusersineachdatabase.Whatconsolidationstrategyshouldyouchoose？（）

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.

单项选择题YouneedtomigratetheDeliveryVans，AirlinePreferences，andSeasonalContractorsdatabasesintothedatacenter.Whatshouldyoudo？（）

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.

单项选择题YouneedtodesignastrategyforidentifyingthenumberofinstancesthatanyoneSQLServer2005computerwillsupport.Whatshouldyoudo？（）

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.

多项选择题YouneedtoimprovetheperformanceofthetempdbdatabaseonSQL1.Whichtwoactionsshouldyouperform？（）

A.Move tempdb onto a faster disk volume.
B.Increase the initial size of tempdb to 1.5 GB
C.Increase the size of the data files in the Tracking database.
D.Decrease the file growth increment for tempdb to 25 MB
E.Use more local temporary tables and fewer global temporary tables in the Tracking database.

多项选择题YouneedtoreviewthecurrentstoragesystemanddecideonthebestconfigurationforthetempdbdatabaseonSQL1toimprovetempdbperformance.Yoursolutionmustensurethatcompanyrequirementsandpoliciesarefulfilled.Whichtwoactionsshouldyouperform？（）

A.Create a RAID-1 set， and move tempdb to this drive set.
B.Create a RAID-0 set， and move tempdb to this drive set.
C.Set the starting size of tempdb to 3 GB
D.Create a RAID-0 set， and move tempdb and the user database with the largest index to this drive set.
E.Disable automatic file growth on tempdb.