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