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 questions
Answer options
A: Reconcile and post edit versions
B: Disconnect from their active session Correct answer
C: Save edits and stop editing session
Correct Answer:
B. Disconnect from their active session
Explanation

Upgrading 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.

Why Incorrect

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. ---

References

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".

Scroll to Top