EGMP2201 practice question 3 of 15
A GIS data administrator is unable to upgrade the geodatabase while editors have active sessions and are working on editing workflows. What should the editors do?
Full set: 65 questionsUpgrading an enterprise geodatabase is an administrative task that requires an exclusive schema lock on the database. This type of lock cannot be obtained while any users have active connections. Even if an editor saves their edits and stops the editing session, their client application (e.g., ArcGIS Pro) maintains a connection to the geodatabase, which places a shared lock. To allow the upgrade to proceed, all users must completely terminate their sessions by disconnecting from the geodatabase, thereby releasing all locks.
A. Reconcile and post edit versions: This is a data management step within an active session. It does not terminate the user's connection to the geodatabase, which is what blocks the upgrade.
C. Save edits and stop editing session: This action ends the editing operation but does not close the user's connection to the geodatabase. The persistent connection prevents the administrator from gaining an exclusive lock. ---
1. Esri ArcGIS Pro Documentation, "Upgrade an enterprise geodatabase in SQL Server": In the "Prerequisites" section, the documentation explicitly states: "You must be the geodatabase administrator to upgrade. You must have DBA privileges for the database. Disconnect all users from the geodatabase." This requirement is consistent across all supported database management systems.
Source: Esri ArcGIS Pro 3.2 Documentation, "Upgrade an enterprise geodatabase in SQL Server", Prerequisites section.
2. Esri ArcGIS Pro Documentation, "Geodatabase locks": This document explains that administrative tasks like upgrading a geodatabase require exclusive locks on system tables. "Exclusive locks are used when making changes to a table's schema... An exclusive lock cannot be placed if any other type of lock is present." An active user connection maintains a shared lock, which prevents an exclusive lock from being established.
Source: Esri ArcGIS Pro 3.2 Documentation, "Geodatabase locks", Types of locks section.
3. Esri ArcGIS Pro Documentation, "Manage enterprise geodatabase connections": This page details how administrators can view and manage connections. It notes that for maintenance, "you may need to prevent users from connecting to the geodatabase or disconnect users who are connected." This underscores that the connection itself, not just the editing state, is the critical factor.
Source: Esri ArcGIS Pro 3.2 Documentation, "Manage enterprise geodatabase connections in SQL Server".
Keep practicing
Take the free EGMP2201 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other EGMP2201 practice questions
- Question 1A GIS data administrator needs to restrict access to some fields in a feature class from …
- Question 2A GIS data manager needs to allow editors to see changes made to the default version in t…
- Question 4A GIS database administrator needs to identify any performance issues with a nightly load…
- Question 5A GIS analyst needs to visualize a centralized folder of imagery with multiple images in …
- Question 6An editor connects to an enterprise geodatabase to edit a feature class that uses traditi…
- Question 7All editors reconcile and post their versions daily. Other users create read-only version…
