- Exam 70-458 – Objective 1 – Manage Data
- Exam 70-458 – Objective 2 – Implement Security
- Exam 70-458 – Objective 3 – Implement high availability
- Exam 70-458 – Objective 4 – Design and implement a data warehouse
- Exam 70-458 – Objective 5 – Extract and transform data
- Exam 70-458 – Objective 6 – Load data
- Exam 70-458 – Objective 7 – Configure and deploy SSIS solutions
- Exam 70-458 – Objective 8 – Build Data Quality solutions
Install and maintain Data Quality Services
- Installation prerequisites (http://msdn.microsoft.com/en-us/library/gg492277.aspx#PreInstallationTasks)
- Server – Min 2 GB, Rec 4 GB+ RAM, SQL Server 2012 Database Engine
- Client – .NET Framework 4, IE 6.0 SP1+
- Use Data Quality Server Installer
- Install Data Quality Services
- Run DQSInstaller.exe
- Add users to the DQ roles (http://msdn.microsoft.com/en-us/library/hh213045.aspx)
- IN DQS_MAIN database add to roles
- Identity analysis, including data governance
Implement master data management solutions
- Install Master Data Services (MDS) (http://msdn.microsoft.com/en-us/library/gg492277.aspx)
- Implement MDS
- Create models, entities, hierarchies, collections, and attributes
- Model (http://msdn.microsoft.com/en-us/library/ff486956.aspx)
- Entities (http://msdn.microsoft.com/en-us/library/ee633723.aspx)
- Entities are like tables
- Members are rows
- Attributes are columns
- Hierarchies and collections (http://technet.microsoft.com/en-us/sqlserver/hh780975.aspx)
- Attributes (http://msdn.microsoft.com/en-us/library/ee633745.aspx)
- Domian-Based Attributes (http://msdn.microsoft.com/en-us/library/ff487058.aspx)
- Sort of like a foreign key
- Domian-Based Attributes (http://msdn.microsoft.com/en-us/library/ff487058.aspx)
- Define security roles (http://msdn.microsoft.com/en-us/library/hh231026.aspx)
- Import/export
- Import (http://msdn.microsoft.com/en-us/library/ee633726.aspx)
- Staging tables – stg.name_Leaf, stg.name_Consolidated, stg.Name_Relationship
- Import (http://msdn.microsoft.com/en-us/library/ee633726.aspx)
- Subscriptions
Create a data quality project to clean data
- Profile Online Transaction Processing (OLTP) and other source systems (http://msdn.microsoft.com/en-us/library/hh213055.aspx)
- The Discover and Manage domain values steps of the Knowledge discovery activity
- The Cleanse and Manage and view results steps of the Cleansing activity
- The Matching policy and Matching results steps of the Matching policy activity
- The Matching and Export steps of the Matching activity
- Data quality knowledge base management (http://msdn.microsoft.com/en-us/library/gg524799.aspx)
- Create a data quality project (http://msdn.microsoft.com/en-us/library/hh510393.aspx)
- Use Data Quality Client (http://msdn.microsoft.com/en-us/library/gg524796.aspx)
- Improve data quality
- Identity mapping and deduplicating
- Handle history and data quality
- Manage data quality/cleansing (http://msdn.microsoft.com/en-us/library/gg524800.aspx)
Preparation resources