Microsoft Certified IT Professional/Exam 70-444/Designing a Database Data Management Strategy

Designing a Database Data Management Strategy  Design and manage SQL Server Integration Services (SSIS) packages.  Construct complex SSIS packages. Design security for accessing packages. Restart failed packages. Troubleshoot or debug packages. Deploy and move packages. Schedule package execution. Move packages to different servers.  Enforce data quality according to business requirements.  Establish the business requirements for quality. Create queries to inspect the data. Use checksum. <li>Clean the data. </ul> <li>Design data integrity. <ul> <li>Reconcile data conflicts. <li>Make implicit constraints explicit. <li>Assign data types to control characteristics of data stored in a column. </ul> <li>Design a strategy to manage data across linked servers. <ul> <li>Set up and manage linked servers. </ul> <li>Design a strategy to manage replication. <ul> <li>Design alerts. <li>Design a maintenance plan to monitor health, latency, and failures. <li>Verify replication. <li>Design a plan to resolve replication conflicts. <li>Design a plan to modify agent profiles. <li>Tune replication configuration. </ul> <li>Optimize a database control strategy to meet business requirements. <ul> <li>Verify that database change control procedures are being followed. <li>Identify all database objects related to a particular deployment. </ul> </ul>