Enterprise Geodatabase Management Associate 10.1

Esri Certified Enterprise Geodatabase Management Associates understand the components and architecture of the geodatabase and are skilled in supporting ArcGIS in a multi-user enterprise.

This certification is for individuals with 3-5 years experience as database or GIS administrators and with at least 18-24 months working with Esri's ArcGIS technology.


A qualified candidate for the Enterprise Geodatabase Management Associate Certification will understand how the ArcGIS users work within a multi-user enterprise GIS environment and can assist users in connecting to the Geodatabase and performing data management.

A qualified candidate should be able to:

  • Understand basic ArcGIS concepts
  • Understand the system requirements for Relational Database Management System (RDBMS)
  • Design, install, and configure a geodatabase at a general level
  • Understand GIS workflows and their impact on the geodatabase
  • Manage data within the geodatabase at a general level
  • Perform geodatabase maintenance and troubleshooting

The following list of skills measured is provided to familiarize candidates with topics covered on the exam and to help guide exam preparation. We recommend candidates review this list and assess their knowledge of each skill. Specific preparation resources are available to assist with refreshing in areas where any knowledge gaps are found.

Show/Hide All Skills
ArcGIS Product Knowledge
  • Define a geodatabase and the geodatabase elements
  • Identify the management tiers of the geodatabase and their purpose
  • Explain the benefits of registering with the geodatabase
Understand System Requirements for Relational Database Management System (RDBMS)
  • Identify key system requirements that support a geodatabase and where to find them
  • Identify the factors that determine database load
  • Explain storage implications of different data types
  • Explain pros and cons of compression
  • Identify the key parameters for configuring RDBMS
  • Discuss the importance of roles
Install and Configure a Geodatabase
  • Describe required and optional steps to install ArcSDE and a geodatabase
  • Identify steps to upgrade a geodatabase to the current version
  • Describe the differences between connecting to a database versus a geodatabase
  • Identify methods of determining geodatabase configuration information in DBtune and server_config tables as well as the information stored in each
Design the Geodatabase
  • Describe simple and complex geodatabase elements and their purposes
  • Describe the purpose and use of feature datasets
  • Describe the purpose and use of a data model
  • Describe raster elements and their purposes
  • Describe geoprocessing elements and their purposes
  • Compare and contrast binary and spatial types
  • Explain the design considerations for choosing a spatial reference
  • Compare and contrast various ways for storing and serving imagery
  • Explain the difference between domains and subtypes including usage
  • Select the appropriate coordinate system
  • Describe the purpose of a query layers and connection types used
Data Management
  • Identify options for loading data and the benefits of using each
  • When loading data using ArcSDE command line or SQL, explain the post data load tasks required to leverage the data within the geodatabase
  • Determine which parameters/options need to be modified when a large amount of data is being loaded
  • Explain the role of DBtune in the data loading process
  • Explain which data transfer interchange methods best preserve geodatabase behaviors
  • Determine the appropriate data transfer method
  • Identify various methods for transferring data and when to use each
  • Identify the purpose of various user types and their associated permissions
  • Describe the advantages of using roles
  • Explain the implications of using OS authentication vs. database authentication
  • Explain the pros and cons of various ways to grant user privileges Explain when it is appropriate to use file geodatabases
  • Describe restrictions for using a file geodatabase
  • Describe the limitations of legacy formats
Geodatabase Maintenance
  • Identify maintenance tasks for a geodatabase
  • Explain the backup and recovery process for a geodatabase and identify components that need to be backed up
  • Describe the compress task and the compress options
  • Describe methods for automating maintenance
  • Identify the various methods, when it's appropriate, and which statistics to update
  • Identify the various methods, when it's appropriate, and which indexes to rebuild
  • Explain the various methods of rebuilding spatial indexes and when spatial indexes should be rebuilt
  • Determine which fields to index
  • Describe the proper use of a single field index
  • Describe methods for creating indexes and the advantages and/or disadvantages of each
  • Describe how to conduct scheduled version maintenance
Workflow Management
  • Identify workflows that significantly impact the geodatabase and explain how
  • Recognize the different editing options and appropriate usage
  • Define states and versions and their purpose
  • Define reconcile and post and their purpose
  • Compare and contrast geodatabase replication types including their appropriate usage
  • Explain the differences between geodatabase and database replication
  • Determine which conflict detection options may reduce or prevent conflicts
  • Explain the importance of saving edits prior to performing a reconcile
  • Explain the types and purpose of views
  • Identify different version permissions and their purpose
  • Explain the pros and cons of all editors editing the same version
  • Describe where and when to register as versioned
  • Explain what can and cannot be done after registering complex data as versioned
  • Describe where and how to create multiple versions and the properties that can be set
  • Explain how to enable non-versioned editing and its impact
Troubleshooting
  • Identify the different IT tiers and how they apply to troubleshooting (e.g., OS/RDBMS, ArcSDE, Client)
  • Describe common connection issues
  • Explain common locking issues
  • Describe common permissions issues
  • Describe common server performance issues
  • Describe common application issues that impact geodatabase performance
  • Select appropriate diagnostic log files to analyze
  • Explain how to identify connected users
  • Explain why troubleshooting solutions only at the geodatabase level may not be effective
Geodatabase Performance Management
  • Describe some of the performance monitoring tools and their purpose
  • Explain the impact of users and application on performance

The following resources are available to help you prepare for your exam, but are not required. Please utilize this list of preparation resources with the list of skills measured topics to identify appropriate training options for possible knowledge gaps found.

Please note that completing the recommended training courses does not guarantee you will achieve the requirements for a specific Certification exam.

Preparation resources

You may also search the ArcGIS Resource Center for additional materials.

Register for an exam

Exam price: $225 USD
Exam time limit: 2 hours and 25 minutes
Number of questions: 95
Certification code: EGMA101
Exam type: Multiple choice, multiple select
Published: March 2013
Level of change from previous version: Moderate
View information about this exam for ArcGIS 10.0.

Contact Us | Privacy | Legal | Site Map