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.