多项选择题
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?()
单项选择题 YouneedtoimprovethespeedofbackupsonSQL1.Managementhasapprovedthepurchaseofadditionalharddisksforthisserver.Whatshouldyoudo?()
多项选择题 YouneedtoidentifythecombinationsoftheWindowsoperatingsystemandSQLServer2005versionthatwillbethemostappropriateforthenewR&Dconfiguration,whichwillincludetheResearch,Parts,andEngineeringdatabases.Whichtwocombinationswillbethemostappropriate?()