EGMP2201 Enterprise Geodata Management Professional 2201 Exam Free Dumps

1. An editor connects to an enterprise geodatabase to edit a feature class that uses traditional versioning.

The editor uses the following workflow:

• The Default version is set lo protected

• A new child version is created from Default

• The child version is set to protected

• Edits are saved to the child version

• The editor tries to reconcile and post to Default

The reconcile is successful, but the post operation fails with an error.

What should the editor do?

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

3. Slow performance is observed on a query of an indexed attribute on a large feature class in an enterprise geodatabase.

• A SOL trace reveals that the attribute index is not being used in the query

• The indexed attribute values have a high degree of uniqueness

• The delta tables do not have very many rows

Which tool should be used to resolve this issue?

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

5. Multiple editors in a web application need to collaboratively edit the same dataset using the following requirements:

• Each editor works in isolation until they come to a good stopping point

• The editor shares their edits with the other editors at this point

• The editor again goes into isolation to continue editing until the next stopping point is reached

• At any point, an editor can choose to see the edits that other editors have shared without sharing their own edits

How should the dataset be registered?

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

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

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

9. All editors reconcile and post their versions daily. Other users create read-only versions for analysis purposes, so they do not reconcile and post those versions. The geodatabase administrator compresses the geodatabase nightly. For several months, performance steadily worsens.

Which action should be taken?

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

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

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

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

14. An organization has a web service that must always be available. This service reads data from a feature class in an enterprise geodatabase. The GIS administrator needs to update the schema of the feature class.

Which workflow should be used?

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

16. AGIS data administrator needs to prepare data for use in offline workflows.

Which database operation must the data administrator perform?

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

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

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

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

21. The GIS administrator does not have the database administrator credentials and needs to create an enterprise geodatabase for storage of vector data. The database administrator will provide a database with the appropriate users and permissions for use.

Which tool should the GIS administrator use?

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

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

24. ArcGIS Pro users must be able to use the Undo and Redo buttons while editing a dataset. At the same time, SQL users must be able to edit this dataset.

How should the ArcGIS data administrator configure this dataset?

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

26. A GIS data administrator receives a request to create a database view that meets the following criteria:

• Data is combined from feature class and nonspatial table

• Source feature class is versioned

• Source is from a child version

• Needs to be dynamically updated

How should the view be created?

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

28. A user accidentally deletes an enterprise geodatabase feature dataset.

Which technology should be used to resolve the issue?

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

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

31. A GIS administrator needs all users to immediately see the edits that are made while editing a feature class.

Which configuration should be used?

32. AGIS analyst who usesArcGIS Pro needs to reload data into a versioned feature class stored in a feature dataset. The feature class participates in a geodatabase topology.

Which steps should the GIS analyst take?

33. An editor is loading records from a shapefile to a feature class that is registered as versioned using the following workflow:

• Create a child version from Default

• Append 500,000 records while connected to the child version

• Reconcile and post the child version to Default

The reconcile is taking a long time to complete.

What is causing this issue?

34. 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

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

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

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

38. A user in an organization is granted read/write access to the data. The user saves the username and password in a connection file for convenience. This user creates layer files that save visualization properties and organizes them in folders on the server for the viewers to access.

Which issue is caused by this workflow?

39. An organization needs to reduce the number of RDBMS users. ArcGIS Enterprise and ArcGIS Pro are implemented. Editors need to isolate edits and ensure that edits are reviewed before becoming public.

Which editing model should the GIS administrator implement?

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

41. An organization needs to edit GIS data using web services. The data must be stored locally in the organization's servers. Specific business fields must be indexed in the database to help with performance.

Which storage should be used for the data?