Enterprise Geodatabase Management Associate 10.0

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
  • Use geoprocessing tools, command line, and performance monitoring and tuning tools

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 three primary geodatabase elements
  • Identify the management tiers of the geodatabase and their purpose
  • Compare and contrast the different methods for 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
  • Explain methods to determine storage requirements and common factors that impact storage
  • 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 types of connections and characteristics of each
  • 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
  • Describe parameters that influence raster data loading
  • 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
  • Identify other data sources and their purpose
  • 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
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 they are not required. Keep in mind, completing recommended training courses does not guarantee that you will achieve the requirements for a specific Esri Technical Certification.

Show/Hide All Training
Instructor-Led

Search the ArcGIS Resource Center for additional materials.

Register for an exam

Exam price: $225 USD
Exam time limit: 2 hours
Number of questions: 95
Certification code: EGMA10
Exam type: Multiple choice, multiple select
View information about this exam for ArcGIS 10.1.

Contact Us | Privacy | Legal | Site Map