The Microsoft test 70-444 measures your ability to optimize, manage, and administer SQL Server databases. The test is designed to check your ability to use the SQL Server services and objects. It requires you to have a good knowledge of the SQL Server objects and troubleshooting issues related to SQL Server. Before taking the 70-444 test, you should practice the following:
- Use System Monitor.
- Manage counters and performance logs.
- Use SQL Server Profiler.
- Use Dynamic Management Views.
- Create and maintain statistics.
- Maintain transaction logs.
- Use Query Editor.
- Analyze queries using Graphical Execution Plan.
- Create and manage a trace.
- Trigger events and notification processes.
- Use different tools and services of SQL Server to diagnose database problems.
- Understand Failover Clustering.
- Understand Database Mirroring.
- Restore system databases.
- Understand snapshots.
- Use reporting services.
- Understand linked servers.
- Configure a linked server.
- Use SQL Server integration services.
- Secure databases.
- Understand Denial of Service attacks.
- Resolve Denial of Service attacks.