EGMA105 Online Practice Questions and Answers

An administrator runs a nightly compares on a versioned geodatabase. In the morning the administrator

checks the compares _ log and sees it is successful, but the number of state did NOT decrease. All users

are working on the DEFAULT version an tend to run geoproccessing tools overnight.

Why is the compress NOT removing any state?

A. The connected map sessions are locking state.

B. The connected map sessions are locking the compress_log

C. The administrator needs INSERT and DELETE permission on the compress_log

D. The administration needs INSERT, UPDATE and DELETE permission on the state table.

A GIS administrator connects to a database as the data owner, and uses the ArchCatalog menu to enable the enterprise goedatabase. The tool does NOT succeed. What does the administrator need to do to successfully run the tool?

A. Turn off 64 bit background geodatabase

B. Connect as a user who does NOT own data in the database.

C. Connect as a user who qualifies as a goedatabase administrator

D. Use the geoprocessing tool of the context menu

Which method of data transfer should be used if the Global ID column must be preserved in the target table?

A. Append

B. Object Loader

C. Simple Data Loader

D. Copy/past Feature Class

Which reconcile option should selected to detected all no level conflicts?

A. By object

B. By attribute

C. By root

D. By class

What must an administrator do to more rows from the data tables to the business tables of a feature class?

A. Reconcile and post all versions

B. Disconnect all users

C. Compress the geodatabase

D. Delete all versions

A company has been using SDEBINARY spatial storage for the feature classes in Oracle, but would like to being using ST_GEOMETRY. What workflow is the most efficient way to get existing data from SDEBNARY to ST_GEOMETRY?

A. Use the Migrate geoprocessing tool.

B. Recreate the feature classes, and specify the proper configuration keyword.

C. Update the dbtune and restart the Oracle server.

D. Install the ST_GEOMETRY and restart the server.

A GIS analyst sets up a layer file to display managed in an enterprise geodatabase. When using the layer file in a map, the user notices the following issues:

1.

A read exclamation mark appears next to the layer

2.

The layer fails to display any feature Which aspect of the file is causing the problem?

A. OS authentication

B. Invalid SQL statement in the definition query

C. Unavailable in the definition query

D. Invalid label expression

What is an example of a point topology rule?

A. Must Be Single part

B. Must Be properly Inside

C. Must Be Inside

D. Must Not intersect

GIS analysts frequently report degraded performance when working with data in an enterprise geodatabase. The analysts work with non-versioned data and use database views for reference data. Which new workflow should the GIS administrator use to improve performance for the analysts?

A. Use AcrCatalog to register the views with the geodatabase.

B. Register the feature classes as versioned.

C. Use ArcMap to join reference data to the feature classes.

D. Create relationships classes on the features to include the referenced data.

A GIS analysts establishes a connection to a SQL Server instance and imports data No related data was import. Upon further inspection, the analyst notices that the option to create a new

relationships class is NOT available in the ArcCatalog context menu.

Which component that provides access to advanced functionality is the GIS analyst missing?

A. ArcGIS Desktop client

B. Enterprise geodatabase

C. Relational Database Management System

D. Data client software