Special Offers | My Account | Log In
  0 items in your cart


Search: Boson Sites | Products
Microsoft > MCSA | MCSE > Practice Lab for Microsoft 70-463

Practice Lab for Microsoft 70-463

About This Online Practice Lab:

Exam Numbers: 70-463
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012
Certifications: MCSA, MCSE
Author: Boson

70-463 Practice Lab

Practice Lab for Microsoft 70-463

See the Lab Videos to learn more.

The Practice Lab for Microsoft 70-463 provides access* to real computer equipment that is networked together and conveniently accessible over the internet. Practice Labs include multiple pieces of equipment that you can configure. This lab includes instructions that will guide you as you learn the concepts and technologies covered on the Microsoft 70-463 certification exam.

The 70-463 Practice-Lab 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 Implementing a Data Warehouse with Microsoft SQL Server 2012 certification exam.

*A Practice Lab purchase includes access for one (1) year from activation.

Benefits of Online Practice Labs

  • Provide dedicated live equipment without the risk or expense
  • Help improve practical IT skills
  • Can help you learn the knowledge needed to pass the certification exam
  • Allow you to share labs – great for instructors or students
  • Are accessible through the internet anytime, from anywhere

Microsoft 70-463 Exam Info

The 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 exam counts as credit toward the MCSA: SQL Server, Database Development and MCSE: Data Platform certifications.

70-463 Practice Lab Course Modules

Design and Implement a Data Warehouse

  • Introduction
  • Working with Dimensions
  • Working with Fact Tables
  • Summary

Define Connection Managers

  • Introduction
  • Configuring Flat File Connection Manager
  • Configuring OLE DB Connection Manager
  • Creating ADO.NET Connection Manager
  • Summary

Implementing Data Flow

  • Introduction
  • Data Flow Task with Transformations
  • Adding and Configuring a Lookup Transformation
  • Using Fuzzy Lookup Transformation
  • Adding and Configuring Data Correction Transformation
  • Optimizing Integration Services Packages
  • Summary

Managing SSIS Package Execution

  • Introduction
  • Executing SSIS Packages using SQL Server Agent
  • Executing SSIS Packages using SQL Server Management Studio and PowerShell Script
  • Executing SSIS Packages using SSIS Utilities
  • Validating SSIS Projects and Packages using SQL Server Management Studio
  • Summary

Implementing Script Tasks

  • Introduction
  • Configuring and Adding a Script Task to Control Flow
  • Summary

Implement Control Flow

  • Introduction
  • Working with Checkpoints
  • Using Data Profiling Tasks
  • ConfigurinUsing SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpointsg Database Mail
  • Working with Loop Containers
  • Working with Sequence Containers by Implementing Package Transactions
  • Creating SSIS Package Template
  • Summary

Implement Data Load Options

  • Introduction
  • Performing Data Loads
  • Incremental Data Load
  • Performing Incremental Data Load with Change Data Capture
  • Summary

Troubleshoot Data Integration Issues

  • Introduction
  • Implementing Data Viewer
  • Troubleshooting Data Quality
  • Summary

Install and Maitain SSIS Components

  • Introduction
  • Install SQL Server 2012 Integration Services and Set up Service Accounts
  • Configure Integration Services
  • Summary

Implement Auditing Logging and Event Handling

  • Introduction
  • Implement Row Level Auditing in an SSIS Package
  • Configuring SSIS Container for Event Logging
  • Create Custom Logging to Track Errors using Event Handlers
  • Implement Alerts and Notification Mechanism
  • Summary

Deploy SSIS Solutions

  • Introduction
  • Deploy SSIS Package using the Deployment Wizard
  • Create and Configure SSISDB Catalog and Inspect SSIS Package Metadata
  • Use DTUTIL and Deploy Packages on Multiple Servers
  • Summary

Install and maintain Data Quality Services

  • Introduction
  • Install Data Quality Services and Assign DQS Roles
  • Enable Data Quality Services Feature
  • Summary

Implement Master Data Management Solutions

  • Introduction
  • Install and Configure Master Data Services
  • Enable Master Data Services Feature
  • Using MDS Configuration Manager
  • Create MDS Model and Basic Objects
  • Populate Entities in an MDS Model and Deploy the Model
  • Summary

Manage Master Data Management Solutions

  • Introduction
  • Create MDS Model and its Objects
  • Import Data using Staging Process
  • Export MDS Data by Creating Subscription Views
  • Summary

Create a Data Quality Project to Clean Data

  • Introduction
  • Working with Data Quality Services to Clean Data
  • Using DQS Cleansing Transformation
  • Performing Data Match using Data Quality Services
  • Summary

Manage Data Quality Project to Clean Data

  • Introduction
  • Install MDS Add-in for Excel
  • View Master Data in Excel
  • Use Data Quality Services to Match MDS Data in Excel
  • Summary

See all Microsoft | MCSA | MCSE | Practice Labs | Practice Labs FAQ


Related Products

ExSim-Max for Microsoft 70-463
MCSA: SQL Server 2012 Training
MCSA: SQL 2014 with MCSE: Data Platform Training

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.


MIC-PL-70463-01