YouadministeraSQLServer2008instance.Theinstancerunsonacomputerthathasthefollowingfeatures:A64-GBRAM Fourquad-coreprocessors Severalindependentphysicalraidvolumes Youplantoimplementatransactionaldatabaseontheinstance.ThedatabaseisexpectedtohaveahighvolumeofINSERT,UPDATE,andDELETEactivities.Theactivitiesincludecreationofnewtables.Youneedtooptimizetheperformanceofthedatabasebymaximizingdiskbandwidthandreducingthecontentioninthestorageallocationstructures.Whatshouldyoudo?()A.Createmultipledatafilesforthedatabase.B.Placedatabaseandlogfilesonthesamevolume.C.Configuretheaffinitymaskoptionappropriately.D.ConfiguretheaffinityI/Omaskoptionappropriately.

YouadministeraSQLServer2008instance.Theinstancerunsonacomputerthathasthefollowingfeatures:A64-GBRAM Fourquad-coreprocessors Severalindependentphysicalraidvolumes Youplantoimplementatransactionaldatabaseontheinstance.ThedatabaseisexpectedtohaveahighvolumeofINSERT,UPDATE,andDELETEactivities.Theactivitiesincludecreationofnewtables.Youneedtooptimizetheperformanceofthedatabasebymaximizingdiskbandwidthandreducingthecontentioninthestorageallocationstructures.Whatshouldyoudo?()

A.Createmultipledatafilesforthedatabase.

B.Placedatabaseandlogfilesonthesamevolume.

C.Configuretheaffinitymaskoptionappropriately.

D.ConfiguretheaffinityI/Omaskoptionappropriately.


相关考题: