This Training Kit is designed for information technology (IT) professionals who support
or plan to support data warehouses, extract-transform-load (ETL) processes, data quality improvements, and master data management. It is designed for IT professionals who also
plan to take the Microsoft Certified Technology Specialist (MCTS) exam 70-463. The authors
assume that you have a solid, foundation-level understanding of Microsoft SQL Server 2012
and the Transact-SQL language, and that you understand basic relational modeling concepts.
The material covered in this Training Kit and on Exam 70-463 relates to the technologies
provided by SQL Server 2012 for implementing and maintaining a data warehouse. The topics
in this Training Kit cover what you need to know for the exam as described on the Skills Measured tab for the exam, available at:
http://www.microsoft.com/learning/en/us/exam.aspx?id=70-463
By studying this Training Kit, you will see how to perform the following tasks:
■ Design an appropriate data model for a data warehouse
■ Optimize the physical design of a data warehouse
■ Extract data from different data sources, transform and cleanse the data, and load
it in your data warehouse by using SQL Server Integration Services (SSIS)
■ Use advanced SSIS components
■ Use SQL Server 2012 Master Data Services (MDS) to take control of your master data
■ Use SQL Server Data Quality Services (DQS) for data cleansing
Refer to the objective mapping page in the front of this book to see where in the book
each exam objective is covered.
