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
• 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
• 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

• Install Data Quality Services
• Install Master Data Services
• Master Data Services features and tasks