多项选择题

YouneedtoimprovetheperformanceofthetempdbdatabaseonSQL1……

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

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.

多项选择题YouneedtoidentifythecombinationsoftheWindowsoperatingsystemandSQLServer2005versionthatwillbethemostappropriateforthenewR&Dconfiguration，whichwillincludetheResearch，Parts，andEngineeringdatabases.Whichtwocombinationswillbethemostappropriate？（）

A.Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise Edition
B.Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise Edition
C.Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise Edition
D.Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition

单项选择题You plan to create a unique nonclustered index on the CustomerID， LastName， and FirstName columns of the CustomerData.Customers table in the CRM database. To aid in estimating the space requirements for the index， you identify the following variables： You need to identify the most significant additional variable that will increase the estimated index size. Which additional variable should you identify？（）

A.current number of rows
B.null bitmap
C.fill factor
D.automatically generated uniqueifier value

单项选择题YouwanttoconsolidatesomeofthedatabasesontoexistingSQLServercomputersuntiladditionalhardwarecanbepurchased.Youneedtoidentifywhichoftheservers，initscurrentconfiguration，cansupportadditionaldatabases.Youneedtoensurethatyoursolutionfulfillsthecompany’ssecuriyrequirementswhileallowingforfuturedatabasegrowthrequirements.Whichserveranddatabasecombinationcanbeused？（）

A.SQL3 with the OnlineReadOnly and HR databases
B.SQL4 with the TravelOnline and Storefront databases
C.SQL2 with the Storefront and TravelOnline databases
D.SQL2 with the Storefront and HR databases