Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Learning plans and classroom training

Social Resources

Microsoft Press books

 

Training Kit 70-463: Implementing a Data Warehouse with Microsoft SQL
By: Dejan Sarka, Matija Lah, Grega Jerkic
Order this book from   (Official distributor of Microsoft Press)

Prep resources by objective

Show all

1  Design and Implement a Data Warehouse

1.1  Design and implement dimensions

  • <<Add your resources here>>
  • <<Add your resources here>>

1.2  Design and implement fact tables

  • <<Add your resources here>>
  • <<Add your resources here>>

2  Extract and Transform Data

2.1  Define connection managers

  • <<Add your resources here>>
  • <<Add your resources here>>

2.2  Design data flow

  • <<Add your resources here>>
  • <<Add your resources here>>

2.3  Implement data flow

  • <<Add your resources here>>
  • <<Add your resources here>>

2.4  Manage SSIS package execution

  • <<Add your resources here>>
  • <<Add your resources here>>

2.5  Implement script tasks in SSIS

  • <<Add your resources here>>
  • <<Add your resources here>>

3  Load Data

3.1  Design control flow

  • <<Add your resources here>>
  • <<Add your resources here>>

3.2  Implement package logic by using SSIS variables and parameters

  • <<Add your resources here>>
  • <<Add your resources here>>

3.3  Implement control flow

  • <<Add your resources here>>
  • <<Add your resources here>>

3.4  Implement data load options

  • <<Add your resources here>>
  • <<Add your resources here>>

3.5  Implement script components in SSIS

  • <<Add your resources here>>
  • <<Add your resources here>>

4  Configure and Deploy SSIS Solutions

4.1  Troubleshoot data integration issues

  • <<Add your resources here>>
  • <<Add your resources here>>

4.2  Install and maintain SSIS components

  • <<Add your resources here>>
  • <<Add your resources here>>

4.3  Implement auditing, logging, and event handling

  • <<Add your resources here>>
  • <<Add your resources here>>

4.4  Deploy SSIS solutions

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.5  Configure SSIS security settings

  • <<Add your resources here>>
  • <<Add your resources here>> 

5  Build Data Quality Solutions

5.1  Install and maintain Data Quality Services

  • <<Add your resources here>>
  • <<Add your resources here>>

5.2  Implement master data management solutions

  • <<Add your resources here>>
  • <<Add your resources here>>

5.3  Create a data quality project to clean data

  • <<Add your resources here>>
  • <<Add your resources here>>