A GIS administrator receives reports of slowing performance across the entire geodatabase. Users report that the time for edits to be made and drawing are affected when adding 10.000 records. Traditional versioning is being used.

The following processes are completed weekly:

• Rebuilding of indexes and statistics

• Geodatabase compress

• Remove orphaned connections

Which action should be taken?

A user plans to use a standard database view of a roads feature class from a geodatabase that is different from the primary enterprise geodatabase. Roads is frequently edited in the parent geodatabase, so the user needs to regularly synchronize and have the view recognize all incoming edits immediately.

Which replica type should be used?

An organization has ArcGIS Enterprise. A new project requires versioned editing with the ability to show which user deleted a feature from the default version.

Which editing workflow should be used?

After running a Compress, the GIS administrator needs to check if the Adds and Deletes tables for Buildings are empty before unregistering as versioned.

What should be referenced by the GIS administrator?

A GIS data administrator frequently changes the map based on definition queries. A noticeable lag occurs when changing the parameter value of the definition query.

Which action should be taken?

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 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?

A GIS data administrator is unable to upgrade the geodatabase while editors have active sessions and are working on editing workflows.

What should the editors do?

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 user creates a database view of a feature class and then registers the view with the geodatabase.

How does registering benefit users?

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?

An organization has a requirement to allow editing of feature classes in mobile and web apps. A database administrator will need to add indexes to feature classes to improve performance on common queries.

Where should these feature classes be stored?

A data owner creates a one-way replica parent-to-child for a single feature class to share data from a production geodatabase to a public-facing geodatabase.

• The data owner synchronizes once a week to share updated data

• In time, the data owner wants to add a new attribute field/field type and calculates new attribute values

• The data owner synchronizes the replicas, but the new field and values are not present in the child replica

• In the public-facing geodatabase, the data owner adds the same attribute field and field type

• The data owner synchronizes the replicas again, and the values are not replicated in the child replica

How should the data owner resolve this issue?

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?

A GIS administrator receives reports that users are unable to connect to the geodatabase after nightly maintenance. The GIS administrator can successfully connect.

What should the administrator check for?

A GIS administrator needs to facilitate the collaboration of two teams of GIS analysts in two different offices. Each office needs a copy of the data in its own enterprise geodatabase. and analysts in both offices will edit the same feature classes. Changes will be synchronized nightly.

The GIS administrator needs to set up the information infrastructure so that both teams can work together.

What should the administrator use to meet the requirements?

An organization needs to distribute data to a regional office. The regional office does not have ArcGIS Enterprise orArcGIS Online accounts. The regional office also does not have access to an enterprise geodatabase.

Which data distribution solution should be used?

A GIS administrator needs to convert an existing database into a geodatabase. The new database has been created, but the repository owner has not been created. The GIS administrator has been given the database administrator credentials for this conversion to a geodatabase.

Which tool should the GIS administrator use?

A user wants to share a frequently edited points feature class as a web layer. The points contain sensitive attributes and will be read-only for online viewers.

The following workflow is applied:

• Points is registered as versioned

• A standard database view is created for points, which hides the sensitive attributes

• The view is published as a web layer from the Default version

As the points feature class is edited throughout the week, edits are not visible in the web layer.

What should the GIS administrator do?