70-432考试指南及题库分享.doc

70-432 考试资料TS:MS SQL Server 2008,Implementation and Maintenance科目编号：70-432 科目名称：TS:MS SQL Server 2008,Implementation and Maintenance语言（s）：英语，法语，德语，日语，俄语，西班牙语，葡萄牙语（巴西），中文（简体）考生：IT专业人士技术：Microsoft SQL Server 2008类型：监考考试相关分类：TS70-432 考试是 Microsoft 公司的 TS:MS SQL Server 2008,Implementation and Maintenance 认证考试官方代号，TS:MS SQL Server 2008,Implementation and Maintenance 认证作为全球IT领域专家 Microsoft 热门认证之一，是许多大中IT企业选择人才标准的必备条件。70-432 考试概述：Audience ProfileCandidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:IT generalists who work in environments in which SQL Server 2008 is part of an overall solutionIT professionals who manage systems that run SQL Server 2008IT professionals who work with third-party applications that are built on SQL Server 2008Developers who build applications that use SQL Server 2008Credit Toward CertificationWhen you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification(s):Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and MaintenanceExam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance: counts as credit toward the following certification(s):MCSA, MCSE70-432 考试大纲：Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.Installing and Configuring SQL Server 2008 (10 percent)Install SQL Server 2008 and related services.This objective may include but is not limited to: file locations; default paths; service accountsConfigure SQL Server instances.This objective may include but is not limited to: sp_configureConfigure SQL Server services. This objective may include but is not limited to: configuration manager; SQL browserConfigure additional SQL Server components. This objective may include but is not limited to: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replicationImplement database mail. This objective may include but is not limited to: set up and configureConfigure full-text indexing. This objective may include but is not limited to: enable/disable, index populationMaintaining SQL Server Instances (13 percent)Manage SQL Server Agent jobs.This objective may include but is not limited to: create and schedule jobs; notification of job execution; disable/enable jobs; change job step order; loggingManage SQL Server Agent alerts.This objective may include but is not limited to: performance condition alerts; SQL event alerts; Windows Management Instrumentation (WMI) alertsManage SQL Server Agent operators.This objective may include but is not limited to: operator schedules; fail safe operator; add a new operator; notification methodsImplement the declarative management framework (DMF).This objective may include but is not limited to: create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a conditionBack up a SQL Server environment. This objective may include but is not limited to: operating system-level conceptsManaging SQL Server Security (15 percent)Manage logins and server roles.This objective may include but is not limited to: create logins; disable/enable logins; security model (authentication mode); password policy enforcement; fixed server roles; alter loginsManage users and database roles. This objective may include but is not limited to: user mapping; user-defined roles; fixed roles; guest, public, dbo; creating and deleting user rolesManage SQL Server instance permissions.This objective may include but is not limited to: logon triggers; permissions vs. fixed role membership; cross-database ownership chaining; impersonationManage database permissions.This objective may include but is not limited to: impersonation; cross-database ownership chainingManage schema permissions and object permissions.This objective may include but is not limited to: manage schema ownershipAudit SQL Server instances.This objective may include but is not limited to: use DDL triggers and logon triggers; C2; common criteria; login failures; event notificationsManage transparent data encryption.This objective may include but is not limited to: impact of transparent data encryption on backupsConfigure surface area.This objective may include but is not limited to: sp_configureMaintaining a SQL Server Database (16 percent)Back up databases.This objective may include but is not limited to: full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backupRestore databases.This objective may include but is not limited to: online restores; full restores; differential restores; transaction log; file and filegroup restores; verifying restore; tail of the transaction logManage and configure databases.This objective may include but is not limited to: files, file groups, and related options; database options; recovery model; attach/detach dataManage database snapshots.This objective may include but is not limited to: create, drop, revertMaintain database integrity.This objective may include but is not limited to: DBCC CHECKDB; suspect pagesMaintain a database by using maintenance plans.This objective may include but is not limited to: Maintenance Plan Wizard; Maintenance Plan DesignerPerforming Data Management Tasks (14 percent)Import and export data.This objective may include but is not limited to: BCP; BULK INSERT; OPENROWSET; GUI toolsManage data partitions.This objective may include but is not limited to: switching data from one partition to another; add a filegroup; alter a partition function; alter a partition schemeImplement data compression.This objective may include but is not limited to: sparse columns; page/rowMaintain indexes.This objective may include but is not limited to: create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offlineManage collations.This objective may include but is not limited to: column collation; database collation; instance collationMonitoring and Troubleshooting SQL Server (13 percent)Identify SQL Server service problems.This objective may include but is not limited to: DB Engine service; SQL Agent service; SQL Browser serviceIdentify concurrency problems.This objective may include but is not limited to: blocks, locks, deadlocks, activity monitor; relevant Dynamic Management ViewsIdentify SQL Agent job execution problems.This objective may include but is not limited to: proxy accounts; credentials; job historyLocate error information.This objective may include but is not limited to: error log; agent log; job execution history; event logsOptimizing SQL Server Performance (10 percent)Implement Resource Governor.Use the Database Engine Tuning Advisor.Collect trace data by using SQL Server Profiler.Collect performance data by using Dynamic Management Views (DMVs).Collect performance data by using System Monitor.Use Performance Studio.Implementing High Availability (9 percent)Implement database mirroring.This objective may include but is not limited to: monitoring, configuring, failoverImplement a SQL Server clustered instance.This objective may include but is not limited to: monitoring, configuring, failoverImplement log shipping.This objective may include but is not limited to: monitoring, configuring, failoverImplement replication.This objective may include but is not limited to: monitoring, configuring, failover70-432 考试题库：Exam : Microsoft 70-432Title : TS:MS SQL Server 2008,Implementation and Maintenance1. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal?A. You should backup the master databaseB. You should backup the default.trc fileC. You should backup the SQL Server registry hive.D. You should backup the resource databaseAnswer: C2. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal?A. You should verify that the simple recovery model is used by the databaseB. You should verify that the full recovery model is used by the database.C. You should verify that the checksum page verify option is used by the databaseD. You should verify that the bulk-logged recovery model is used by the databaseAnswer: B3. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?A. A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.B. A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.C. A condition should be created. The condition targets the name of the stored procedure that is evaluated on changeD. A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.Answer: B4. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use?A. You should use local Service accountB. You should use network Service accountC. You should use domain accountD. You should use local System accountAnswer: C5. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?A. For the database, you should turn on the TRUSTWORTHY database optionB. For the database, the PAGE_VERIFY database option should be set to CHECKSUMC. For the database, the database compatibility level option should be set to 10.D. For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.Answer: B最新活动：Testinside考题大师权威Microsoft、Cisco、SUN、CIW、IBM、Nortel、HP、Oracle等各大IT认证题库，最新考题售价仅180元起。（时间有限！）机会不容错过！需要的朋友一定要抓住这个机会！下面开始我们的正文！70-432 考试资料TS:MS SQL Server 2008,Implementation and Maintenance科目编号：70-432科目名称：TS:MS SQL Server 2008,Implementation and Maintenance语言（s）： 英语，法语，德语，日语，俄语，西班牙语，葡萄牙语（巴西），中文（简体）考生： IT专业人士技术： Microsoft SQL Server 2008类型： 监考考试相关分类：TSTestinside题库价格：￥ 280.0070-432 考试是Microsoft公司的 TS:MS SQL Server 2008,Implementation and Maintenance 认证考试官方代号，TS:MS SQL Server 2008,Implementation and Maintenance 认证作为全球IT领域专家 Microsoft 热门认证之一，是许多大中IT企业选择人才标准的必备条件。70-432 考试概述：Audience ProfileCandidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work in environments in which databases are central to their job roles. These job roles include the following:IT generalists who work in environments in which SQL Server 2008 is part of an overall solutionIT professionals who manage systems that run SQL Server 2008IT professionals who work with third-party applications that are built on SQL Server 2008Developers who build applications that use SQL Server 2008Credit Toward CertificationWhen you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification(s):Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and MaintenanceExam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance: counts as credit toward the following certification(s):MCSA, MCSE70-432 考试大纲：Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.Installing and Configuring SQL Server 2008 (10 percent)Install SQL Server 2008 and related services.This objective may include but is not limited to: file locations; default paths; service accountsConfigure SQL Server instances.This objective may include but is not limited to: sp_configureConfigure SQL Server services.This objective may include but is not limited to: configuration manager; SQL browserConfigure additional SQL Server components.This objective may include but is not limited to: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replicationImplement database mail.This objective may include but is not limited to: set up and configureConfigure full-text indexing.This objective may include but is not limited to: enable/disable, index populationMaintaining SQL Server Instances (13 percent)Manage SQL Server Agent jobs.This objective may include but is not limited to: create and schedule jobs; notification of job execution; disable/enable jobs; change job step order; loggingManage SQL Server Agent alerts.This objective may include but is not limited to: performance condition alerts; SQL event alerts; Windows Management Instrumentation (WMI) alertsManage SQL Server Agent operators.This objective may include but is not limited to: operator schedules; fail safe operator; add a new operator; notification methodsImplement the declarative management framework (DMF).This objective may include but is not limited to: create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a conditionBack up a SQL Server environment.This objective may include but is not limited to: operating system-level conceptsManaging SQL Server Security (15 percent)Manage logins and server roles.This objective may include but is not limited to: create logins; disable/enable logins; security model (authentication mode); password policy enforcement; fixed server roles; alter loginsManage users and database roles.This objective may include but is not limited to: user mapping; user-defined roles; fixed roles; guest, public, dbo; creating and deleting user rolesManage SQL Server instance permissions.This objective may include but is not limited to: logon triggers; permissions vs. fixed role membership; cross-database ownership chaining; impersonationManage database permissions.This objective may include but is not limited to: impersonation; cross-database ownership chainingManage schema permissions and object permissions.This objective may include but is not limited to: manage schema ownershipAudit SQL Server instances.This objective may include but is not limited to: use DDL triggers and logon triggers; C2; common criteria; login failures; event notificationsManage transparent data encryption.This objective may include but is not limited to: impact of transparent data encryption on backupsConfigure surface area.This objective may include but is not limited to: sp_configureMaintaining a SQL Server Database (16 percent)Back up databases.This objective may include but is not limited to: full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backupRestore databases.This objective may include but is not limited to: online restores; full restores; differential restores; transaction log; file and filegroup restores; verifying restore; tail of the transaction logManage and configure databases.This objective may include but is not limited to: files, file groups, and related optio