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.