Q39. 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 <value> in the join table <value> is not indexed.
Which tool should the analyst run?

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

Q41. AGIS data manager realizes that archiving cannot be enabled for a feature class. An investigation reveals that the problem is in the feature class configuration.
How was the feature class registered?

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

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

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

Q45. A GIS administrator creates a SQL command to update values in a feature class. In a test environment, the command is run against the feature class table. All the values do not seem to get updated.
Which configuration is causing this issue?

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

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

Q48. A user accidentally deletes an enterprise geodatabase feature dataset.
Which technology should be used to resolve the issue?

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

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

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

Q52. A GIS data administrator creates a replica pair to publish changes from the organization’s production server to a consultant’s server. Edits are being performed on the data in the consultant’s replica and are overwritten as they conflict with edits applied during synchronization.
Which replication type is causing this issue?

Q53. A GIS administrator is getting reports from users that they are unable to edit data within a traditionally versioned feature dataset. A feature class was added to a feature dataset during a maintenance window. The following troubleshooting steps were performed but do not correct the behavior:
* Checked permissions on feature dataset
* Checked connection file for versioning type
* Rebuilt indexes and statistics
What should the administrator do?

Q54. A wells feature class has one row per well. A well_inspections table has one row for each time a well was inspected. All inspection dates need to be displayed as labels clustered around each well on the map.
Which kind of association should be used to meet this requirement?

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

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

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