MCSA SQL Server Implementing a Data Warehouse Exam Objective

Module 01: Design and Implement a data warehouse

Module 02: Extract and transform data

Module 03: Load data

Module 04: Configure and deploy SSIS solutions

Module 05: Build data quality solution

Detailed Syllabus:

Module 01: Design and Implement a data warehouse

Design and implement dimensions
Design and implement fact tables

Module 02: Extract and transform data

Define connection managers
Design data flow
Implement data flow
Manage SSIS package execution
Implement script tasks in SSIS

Module 03: Load data

Design control flow
Implement package logic by using SSIS variables and parameters
Implement control flow
Implement data load options
Implement script components in SSIS

Module 04: Configure and deploy SSIS solutions

Troubleshoot data integration issues
Install and maintain SSIS components
Implement auditing, logging, and event handling
Deploy SSIS solutions
Configure SSIS security settings

Module 05: Build data quality solution

Install and maintain data quality services
Implement master data management solutions
Create a data quality project to clean data

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.