Microsoft > MCSA | MCSE > Practice Lab for Microsoft 70-463

Practice Lab for Microsoft 70-463

$99 $49
Exam Numbers
Exam Name
Implementing a Data Warehouse with Microsoft SQL Server 2012

70-463 Practice Lab

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 Microsoft 70-463 certification exam will retire on January 31, 2021.
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.
See our Practice Labs Youtube Playlist to learn how to purchase, activate and access Boson Practice Labs.
*A Practice Lab purchase includes access for one (1) year from activation.
Practice Lab for Microsoft 70-463
See the Lab Videos to learn more.

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.

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
  • Are accessible through the internet anytime, from anywhere

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

Practice Lab for Microsoft 70-463

$99 $49

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.