VERIFIED SOLUTIONS MANUAL FOR Implementing a Data Warehouse with Microsoft SQL Server 2012 LATEST TEST BANK (ALL YOU NEED TO KNOW)

Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 OBJECTIVE CHAPTER LESSON 1. DESIGN AND IMPLEMENT A DATA WAREHOUSE 1.1 Design and implement dimensions. Chapter 1 Chapter 2 Lessons 1 and, 2 Lessons 1, 2, and 3 1.2 Design and implement fact tables. Chapter 1 Chapter 2 Lesson 3 Lessons 1, 2, and 3 2. EXTRACT AND TRANSFORM DATA 2.1 Defi ne connection managers. Chapter 3 Chapter 4 Chapter 9 Lessons 1 and 3 Lesson 1 Lesson 2 2.2 Design data fl ow. Chapter 3 Chapter 5 Chapter 7 Chapter 10 Chapter 13 Chapter 18 Chapter 19 Chapter 20 Lesson 1 Lessons 1, 2, and 3 Lesson 1 Lesson 2 Lesson 2 Lessons 1, 2, and 3 Lesson 2 Lesson 1 2.3 Implement data fl ow. Chapter 3 Chapter 5 Chapter 7 Chapter 13 Chapter 18 Chapter 20 Lesson 1 Lessons 1, 2, and 3 Lessons 1 and 3 Lesson 1 and 2 Lesson 1 Lessons 2 and 3 2.4 Manage SSIS package execution. Chapter 8 Chapter 12 Lessons 1 and 2 Lesson 1 2.5 Implement script tasks in SSIS. Chapter 19 Lesson 1 3. LOAD DATA 3.1 Design control fl ow. Chapter 3 Chapter 4 Chapter 6 Chapter 8 Chapter 10 Chapter 12 Chapter 19 Lessons 2 and 3 Lessons 2 and 3 Lessons 1 and 3 Lessons 1, 2, and 3 Lesson 1 Lesson 1 and 2 Lesson 1 3.2 Implement package logic by using SSIS variables and parameters. Chapter 6 Chapter 9 Lessons 1 and 2 Lessons 1 and 2 3.3 Implement control fl ow. Chapter 4 Chapter 6 Chapter 8 Chapter 10 Chapter 13 Lessons 2 and 3 Lesson 3 Lessons 1 and 2 Lesson 3 Lessons 1, 2, and 3 3.4 Implement data load options. Chapter 7 Lesson 2 3.5 Implement script components in SSIS. Chapter 19 Lesson 2 OBJECTIVE CHAPTER LESSON 4. CONFIGURE AND DEPLOY SSIS SOLUTIONS 4.1 Troubleshoot data integration issues. Chapter 10 Chapter 13 Lesson 1 Lessons 1, 2, and 3 4.2 Install and maintain SSIS components. Chapter 11 Lesson 1 4.3 Implement auditing, logging, and event handling. Chapter 8 Chapter 10 Lesson 3 Lessons 1 and 2 4.4 Deploy SSIS solutions. Chapter 11 Chapter 19 Lessons 1 and 2 Lesson 3 4.5 Confi gure SSIS security settings. Chapter 12 Lessons 1 and 2 5. BUILD DATA QUALITY SOLUTIONS 5.1 Install and maintain Data Quality Services. Chapter 14 Lessons 1, 2, and 3 5.2 Implement master data management solutions. Chapter 15 Chapter 16 Lessons 1, 2, and 3 Lessons 1, 2, and 3 5.3 Create a data quality project to clean data. Chapter 14 Chapter 17 Chapter 20 Lesson 1 Lessons 1, 2, and 3 Lessons 1 and 2 Exam Objectives The exam objectives listed here are current as of this book’s publication date. Exam objectives are subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit the Microsoft Learning website for the most current listing of exam objectives: Exam 70-463: Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Training Kit Dejan Sarka Matija Lah Grega Jerkič Copyright © 2012 by SolidQuality Europe GmbH All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. ISBN: 978-0-7356-6609-2 Fifth Printing: October 2014 Printed and bound in the United States of America. Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email Microsoft Press Book Support at . Please tell us what you think of this book at Microsoft and the trademarks listed at The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fi ctitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. Acquisitions and Developmental Editor: Russell Jones Production Editor: Holly Bauer Editorial Production: Online Training Solutions, Inc. Technical Reviewer: Miloš Radivojević Copyeditor: Kathy Krause, Online Training Solutions, Inc. Indexer: Ginny Munroe, Judith McConville Cover Design: Twist Creative • Seattle Cover Composition: Zyg Group, LLC Illustrator: Jeanne Craver, Online Training Solutions, Inc. Contents at a Glance Introduction xxvii PART I DESIGNING AND IMPLEMENTING A DATA WAREHOUSE ChaptEr 1 Data Warehouse Logical Design 3 ChaptEr 2 Implementing a Data Warehouse 41