Free Enterprise Geodata Management Professional 2201 Exam EGMP2201 Exam Practice Test

ArcGIS Pro users must be able to use the Undo and Redo buttons while editing a dataset. At the same time, SQL users must be able to edit this dataset.How should the ArcGIS data administrator configure this dataset?

• Nonversioned editing
• Traditional versioning
• Branch versioning

AGIS data administrator is creating new feature classes within an enterprise geodatabase using the following workflow:Five feature classes are added to a feature datasetThe feature dataset is registered as versioned without the move-edits-to-base optionThen another feature class is added to the same feature datasetUsers receive error messages when trying to edit any of the feature classes within the feature dataset.What should the administrator do?

• Unregister as versioned on the feature dataset and then register as versioned again
• Register as versioned on the feature dataset one additional time
• Switch the editing workflow to versioned editing with the move-edits-to-base option

A GIS data manager needs to set up one-way parent-to-child replication to provide read-only copies of data to regional offices. The replication must be set up so that the parent geodatabase can be fully compressed, even if there are unacknowledged data change messages.How should the replication be configured?

• Replicate only the base tables
• Use the Full replica access type
• Use the Archiving option

A GIS database administrator needs to identify any performance issues with a nightly load process. Upon further research, the database administrator discovers the following:A table with 20 million rows is reloaded each nightThis existing table is truncated before an Append is executedThere are three attributes in addition to objectid and geometry, one of which is a unique text identifierThe unique index is removed before Append and created again after AppendThe Append operation takes 120 minutes to complete What should the administrator recommend?

• Remove the objectid index before Append
• Remove the spatial index before Append
• Add a unique key index before Append

A GIS data manager needs to allow editors to see changes made to the default version in their child versions without reconciling.How should the GIS data manager register the dataset?

• Traditional versioned with the option to move edits to base
• Branch versioned with global IDs and editor tracking enabled
• Traditional versioned with archiving and editor tracking enabled

A GIS administrator needs to simultaneously grant access for multiple users of a branch versioned feature class in an enterprise geodatabase.How should permissions be granted?

• To a role
• To a list
• To a group

A database administrator needs to move the enterprise geodatabase to a new server. The new enterprise geodatabase must be kept intact.Which process should be used?

• Export to file geodatabase
• Two-way replication
• RDBMS export/import

An enterprise geodatabase is regularly updated via a "push" batch SQL process from a federated database. Business rules prevent a one-to-one match in the values in INSERT values for one field. The GIS administrator must make sure that the attribute value in the geodatabase is populated correctly. Which option should the administrator use?

• Attribute rule
• DBMS trigger
• Spatial view

A GIS analyst needs to share a large repository of lidar data with the organization. This lidar data will have surface constraints applied for breaklines.Which type of dataset should the GIS analyst use?

• Mosaic dataset
• Feature dataset
• LAS dataset

AGIS data administrator needs to migrate the enterprise geodatabase to another server and wants to have the following changes:New enterprise geodatabase nameChanged Repository tables owner from SDE to DBO Which migration workflow should be used?

• Restore a database backup
• Create a new enterprise geodatabase
• Migrate Storage geoprocessing tool