单项选择题
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.
相关考题
-
多项选择题
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. -
单项选择题
YouneedtoimprovethespeedofbackupsonSQL1.Managementhasapprovedthepurchaseofadditionalharddisksforthisserver.Whatshouldyoudo？（）
A.Configure the hard disks as a RAID-0 array， and store the backups on this new array.
B.Configure the hard disks as a RAID-5 array， and store the backups on this new array.
C.Configure the hard disks as a RAID-10 array， and store the backups on this new array.
D.Configure the hard disks as a spanned volume， and store the backups on this new volume.
E.Use the hard disks to extend the volume that currently holds SQL Server backups.
