New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

Exam 70-442 Objective 1

By James Hippolite, in , posted: 23-Feb-2009 12:54

Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 1 (Designing Efficient Access to a SQL Server Service) and received only 46.8%.  I've got a bit of study to do, specifically:
  1. Design appropriate data access technologies
    ServerConnection Class
    Special Considerations When Using Query Notifications
    Query Notifications in ADO.NET 2.0
    Database Administrator's Guide to SQL Server Database Engine .NET CLR Environment
    Connecting to an Instance of SQL Server
    ADO.NET Architecture
  2. Design an appropriate data access object model
    Updating an Application to SQL Server Native Client from MDAC
    Using ADO with SQL Server Native Client
    Using Row Versioning-based Isolation Levels
    Understanding Row Versioning-Based Isolation Levels
    Row Versioning Resource Usage
  3. Design a cursor strategy for a data access component
  4. Design caching strategies
    ASP.NET Caching Overview
  5. Design client libraries to write applications that administer a SQL Server service
    Configuring SQL Server in SMO
    A Technical Comparision of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
    How to: Implement a Business Logic Handler for a Merge Article (Replication Programming)
    How to: Programmatically Monitor Replication (RMO Programming)
    Microsoft.SqlServer.Replication Namespace
    Replication Management Objects Concepts
  6. Design queries that use multiple active results sets (MARS)
    Multiple Active Result Sets (MARS) in SQL Server 2005

MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits)

Other related posts:
Teach Yourself Azure in 4 hours
Geek Post Monthly Newsletter Volume 2 Issue 10

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.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".