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 |
| Single-User License |
|
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 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
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