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?
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?
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 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?
An editor performs a field calculation on 500,000 records of a traditional versioned feature class while connected to a child version of Default. In the meantime, the Default version is updated by another editor. The child version is then reconciled with Default.
What will happen to the 500,000 updated records during the reconcile?
An organization has an enterprise geodatabase used for editing and public use. Editors are experiencing performance issues during peak hours. The GIS data administrator needs to make sure that the editing and public usage do not affect each other.
Which action should be taken?
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 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 administrator is investigating reports of slow performance in a map of complex polygons. The investigation finds the following:
• The feature class is in an enterprise geodatabase
• This data has been published as a map service in ArcGIS Enterprise
• The feature class is not versioned
• The map seems to perform slowly at several zoomed-out extents in the map
• Queries on the attributes perform quickly
Which recommendation should the GIS administrator make?
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?
An organization using ArcGIS Enterprise needs to make a map with 10 million features viewable in ArcGIS Online. The data must be kept up to date from an enterprise geodatabase.
Which replication option should the GIS administrator use?
A government organization needs to identify which user was responsible for creating each feature in a global enterprise geodatabase.
Which geodatabase strategy should the GIS administrator use?
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?
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?
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?
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?