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:
- Install and uninstall SQL Server 2000.
- Create a database, tables, primary keys, foreign keys, indexes, views, triggers, stored procedures, and functions.
- Insert, update, and delete data using Transact-SQL statements
- Create a DTS package and transfer data through it.
- Create a link server and run ad hoc queries using the OPENQUERY function.
- Setup and configure a replication server.
- Create email notifications.
- Create query plans.
- Use profiler and capture, analyze, replay, and study traces.
- Define object level security including database, table, and column level permissions.