The Microsoft test 70-447 measures your ability to design the infrastructure of database servers and databases, and to optimize, manage, and administer SQL Server databases. It covers a range of database technologies. You must understand the ways of planning to install database servers and databases, and know about the cost of hardware and software resources to develop the infrastructure. You should also consider the security of the database servers and usage of 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-447 test, you should practice the following:
- Use capacity planning to plan the infrastructure.
- Know the hardware and the software resources to be used.
- Know the installation of the default and named instances.
- Analyze the security requirements on the basis of server-level, database-level, and schema-level.
- Know the procedures for creating databases and database objects.
- Know the strategy for creating high-availability for a business.
- Know replication and its types.
- Know about database mirroring.
- Know about log shipping.
- Know about the different data recovery models.
- Know about the different types of replication topologies.
- Know about the backup and restore processes.
- Know about the different modes of backing up a database.
- Understand the usage of System Monitor.
- Manage counters and performance logs.
- Understand the usage of SQL Server Profiler.
- Understand the usage of Dynamic Management Views.
- Create and maintain statistics.
- Maintain transaction logs.
- Know the usage of 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.