Sunday, February 22, 2009

Exam 70-442 Objective 1

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
    DECLARE CURSOR (Transact-SQL)
  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)

No comments:

Post a Comment