EGMP2201 practice question 11 of 15
A GIS analyst creates a database view. When the database view is loaded into the map, performance is suboptimal. Which workflow should the analyst use?
Full set: 65 questionsRegistering a database view with an enterprise geodatabase is the correct workflow to improve performance. This process adds the view to the geodatabase's system tables and, most importantly, defines a unique identifier (ObjectID) field. ArcGIS clients rely on a unique ObjectID for fast feature retrieval, selection, and rendering. Without a registered ObjectID, ArcGIS must scan the view on the fly to identify rows, leading to the suboptimal performance described. Registration allows ArcGIS to leverage database indexes and perform optimized spatial and attribute queries, directly addressing the performance bottleneck.
A. Export to shapefile: This creates a static, disconnected copy of the data. It does not improve the performance of the live database view and severs the dynamic link to the source database.
B. Join to another feature class: This is a data analysis operation. Joining the view to another dataset would add computational overhead and likely decrease, rather than improve, performance.
1. Esri ArcGIS Pro Documentation, "Register a table or view with the geodatabase": "When you work with a spatial table in the database that was not created with ArcGIS, you must register it with the geodatabase to take advantage of geodatabase functionality... When you register a table, an ObjectID field is added to the table if one does not exist... The ObjectID is used by ArcGIS to uniquely identify rows in the table." This unique identification is fundamental for performance.
Source: Esri ArcGIS Pro Documentation, "Data management" section.
2. Esri ArcGIS Pro Documentation, "Query layers": "For a query layer to perform well, the query that defines it should be optimized for the database... You must define a query that has a field or fields that have unique values... ArcGIS Pro uses these unique-valued fields to perform operations that depend on specific rows in the dataset." This highlights the critical role of a unique identifier for performance, which the registration process formally establishes for a view.
Source: Esri ArcGIS Pro Documentation, "Mapping and visualization" section.
3. Penn State University, GEOG 485: GIS Database Development and Administration, Lesson 7: Loading and Registering Data: "When you have spatial data in a DBMS that was not created through ArcGIS, you can register it with ArcSDE. Registering the data makes it possible to view, query, and edit the data in ArcGIS... The main benefit of registering data is that it enables you to define how certain properties of the table should be treated by ArcGIS. For example, you can specify which column should serve as the unique ID field (ObjectID)."
Source: Penn State University Open Educational Resources, John A. Dutton e-Education Institute.
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 3A GIS data administrator is unable to upgrade the geodatabase while editors have active s…
- 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…
