35 ordinary questions and 12 simulations.
My study technique this time worked really well. Each number below stands for the date in February:
- Picked up the self-paced study kit on February 1st. Completed Chapter 1: Installing SQL Server 2005
- Chapter 2: Configuring SQL Server 2005
- Chapter 3: Creating Tables, Constraints, and User-Defined Types
- Chapter 4: Creating Indexes
- Chapter 5: Working with Transact-SQL (very light)
- Chapter 6: Creating Partitions
- Chapter 7: Implementing Views
- Chapter 8: Managing XML Data (very important)
- Chapter 9: Creating Functions, Stored Procedures and Triggers
- Chapter 10: Working with Flat Files
- Chapter 11: Backing Up, Restoring and Moving a Database
- Chapter 12: Using Transact-SQL to Manage Databases
- Chapter 13: Working with HTTP Endpoints
- Chapter 14: Working with SQL Server Agent Jobs
- Chapter 15: Monitoring and Troubleshooting SQL Server Performance
- Chapter 16: Managing Database Snapshots
- Chapter 17: Implementing Database Mirroring
- Chapter 18: Implementing Log Shipping
- Chapter 19: Managing Replication
- Chapter 20: Working with Service Broker
- Chapter 21: Creating Full-Text Catalogs
- Concentrated (using practice exam questions) on Exam Objective 1: Installing and Configuring SQL Server 2005
- Objective 2: Implementing High Availability and Disaster Recovery
- Objective 3: Supporting Data Consumers
- Objective 4: Maintaining Databases
- Objective 5: Monitoring and Troubleshooting SQL Server Performance
- Objective 6: Creating and Implementing Database Objects
- On February 28th sat the exam
Comment by uma, on 6-Mar-2008 10:16
can you pls tell me, which service pack you used to prepare for this exam.
Comment by bhl, on 1-Jul-2008 02:42
How much time is allowed for the 35 ordinary questions and how much time is allowed for the 12 simulations? Or is the time shared?
When you study for the test, did you work on the practice exams came with the book? What was the correct percertage you got before you went to the actual test?
Comment by virantha, on 18-May-2009 11:02
Kia ora James,
Where did you order the 70-431 Microsoft learning resource book from? Was it done online? How long does it take once ordered?
Comment by adapterlist, on 25-Dec-2009 22:50
http://www.adapterlist.com is a wholesaler who sells replacement laptop batteries and laptop ac adapter. We also do business in laptop battery distribution with customers all around the world. As the biggest retailer of digital laptop batteries and battery charger in the world,
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.