EGMP2201 Practice Exam Questions and Answers

A GIS administrator needs to make a synchronized copy of a branch versioned dataset. Editing must be performed on both copies.

How should the data be replicated?

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?

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?

An organization uses a two-way replica to share edits for a polygon feature class with a field office. After months of synchronizing edits, a schema change takes place using the following workflow;

• A new field called a legal_area is added to a polygon feature class in the parent geodatabase

• An editor uses the Calculate Geometry tool to calculate legal_area for each polygon

• The child geodatabase does not have the legal_area field in the polygon feature class

• The parent geodatabase synchronizes the replica to the child geodatabase

What happens during synchronization?

A GIS analyst creates a join relationship between a large dataset and a nonspatial table to calculate an attribute field. Upon building the join, the analyst receives an error message stating that the join field in the join table is not indexed.

Which tool should the analyst run?

A GIS administrator learns that geodatabase users report decreasing performance when adding data from child versions to their map.

• The organization uses a complex traditional version tree architecture

• Python script completes batch-reconcile/post operations, compresses the geodatabase, and data owners rebuild indexes and update statistics

• Python script runs overnight with little to no geodatabase connections being made

Which Analyze Datasets parameter should be checked?

AGIS database administrator needs to create an index to improve query performance on a large enterprise geodatabase facility_inspections feature class.

The query to be optimized is as follows:

SELECT facility_type,inspection_date

FROM facility_inspections WHERE inspector_name = 'JQSmith' ORDER BY inspection_date

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 night

• This existing table is truncated before an Append is executed

• There are three attributes in addition to objectid and geometry, one of which is a unique text identifier

• The unique index is removed before Append and created again after Append

• The Append operation takes 120 minutes to complete

What should the administrator recommend?

A GIS data manager observes that editors spend multiple hours resolving conflicts when they reconcile.

• Conflicts are detected by attribute

• Traditional versioning is being used

• The geodatabase is being compressed weekly

• Versions are reconciled and posted weekly

Which change will result in fewer conflicts?

A GIS data administrator needs to store color, model, and size attributes for different kinds of valves. Pick lists should only show permitted combinations of color, model, and size.

Which geodatabase capability should be configured?