微软MCITPDatabase Administrator认证考试题库1Word格式文档下载.docx
- 文档编号:21717163
- 上传时间:2023-01-31
- 格式:DOCX
- 页数:64
- 大小:57.14KB
微软MCITPDatabase Administrator认证考试题库1Word格式文档下载.docx
《微软MCITPDatabase Administrator认证考试题库1Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《微软MCITPDatabase Administrator认证考试题库1Word格式文档下载.docx(64页珍藏版)》请在冰豆网上搜索。
ThespaceutilizedbytheProfilecolumnshouldbecuttotheleast.
Inaddition,areasonableperformanceshouldbemaintainedtoretrievethecontentofthecolumn.
Whichactionwillyouperform?
A.
ROWcompressionshouldbeutilizedfortheEmployeeDatatable.
B.
TheProfilecolumnshouldbestoredbyutilizingfilestreamstorage,andtheNTFSfilesystemcompressionshouldbeutilized.
C.
PAGELEVELcompressionshouldbeutilizedfortheEmployeeDatatable.
D.
TheProfilecolumnshouldbeimplementedasaCLRuser-definedtype.
Answer:
B
Explanation/Reference:
Muchofthedatathatiscreatedeverydayisunstructureddata,suchastextdocuments,images,andvideos.Thisunstructureddataisoftenstoredoutsidethedatabase,separatefromitsstructureddata.Thisseparationcancausedatamanagementcomplexities.Or,ifthedataisassociatedwithstructuredstorage,thefilestreamingcapabilitiesandperformancecanbelimited.
FILESTREAMintegratestheSQLServerDatabaseEnginewithanNTFSfilesystembystoringvarbinary(max)binarylargeobject(BLOB)dataasfilesonthefilesystem.Transact-SQLstatementscaninsert,update,query,search,andbackupFILESTREAMdata.Win32filesysteminterfacesprovidestreamingaccesstothedata.
FILESTREAMusestheNTsystemcacheforcachingfiledata.ThishelpsreduceanyeffectthatFILESTREAMdatamighthaveonDatabaseEngineperformance.TheSQLServerbufferpoolisnotused;
therefore,thismemoryisavailableforqueryprocessing.
Note:
FILESTREAMdataisnotencryptedevenwhentransparentdataencryptionisenabled.
QUESTION2
Inthecompany,yourjobistoimplementsolutionsonsecurity,troubleshooting,deploymentandoptimization.
ASQLServer2008instanceshouldbemanaged.
Itisreportedbythecustomersthattheserverperformancedegradedduetoanewlyimplementedprocess.
DynamicManagementViewsisutilizedtoconfirmthatnolongrunningqueriesexist.Theoperatingsystemperformancedatashouldbecorrelatedwiththeactualqueryexecutiontrace,andtheleastadministrativeeffortshouldbeutilized.
Whichactionwillyouperformtofinishthetask?
Tofinishthetask,DataCollectorshouldbeutilized.
Tofinishthetask,theSQLdiag.exeutilityshouldbeutilized.
Tofinishthetask,SQLServerProfilerandthetracerpt.exeutilityshouldbeutilized.
Tofinishthetask,SQLServerProfilerandSystemMonitorshouldbeutilized.
D
SQLServerprofilerdisplaysdataaboutalargenumberofSQLServerevents.WhereasWindowsSystemMonitorgraphicallydisplaysinformationabouttheserverinternals.YoucanmergethetwosetsofinformationandwalkthroughascenarioviewingbothperspectivesusingSQLServerProfiler.
Tosetupthedual-perspectiveexperience,youneedtosimultaneouslycaptureserverperformanceusingbothPerformanceMonitor’sCounterLogsandSQLServerProfiler.Thestepstodothisarelistedbelow:
1.ConfigureSystemMonitorwiththeexactcountersyouwanttoviewlater.Besuretogetthescaleandeverythingjustright.SetuptheCounterLogtotheexactsameconfiguration.
2.ConfigureProfilerwiththerightsetoftraceevents.TheymustincludethestartandendtimedatacolumnssothatProfilercanintegratethetwologslater.Savetheprofilerandcloseprofiler.
3.ManuallystarttheCounterLog.OpenSQLProfilertracecodetostarttheserver-sidetrace.
4.Whenthetestiscomplete,stopboththecounterLogandtheserversidetrace.YouneedtostoptheSQLProfilerwhichisanegativepointinthis.
5.Openprofilerandopenthesavedtracefile.
6.UsetheFile->
ImportPerformanceDatamenucommandtoimporttheCounterLog.Youhavetheoptionofselectingonlytheimportantcountersfromtheperformancemonitor.Therewillbeperformanceissuesifyouselecttoomanycounters.
Source:
http:
//www.sql-server-
QUESTION3
Inthecompany,yourjobistoimplementsolutionsonsecurity,troubleshooting,deploymentandoptimization.ASQLServer2008infrastructureismanagedbyyou.
Thereisadatabaseintheinstance,andtheday-to-daybusinessofyourcompanyrequiresthedatabase.Whenreportsareexecuted,slowresponsetimewillbeexperiencedbyUsers.
Aperformancemonitoringstrategywillbeimplementedbyyousoastohavethreeaspectsofdatacapturedandstored:
Blockinganddeadlockinformation,
ExecutedTransact-SQLstatements
QueryactivityandCountersfordisk,CPU,andmemory.
Youarerequiredtoutilizetheleastamountofadministrativeefforttoimplementthemonitoringprocess.
Tofinishthetask,theclient-sideprofilertraceshouldbeutilized.
Tofinishthetask,thedynamicmanagementviewsshouldbeutilized.
Tofinishthetask,thedatacollectorshouldbeutilized.
Tofinishthetask,theSystemMonitorcounterlogtraceshouldbeutilized.
C
SQLServer2008providesadatacollectorthatyoucanusetoobtainandsavedatathatisgatheredfromseveralsources.Thedatacollectorenablesyoutousedatacollectioncontainers,whichenableyoutodeterminethescopeandfrequencyofdatacollectiononaSQLServerserversystem.
Thedatacollectorprovidespredefinedcollectortypesthatyoucanusefordatacollection.Thecollectortypesprovidetheactualmechanismforcollectingdataanduploadingittothemanagementdatawarehouse.Forthisreleaseofthedatacollector,thefollowingcollectortypeisprovided.
InThisSection
Topic
Description
T-SQLQueryCollectorType
DescribesthestructureandbehavioroftheT-SQLQuerycollectortype.
SQLTraceCollectorType
DescribesthestructureandbehavioroftheSQLTracecollectortype.
PerformanceCountersCollectorType
DescribesthestructureandbehaviorofthePerformanceCounterscollectortype.
QueryActivityCollectorType
DescribesthestructureandbehavioroftheQueryActivitycollectortype.
QUESTION4
Inthecompany,yourjobistoimplementsolutionsonsecurity,troubleshooting,deploymentandoptimization.ASQLServer2008instanceshouldbemanagedbyyou.
Thecomputeronwhichtheinstancerunhasthefollowingthreefeatures:
a64-GBRAM,fourquad-coreprocessors,andseveralindependentphysicalraidvolumes
Atransactionaldatabasewillbeimplementedontheinstance.Inaddition,thedatabaseshouldhaveahighvolumeofINSERT,UPDATE,andDELETEactivities.
Creationofnewtablesiscontainedbytheactivities.
Youneedtomaximizediskbandwidthanddecreasethecontentioninthestorageallocationstructuressoastohavetheperformanceofthedatabaseoptimized.
Tofinishthetask,databaseandlogfilesshouldbeplacedonthesamevolume.
Tofinishthetask,theaffinitymaskoptionshouldbeconfiguredproperly.
Tofinishthetask,multipledatafilesshouldbecreateforthedatabase.
Tofinishthetask,theaffinityI/Omaskoptionshouldbeconfiguredproperly.
Ifyourdatabaseisverylargeandverybusy,multiplefilescanbeusedtoincreaseperformance.Hereisoneexampleofhowyoumightusemultiplefiles.Let'
ssayyouhaveasingletablewith10millionrowsthatisheavilyqueried.Ifthetableisinasinglefile,suchasasingledatabasefile,thenSQLServerwouldonlyuseonethreadtoperformareadoftherowsinthetable.Butifthetableweredividedintothreephysicalfiles,thenSQLServerwouldusethreethreads(oneperphysicalfile)toreadthetable,whichpotentiallycouldbefaster.Inaddition,ifeachfilewereonitsownseparatephysicaldiskordiskarray,theperformancegainwouldevenbegreater.
Essentially,themorefilesthatalargetableisdividedinto,thegreaterthepotentialperformance.Ofcoursethereisapointwheretheadditionalthreadsaren'
tofmuchusewhenyoumaxouttheserver'
sI/O.ButupuntilyoudomaxouttheI/O,additionalthreads(andfiles)shouldincreaseperformance
SOURCE:
http:
QUESTION5
YouareaprofessionallevelSQLSever2008Database
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 微软MCITPDatabase Administrator认证考试题库1 微软 MCITPDatabase Administrator 认证 考试 题库
链接地址:https://www.bdocx.com/doc/21717163.html