2012年微软认证考试备考的朋友，为了能让大家找到更多的复习资料，微软认证考试网特搜集了有关2012年微软认证考试辅导资料，帮助大家复习，祝大家考试顺利
维护SQL Server数据库（百分之十六） 
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 backup这个目标可能包括但不限于：完整备份，差异备份;交易记录;压缩备份，档案和档案群组备份;核查备份 

Restore 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 log这个目标可能包括但不限于：在线恢复;全面恢复;差别恢复;交易记录;档案和档案群组恢复;核查恢复;尾巴交易日志 

Manage and configure databases.管理和配置数据库。 
This objective may include but is not limited to: files, file groups, and related options; database options; recovery model; attach/detach data这个目标可能包括但不限于：档案，档案的群体，和相关办法;数据库选择;复苏模型;连接/分离数据 

Manage database snapshots.管理数据库的快照。 
This objective may include but is not limited to: create, drop, revert这个目标可能包括但不限于：制作，辍学，回复 

Maintain database integrity.保持数据库的完整性。 
This objective may include but is not limited to: DBCC CHECKDB; suspect pages这个目标可能包括但不限于：的DBCC CHECKDB ;怀疑页 

Maintain a database by using maintenance plans.维持一个数据库，使用维修计划。 
This objective may include but is not limited to: Maintenance Plan Wizard; Maintenance Plan Designer这个目标可能包括但不限于：维护计划向导;维护计划设计师 

Performing Data Management Tasks (14 percent)表演数据管理工作（百分之十四） 
Import and export data.进口和出口数据。 
This objective may include but is not limited to: BCP; BULK INSERT; OPENROWSET; GUI tools这个目标可能包括但不限于：商业银行;批量插入; OPENROWSET ; GUI工具 

Manage 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 scheme这个目标可能包括但不限于：交换数据从一个分区到另一个;添加一个文件组;改变分区功能;改变分区计划 

Implement data compression.实现数据压缩。 
This objective may include but is not limited to: sparse columns; page/row这个目标可能包括但不限于：稀疏列;页/行 

Maintain 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/offline这个目标可能包括但不限于：创建空间索引;建立分区指标;群集和非群集索引; XML的指标;停用，使指标;过滤指数稀疏列;指标与包括列;重建/重组指标;在线/离线 

Manage collations.管理排序。 
This objective may include but is not limited to: column collation; database collation; instance collation这个目标可能包括但不限于：列排序;数据库核对;例如整理