70432考试指南及题库分享.docx

70432考试指南及题库分享.docx

《70432考试指南及题库分享.docx》由会员分享，可在线阅读，更多相关《70432考试指南及题库分享.docx（18页珍藏版）》请在冰豆网上搜索。

70432考试指南及题库分享

70-432考试资料

TS:

MSSQLServer@2008,ImplementationandMaintenance

科目编号：

70-432

科目名称：

TS:

MSSQLServer@2008,ImplementationandMaintenance

语言（s）：

英语，法语，德语，日语，俄语，西班牙语，葡萄牙语（巴西），中文（简体）

考生：

IT专业人士

技术：

MicrosoftSQLServer2008

类型：

监考考试

相关分类：

TS

70-432考试是Microsoft公司的TS:

MSSQLServer@2008,ImplementationandMaintenance认证考试官方代号，TS:

MSSQLServer@2008,ImplementationandMaintenance认证作为全球IT领域专家Microsoft热门认证之一，是许多大中IT企业选择人才标准的必备条件。

70-432考试概述：

AudienceProfile

CandidatesshouldhaveonetotwoyearsofexperienceusingSQLServer2008ortwotothreeyearsofexperienceusingapreviousversionofSQLServer.CandidatesforthisexamareITprofessionalswhohavejobsinwhichdatabaseadministrationistheirmainareaofresponsibility,ortheyworkinenvironmentsinwhichdatabasesarecentraltotheirjobroles.Thesejobrolesincludethefollowing:

ITgeneralistswhoworkinenvironmentsinwhichSQLServer2008ispartofanoverallsolution

ITprofessionalswhomanagesystemsthatrunSQLServer2008

ITprofessionalswhoworkwiththird-partyapplicationsthatarebuiltonSQLServer2008

DeveloperswhobuildapplicationsthatuseSQLServer2008

CreditTowardCertification

WhenyoupassExam70-432:

TS:

MicrosoftSQLServer2008,ImplementationandMaintenance,youcompletetherequirementsforthefollowingcertification（s）:

MicrosoftCertifiedTechnologySpecialist（MCTS）:

MicrosoftSQLServer2008,ImplementationandMaintenance

Exam70-432:

TS:

MicrosoftSQLServer2008,ImplementationandMaintenance:

countsascredittowardthefollowingcertification（s）:

MCSA,MCSE

70-432考试大纲：

SkillsBeingMeasured

Thisexammeasuresyourabilitytoaccomplishthetechnicaltaskslistedbelow.

Thepercentagesindicatetherelativeweightofeachmajortopicareaontheexam.

InstallingandConfiguringSQLServer2008（10percent）

InstallSQLServer2008andrelatedservices.

Thisobjectivemayincludebutisnotlimitedto:

filelocations;defaultpaths;serviceaccounts

ConfigureSQLServerinstances.

Thisobjectivemayincludebutisnotlimitedto:

sp_configure

ConfigureSQLServerservices.

Thisobjectivemayincludebutisnotlimitedto:

configurationmanager;SQLbrowser

ConfigureadditionalSQLServercomponents.

Thisobjectivemayincludebutisnotlimitedto:

SQLServerIntegrationServices（SSIS）,SQLServerAnalysisServices（SSAS）,SQLServerReportingServices（SSRS）,replication

Implementdatabasemail.

Thisobjectivemayincludebutisnotlimitedto:

setupandconfigure

Configurefull-textindexing.

Thisobjectivemayincludebutisnotlimitedto:

enable/disable,indexpopulation

MaintainingSQLServerInstances（13percent）

ManageSQLServerAgentjobs.

Thisobjectivemayincludebutisnotlimitedto:

createandschedulejobs;notificationofjobexecution;disable/enablejobs;changejobsteporder;logging

ManageSQLServerAgentalerts.

Thisobjectivemayincludebutisnotlimitedto:

performanceconditionalerts;SQLeventalerts;WindowsManagementInstrumentation（WMI）alerts

ManageSQLServerAgentoperators.

Thisobjectivemayincludebutisnotlimitedto:

operatorschedules;failsafeoperator;addanewoperator;notificationmethods

Implementthedeclarativemanagementframework（DMF）.

Thisobjectivemayincludebutisnotlimitedto:

createapolicy;verifyapolicy;scheduleapolicycompliancecheck;enforceapolicy;createacondition

BackupaSQLServerenvironment.

Thisobjectivemayincludebutisnotlimitedto:

operatingsystem-levelconcepts

ManagingSQLServerSecurity（15percent）

Manageloginsandserverroles.

Thisobjectivemayincludebutisnotlimitedto:

createlogins;disable/enablelogins;securitymodel（authenticationmode）;passwordpolicyenforcement;fixedserverroles;alterlogins

Manageusersanddatabaseroles.

Thisobjectivemayincludebutisnotlimitedto:

usermapping;user-definedroles;fixedroles;guest,public,dbo;creatinganddeletinguserroles

ManageSQLServerinstancepermissions.

Thisobjectivemayincludebutisnotlimitedto:

logontriggers;permissionsvs.fixedrolemembership;cross-databaseownershipchaining;impersonation

Managedatabasepermissions.

Thisobjectivemayincludebutisnotlimitedto:

impersonation;cross-databaseownershipchaining

Manageschemapermissionsandobjectpermissions.

Thisobjectivemayincludebutisnotlimitedto:

manageschemaownership

AuditSQLServerinstances.

Thisobjectivemayincludebutisnotlimitedto:

useDDLtriggersandlogontriggers;C2;commoncriteria;loginfailures;eventnotifications

Managetransparentdataencryption.

Thisobjectivemayincludebutisnotlimitedto:

impactoftransparentdataencryptiononbackups

Configuresurfacearea.

Thisobjectivemayincludebutisnotlimitedto:

sp_configure

MaintainingaSQLServerDatabase（16percent）

Backupdatabases.

Thisobjectivemayincludebutisnotlimitedto:

fullbackups;differentialbackups;transactionlog;compressedbackups;fileandfilegroupbackups;verifyingbackup

Restoredatabases.

Thisobjectivemayincludebutisnotlimitedto:

onlinerestores;fullrestores;differentialrestores;transactionlog;fileandfilegrouprestores;verifyingrestore;tailofthetransactionlog

Manageandconfiguredatabases.

Thisobjectivemayincludebutisnotlimitedto:

files,filegroups,andrelatedoptions;databaseoptions;recoverymodel;attach/detachdata

Managedatabasesnapshots.

Thisobjectivemayincludebutisnotlimitedto:

create,drop,revert

Maintaindatabaseintegrity.

Thisobjectivemayincludebutisnotlimitedto:

DBCCCHECKDB;suspectpages

Maintainadatabasebyusingmaintenanceplans.

Thisobjectivemayincludebutisnotlimitedto:

MaintenancePlanWizard;MaintenancePlanDesigner

PerformingDataManagementTasks（14percent）

Importandexportdata.

Thisobjectivemayincludebutisnotlimitedto:

BCP;BULKINSERT;OPENROWSET;GUItools

Managedatapartitions.

Thisobjectivemayincludebutisnotlimitedto:

switchingdatafromonepartitiontoanother;addafilegroup;alterapartitionfunction;alterapartitionscheme

Implementdatacompression.

Thisobjectivemayincludebutisnotlimitedto:

sparsecolumns;page/row

Maintainindexes.

Thisobjectivemayincludebutisnotlimitedto:

createspatialindexes;createpartitionedindexes;clusteredandnon-clusteredindexes;XMLindexes;disableandenableindexes;filteredindexonsparsecolumns;indexeswithincludedcolumns;rebuilding/reorganizingindexes;online/offline

Managecollations.

Thisobjectivemayincludebutisnotlimitedto:

columncollation;databasecollation;instancecollation

MonitoringandTroubleshootingSQLServer（13percent）

IdentifySQLServerserviceproblems.

Thisobjectivemayincludebutisnotlimitedto:

DBEngineservice;SQLAgentservice;SQLBrowserservice

Identifyconcurrencyproblems.

Thisobjectivemayincludebutisnotlimitedto:

blocks,locks,deadlocks,activitymonitor;relevantDynamicManagementViews

IdentifySQLAgentjobexecutionproblems.

Thisobjectivemayincludebutisnotlimitedto:

proxyaccounts;credentials;jobhistory

Locateerrorinformation.

Thisobjectivemayincludebutisnotlimitedto:

errorlog;agentlog;jobexecutionhistory;eventlogs

OptimizingSQLServerPerformance（10percent）

ImplementResourceGovernor.

UsetheDatabaseEngineTuningAdvisor.

CollecttracedatabyusingSQLServerProfiler.

CollectperformancedatabyusingDynamicManagementViews（DMVs）.

CollectperformancedatabyusingSystemMonitor.

UsePerformanceStudio.

ImplementingHighAvailability（9percent）

Implementdatabasemirroring.

Thisobjectivemayincludebutisnotlimitedto:

monitoring,configuring,failover

ImplementaSQLServerclusteredinstance.

Thisobjectivemayincludebutisnotlimitedto:

monitoring,configuring,failover

Implementlogshipping.

Thisobjectivemayincludebutisnotlimitedto:

monitoring,configuring,failover

Implementreplication.

Thisobjectivemayincludebutisnotlimitedto:

monitoring,configuring,failover

70-432考试题库：

Exam:

Microsoft70-432

Title:

TS:

MSSQLServer@2008,ImplementationandMaintenance

1.YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.YouconfiguretheSQLServerinstancetousethe-T1222and-T1204traceflagsduringstartup.Youmustmakesurethatyourfailurerecoveryplanperformsbackupoftheuseofthetraceflags.Sowhatactionshouldyouperformtoachievethisgoal?

A.Youshouldbackupthemasterdatabase

B.Youshouldbackupthedefault.trcfile

C.YoushouldbackuptheSQLServerregistryhive.

D.Youshouldbackuptheresourcedatabase

Answer:

C

2.YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.OnDB1,quitefewloggedoperationsareperformed.NowaccordingtotherequirementofthecompanyCIO,youmustvalidatethatthedatabasecanberestoredtoaspecificpointintime.Sowhatactionshouldyouperformtoachievethisgoal?

A.Youshouldverifythatthesimplerecoverymodelisusedbythedatabase

B.Youshouldverifythatthefullrecoverymodelisusedbythedatabase.

C.Youshouldverifythatthechecksumpageverifyoptionisusedbythedatabase

D.Youshouldverifythatthebulk-loggedrecoverymodelisusedbythedatabase

Answer:

B

3.YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2