GIS Geodatabase Design and Management 4 — Questions and Answers
Question 1: Which geodatabase storage format is best suited for a team of five field collectors working simultaneously without a network connection?
- Enterprise geodatabase with versioning
- Mobile geodatabase (.geodatabase)
- Personal geodatabase (.mdb)
- File geodatabase replicated to each device (Correct answer)
Correct answer: File geodatabase replicated to each device
File geodatabase replicas allow each field collector to work offline independently, then synchronize edits back to the central geodatabase when connectivity is restored.
Question 2: What is a 'mosaic dataset' in a geodatabase used for?
- Combining vector polygon layers into a single boundary
- Managing and serving large collections of raster imagery as a single virtual layer (Correct answer)
- Merging multiple feature classes by attribute
- Storing terrain models as TIN surfaces
Correct answer: Managing and serving large collections of raster imagery as a single virtual layer
A mosaic dataset is a geodatabase object that catalogs, manages, and serves collections of raster datasets as a unified, queryable raster layer.
Question 3: Which tool is used to upgrade a file geodatabase created in an older ArcGIS release to the current release schema?
- Compact Geodatabase
- Upgrade Geodatabase (Correct answer)
- Migrate Storage
- Import XML Workspace
Correct answer: Upgrade Geodatabase
The Upgrade Geodatabase tool updates the system tables and schema of a geodatabase to the current ArcGIS release version.
Question 4: In a geodatabase topology, what is a 'dirty area'?
- A feature class that has not been projected
- A spatial extent where edits have been made but topology has not yet been validated (Correct answer)
- A polygon feature with null attribute values
- A region outside the extent of the topology
Correct answer: A spatial extent where edits have been made but topology has not yet been validated
Dirty areas are regions marked by the geodatabase where features have been edited since the last topology validation, indicating those areas need to be re-evaluated for rule violations.
Question 5: What is the primary advantage of using 'attribute rules' (introduced in ArcGIS Pro) over traditional geodatabase domains?
- Attribute rules can enforce cross-field and cross-table validation using Arcade expressions (Correct answer)
- Attribute rules replace the need for spatial indexes
- Attribute rules work only in file geodatabases
- Attribute rules eliminate the need for versioning
Correct answer: Attribute rules can enforce cross-field and cross-table validation using Arcade expressions
Attribute rules use Arcade scripting to implement complex validation, calculation, and constraint logic that can reference multiple fields or related tables, far beyond the simple list/range checking of domains.
Question 6: Which approach correctly preserves M values (linear referencing measures) when loading data into a geodatabase feature class?
- Enable 'Has M' on the feature class before loading and use a tool that respects M values (Correct answer)
- M values are automatically preserved in any feature class regardless of settings
- Set the spatial reference to include a measure extent
- Convert M values to Z values before import
Correct answer: Enable 'Has M' on the feature class before loading and use a tool that respects M values
The feature class must be created with 'Has M' enabled, and loading tools must be configured to transfer M values; otherwise measures are dropped during import.
Question 7: What is the purpose of the 'ST_Geometry' storage type in an Oracle enterprise geodatabase?
- It stores geometries as binary large objects in SQL Server format
- It is Esri's native SQL spatial type enabling direct geometry storage and SQL spatial queries in Oracle (Correct answer)
- It converts Oracle geometries to WKT for cross-platform export
- It is used only for storing raster data in Oracle
Correct answer: It is Esri's native SQL spatial type enabling direct geometry storage and SQL spatial queries in Oracle
ST_Geometry is Esri's native spatial type installed into Oracle that stores feature geometries in the database and enables SQL spatial queries without requiring ArcGIS client software.
GIS Geodatabase Design and Management 4
Which geodatabase storage format is best suited for a team of five field collectors working simultaneously without a network connection?