Preparation Guide for Exam 70-447

Analyze storage requirements.

Analyze network requirements.

Analyze CPU requirements.

Analyze the current configuration.

Analyze memory requirements.

Forecast and incorporate anticipated growth requirements into the capacity requirements.

Design transaction log storage.

Design backup file storage.

Decide where to install the operating system.

Decide where to place SQL Server service executables.

Specify the number and placement of files to create for each database.

Gather information to analyze the dispersed environment.

Identify potential consolidation problems.

Create a specification to consolidate SQL Server databases.

Design a database migration plan for the consolidated environment.

Test existing applications against the consolidated environment.

Gather business and regulatory requirements.

Decide how requirements will impact choices at various security levels.

Evaluate costs and benefits of security choices.

Decide on appropriate security recommendations.

Inform business decision-makers about security recommendations and their impact.

Incorporate feedback from business decision-makers into a design.

Develop a password policy.

Develop an encryption policy.

Specify server accounts and server account rights.

Specify the interaction of the database server with antivirus software.

Specify the set of running services, and disable unused services.

Specify the interaction of the database server with server-level firewalls.

Specify a physically secure environment for the database server.

Specify database users.

Design schema containers for database objects.

Specify database roles.

Define encryption policies.

Design DDL triggers.

Ensure that a database is normalized.

Allow selected denormalization for performance purposes.

Ensure that the database is documented and diagrammed.

Design file groups for performance.

Design file groups for recoverability.

Design file groups for partitioning.

Establish where to store database source code.

Isolate development and test environments from the production environment.

Define procedures for moving from development to test.

Define procedures for promoting from test to production.

Define procedures for rolling back a deployment.

Document the database change control procedures.

Analyze availability requirements.

Analyze potential availability barriers.

Analyze environmental issues.

Analyze potential problems related to processes and staff.

Identify potential single points of failure.

Decide how quickly the database solution must fail over.

Choose automatic or manual failback.

Analyze costs versus benefits of various solutions.

Combine high-availability technologies to improve availability.

Design the RAID solutions for your environment.

Design a SAN solution.

Design server roles for database mirroring.

Design the initialization of database mirroring.

Design a test strategy for planned and unplanned role changes.

Specify the primary server and secondary server.

Switch server roles.

Design an application failover strategy.

Design a strategy to reconnect client applications.

Analyze how much data the organization can afford to lose.

Analyze alternative techniques to save redundant copies of critical business data.

Analyze how long the database system or database can be unavailable.

Document the sequence of possible events.

Create a disaster decision tree that includes restore strategies.

Establish recovery success criteria.

Validate restore strategies.

Gather requirements that affect archiving.

Ascertain data-movement requirements for archiving.

Specify the destination for archival data.

Specify the frequency of archiving.

Decide if replication is appropriate.

Establish how to access archived data.

Establish the thresholds for performance.

Establish the baselines for performance.

Define which types of information to monitor on the physical server.

Define traces.

Set alerts.

Set notifications.

Create a job dependency diagram.

Manage the maintenance of database servers.

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.

Reconcile data conflicts.

Make implicit constraints explicit.

Assign data types to control characteristics of data stored in a column.

Design alerts.

Design a maintenance plan to monitor health, latency, and failures.

Verify replication.

Design a plan to resolve replication conflicts.

Design a plan to modify agent profiles.

Tune replication configuration.

Analyze the physical server security.

Compare the existing security infrastructure to business and regulatory requirements.

Identify variations from the security design.

Verify the existence and enforcement of account policies.

Verify SQL Server login authentication.

Verify permissions on SQL Server roles and accounts.