uCertify.com

Design tests are always tricky and require some experience. There is not a whole lot you can do to prepare for this test other than have the experience with SQL Server 2000. So, in order to practice, you should think up an application requirement, design a database, and play with it using Enterprise Manager and Transact-SQL. And, you must not forget to check out the new features of SQL Server 2000. You can also do the following to practice the 70-229 test:

1. Install and uninstall SQL Server 2000.
2. Create a database, tables, primary keys, foreign keys, indexes, views, triggers, stored procedures, and functions.
3. Insert, update, and delete data using Transact-SQL statements

Continue reading “How to prepare for Microsoft test 70-229.”

The Microsoft exam 70-299 measures an individual’s ability to implement and administer security in a Microsoft Windows Server 2003 Network. Before taking the 70-299 exam, you should practice the following:

1. Plan security templates based on computer roles.
2. Configure registry and file system permissions, account policies, .pol files, audit policies, user rights assignment, security options, system services, restricted groups, and event logs.
3. Deploy security templates by using Active Directory-based Group Policy objects (GPOs) and by using command-line tools and scripting.
4. Troubleshoot security template problems in a mixed operating system environment.
5. Troubleshoot security policy inheritance and removal of security template settings.
6. Plan and configure security settings and software restriction policies.
7. Plan network zones for computer roles and security for infrastructure services including DHCP and DNS.

Continue reading “How to prepare for Microsoft exam 70-299”

The 70-315 test measures an individual’s ability to develop and implement Web applications using Microsoft Visual C# .NET and Microsoft Visual Studio .NET. Before taking the 70-315 test, you should practice the following:

1. Create an ASP.NET page and set control properties.
2. Create a simple Web service, set a Web reference to it in an ASP.NET application, and return a simple value.
3. Use ADO.NET objects in an ASP.NET page to retrieve data into a DataSet.
4. Retrieve data from a SQL Server database with a FOR XML statement.

Continue reading “How to prepare for 70-315.”