The MeasureUp Practice Lab for the Microsoft certification exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012 Data Warehouse concepts. By completing the lab tasks you will improve your practical skills in implementing Microsoft SQL Server data warehouse, managing connection managers, data flows, deploy SSIS solutions, control flows, data loads, data quality services, data management solutions and managing data quality.

These same tasks will help you understand the objectives and competencies required by the Microsoft 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 certification exam.

---

Learning Objectives
Learning Time: 16 hours

• Design and Implement a Data Warehouse
• Define Connection Managers
• Implementing Data Flow
• Managing SSIS Package Execution
• Implementing Script Tasks
• Implement Control Flow
• Implement Data Load Options
• Troubleshoot Data Integration Issues
• Install and Maitain SSIS Components
• Implement Auditing Logging and Event Handling
• Deploy SSIS Solutions
• Install and maintain Data Quality Services
• Implement Master Data Management Solutions
• Manage Master Data Management Solutions
• Create a Data Quality Project to Clean Data