Exam MB3-861:

Microsoft Dynamics GP 2010 Installation & Configuration

Published:August 12, 2010
Audience(s):IT Professionals
Technology:Microsoft Dynamics GP 2010
Type:Proctored Exam

How To Get It: Schedule your exam through the following exam provider:

Take exam

Preparing for an Exam
This certification exam measures your ability to understand and articulate how to install and configure Microsoft Dynamics GP2010 including preparing the environment, installing Microsoft Dynamics GP2010, configuring system manager components, administering Microsoft Dynamics GP after installation, optimizing performance, managing Process Server, and understanding reporting options for Microsoft Dynamics GP.
Exam Topics Covered
The following list includes the topic areas covered on this exam.
  • Preparing environment for Microsoft Dynamics GP
  • Installing Microsoft Dynamics GP
  • Installing additional Microsoft Dynamics GP workstations
  • Configuring System Manager components
  • Administering Microsoft Dynamics GP after installation
  • Optimizing Performance
  • Configuring Process Server
  • Configuring Reporting for Microsoft Dynamics GP
Audience Profile
Individuals wishing to obtain a certification on Microsoft Dynamics GP 2010 Installation & Configuration should take this exam.
Credit Toward CertificationWhen you pass Exam MB3-861: Microsoft Dynamics GP 2010 Installation & Configuration, you complete the requirements for the following certification(s):Exam MB3-861: Microsoft Dynamics GP 2010 Installation & Configuration: counts as credit toward the following certification(s):
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam.

The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.
Preparing environment for Microsoft Dynamics GP (15%)
  • System recommendations
    • May include: network settings, server configuration, Microsoft Office integration, terminal server, and virtualization options.
  • Installation and configuration of SQL Server
    • May include: SQL Server 2008, SQL Server 2008 Express, collation and authentication configuration.
Installing Microsoft Dynamics GP (16%)
  • Complete initial installation in client/server environment
    • May include: creating an ODBC connection, installing Microsoft Dynamics GP, running Microsoft Dynamics GP Utilities, data server initialization, DYNAMICS database initialization, synchronizing the account framework, system options.
  • Use Additional Tasks
    • May include: sample company initialization, creating additional companies, adding users, updating modified forms and reports.
Installing additional Microsoft Dynamics GP workstations (16%)
  • Install Microsoft Dynamics on a workstation
    • May include: client requirements and installation, adding and removing additional features and components, creating and using a client installation package, applying service packs and updates by using automatic updates.
  • Identify installation components and files
    • May include: identity columns, stored procedures, reports and forms dictionaries, Dynamics.set file, dex.ini file.
Configuring System Manager components (15%)
  • Setup security settings
    • May include: system password, security tasks, security roles, user security, classes, alternate and/or modified forms and reports.
  • Setup system and company information
    • May include: user setup, user preferences, setting up company information, registration, switching users and companies, User Activity, User Preferences.
Administering Microsoft Dynamics GP after installation (13%)
  • Configure database options in SQL Server
    • May include: recovery model, database settings.
  • Implement database maintenance procedures
    • May include: using the Microsoft SQL Database Maintenance Plan Wizard, Microsoft Dynamics GP-SQL Maintenance, SQL Database Maintenance, SQL Database Maintenance Plan Wizard, Microsoft Dynamics GP Maintenance Procedures including Check Links and Reconcile.
  • Backup Microsoft Dynamics GP databases
    • May include: database backup procedures, Microsoft Dynamics GP Recovery Procedures, backup and restore procedures in Microsoft Dynamics GP, recovering Microsoft Dynamics GP data.
Optimizing Performance (10%)
  • Optimize Windows Server and SQL Server
    • May include: performance and memory options, optimizing SQL Server.
  • Analyze performance
    • May include: using SQL Profiler and dexsql.log to troubleshoot issues, performing batch recovery, system monitor.
Configuring Process Server (5%)
  • Set up process server
    • May include: Process Server system requirements and considerations, Distributed Process Manager.
  • Monitor the process server
    • May include: using the process monitor.
Configuring Reporting for Microsoft Dynamics GP (10%)
  • Configure reporting for Report Writer
    • May include: Uses for Report Writer, printing modified reports.
  • Configure reporting for SQL Server Reporting Services
    • May include: Benefits of SQL Server Reporting Services, Security.
  • Configure reporting using Microsoft Office
    • May include: Microsoft Excel reports, Microsoft Word forms, e-mailing reports and forms.
  • Configure Report Scheduler
    • May include: setup options for Report Scheduler.
Preparation Tools and ResourcesTo help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills Measured" tab.
Learning Plans and Classroom Training
Microsoft E-Learning
  • 80226AE: Installation and Configuration in Microsoft Dynamics GP 2010 (8 Hours)
Microsoft Press Books There are no Microsoft Press books currently available.
Practice Tests There are no practice tests currently available.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site: