Boot Camp Pricing
Windows 2000 MCSE | NT 4.0 MCSE | MCSE Classes | MCSE FAQs | MCSE Exam Info

Microsoft Exam 70-155

Designing and Implementing Distributed Applications with Microsoft Visual FoxPro 6.0

Exam 70-155 has been available since February 17, 2000.

This document includes information on:

• Microsoft Certification Path
• Skills Being Measured

Microsoft Certification Path

When you pass the Designing and Implementing Distributed Applications with Microsoft Visual FoxPro 6.0 exam, you achieve Microsoft Certified Professional status. You also earn credit toward the following certifications:

• Core or elective credit toward Microsoft Certified Solution Developer certification
• Elective credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification

Skills Being Measured

This certification exam measures your ability to design and implement distributed application solutions by using Microsoft Visual FoxPro version 6.0. Before taking the exam, you should be proficient in the job skills listed below.

Developing the Conceptual and Logical Design

Given a conceptual design, apply the principles of modular design to derive the components and services of the logical design.

Developing a Logical Data Model

Group data into entities by applying normalization rules.

• Use the primary key.

Specify the relationships between entities.

Choose the foreign key that will enforce a relationship between entities and ensure referential integrity.

Identify the business rules that relate to data integrity.

Incorporate business rules and constraints into the data model.

Given a situation, decide whether denormalization is appropriate.

Deriving the Physical Design

Assess the potential impact of the logical design on performance, maintainability, extensibility, and availability. Considerations include COM, DCOM, and middle tier.

Design Visual FoxPro components to access data from a database.

Design the properties and methods of components.

Design class libraries. Considerations include inheritance, encapsulation, containership, delegation, and polymorphism.

Establishing the Development Environment

Establish the environment for source-code version control.

Install and configure Visual FoxPro for developing distributed applications.

Establish the development environment to run Microsoft Transaction Server (MTS), Microsoft Internet Information Server (IIS), and Microsoft Message Queue Server (MSMQ).

Creating User Services

Implement navigational design.

• Create a menu.
• Add a shortcut menu to an application.
• Add controls to forms.
• Set properties for controls.
• Assign code to a control to respond to an event.
• Create a toolbar.

Create and manage data input forms and dialog boxes.

• Display, manipulate, and bind data by using controls.
• Add, delete, and manipulate controls at run time.
• Use the Forms collection to manipulate forms at run time.
• Given a scenario, add code to the appropriate form event. Events include the Init, Destroy, Load, Unload, QueryUnload, Activate, and Deactivate events.

Validate user input. Considerations include single-tier, two-tier, and n-tier applications.

Write code that processes data entered on a form.

Add a Microsoft ActiveX control to a form or other container to manipulate data. Controls include the TreeView, ListView, ImageList, and Web Browser controls.

Interact with Visual FoxPro from a Web page. Considerations include FoxISAPI, dynamic HTML, ASP, and XML.

Instantiate, invoke, and manipulate a COM component.

Implement online user assistance in a distributed application.

• Set appropriate properties to enable user assistance. Help contents include HelpFile, HelpContextID, and WhatsThisHelp.
• Create HTML Help for an application.

Implement error handling for the user interface in distributed applications.

• Identify and trap run-time errors.
• Handle inline errors.
• Notify users of errors.

Extend functionality through the Microsoft Windows API.

Creating and Managing COM Components

Create a COM component that implements business rules or logic.

Create a COM component that interacts with other COM components.

Add error handling to a COM component.

Log errors into an error log for error handling and debugging.

Design and create a component that will be used with MTS.

• Implement transaction support for a COM component.

Create the appropriate server type for a COM component. Considerations include in-process, out-of-process, and multithreaded.

Create and manage packages by using the MTS Explorer.

• Add components to an MTS package.

Use role-based security to limit use of an MTS package to specific users.

Use the Component Gallery to manage components.

Register and unregister a COM component.

Creating Data Services

Access and manipulate data by using ADO and Remote Data Service (RDS).

Access and manipulate data by using Visual FoxPro data, including local views.

Access and manipulate data by using SQL pass-through (SPT).

Access and manipulate data by using remote views and local views.

Manage database transactions to ensure data consistency and recoverability.

Write SQL statements that retrieve and modify data.

Write SQL statements that use joins to combine data from multiple tables.

Write SQL statements that create views.

Use appropriate locking and buffering strategies. Strategies include pessimistic, optimistic, row, and table.

Create and manipulate Visual FoxPro stored procedures.

Create and implement Visual FoxPro triggers.

Import data from an external data source.

Write SQL statements that update and modify data.

Creating a Physical Database

Programmatically create and maintain Visual FoxPro databases.

Design, create, and implement databases and database tables. Considerations include data integrity, referential integrity, and normalization.

Choose and design an indexing strategy. Considerations include index maintenance and optimization by means of Rushmore.

Create and maintain indexes. Considerations include programmatic, visual, and index maintenance and optimization by means of Rushmore.

Testing and Debugging the Solution

Ascertain appropriate debugging techniques.

Identify and describe the elements of a test plan. Elements include beta testing, regression testing, unit testing, integration testing, and stress testing.

Given a scenario, select the appropriate build options.

Use conditional compilation in an application.

Monitor the values of expressions and variables by using the Debug window.

• Use the Immediate window to check or change values.
• Use the Watch window to check or change values.
• Use the Call Stack window to find bugs in an application.

Use asserts in an application.

Use the Coverage Profiler to identify performance bottlenecks and code coverage.

Use event tracking to find out the order of events.

Set a breakpoint to debug an application.

Deploying an Application

Use the Setup Wizard to create a setup program that installs a distributed application, registers the COM components, and allows for the application to be uninstalled.

Register a component that implements DCOM.

Configure DCOM on a client computer and on a server computer.

Configure a client computer to use an MTS component, and configure remote automation on a client computer and on a server computer.

Plan and implement floppy disk-based deployment or compact disc-based deployment for a distributed application.

Plan and implement Web-based deployment for a distributed application.

Plan and implement network-based deployment for a distributed application.

Maintaining and Supporting an Application

Plan for and implement disaster recovery procedures.

Fix errors, and take measures to prevent future errors.

Maintain anomaly logs.

Deploy application updates for distributed applications.

Boot Camp Pricing
Windows 2000 MCSE | NT 4.0 MCSE | MCSE Classes | MCSE FAQs | MCSE Exam Info