Esri Esri Others Certification EGMA105 Questions & Answers

• Question 1:

  Which kind of lock is required to modify the structure of a table geodatabase?

  A. Object lock

  B. Version lock

  C. Schema lock

  D. Table lock

  Correct Answer: C

• Question 2:

  Two editors work on the same versioned streets feature class. The editors each work in their own transaction versions, and each version is a child of DEFAULT. Editor A only makes updates to the streetcode and StreetType columns, while Editor B only edits the geometry Which conflict resolution option will result in the least number of conflicts?

  A. By object (by row)

  B. By attribute (by column)

  C. In favor of the Target Version

  D. In favor of the Edit Version

  Correct Answer: B

• Question 3:

  A company needs to use on-way replication to synchronization edits from its child geodatabase to its read-only parent goedatabase. Only one editor will be responsible for editing the child goedatabase.

  Which option should company use for the child?

  A. Personal goedatabase

  B. File goedatabase

  C. Desktop goedatabase

  D. ArcGIS Data Store

  Correct Answer: A

• Question 4:

  Users would like to build database connections to versions other than DFFAULT. Which Context menu item should be used?

  A. Administrator Geodatabase

  B. Connection Properties

  C. Geodatabase Connection Properties

  D. Properties

  Correct Answer: A

• Question 5:

  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

  Correct Answer: C

• Question 6:

  An empty table in a geodatabase has a field that is incorrectly defined as a numeric value field without

  decimal values. The attribute filed needs to store numeric values with decimal values within a specific

  range.

  Which tool or method should be used to updated the filed type?

  A. The Filed Calculator

  B. The Calculate Field tool

  C. The Alter Field tool

  D. The Transpose Filed tool

  Correct Answer: A

• Question 7:

  An administrator needs the ability to perform versioned editing in the database. What component must be added to the database?

  A. Versioned view

  B. Geodatabase repository

  C. An application listener process

  D. Database replication

  Correct Answer: D

• Question 8:

  The geodatabas administrator has requested the data creator make changes to the geometry storage of a feature class. The features class will need to be changed from SQL Geometry to SDEBINARY. Which workflow should the data creator use?

  A. Use the Migrate Storage geoprocessing tool

  B. Changes the geometry storage type in the feature class properties.

  C. Use the geometry Spatial Reference geoprocessing tool

  D. Copy and paste the feature class to after the geometry storage type

  Correct Answer: D

• Question 9:

  User B is working on a project that requires access to some feature classes owned by User Which user can grant privileges to User B on the feature class?

  A. GIS Administrator

  B. Editor

  C. User A

  D. User B

  Correct Answer: B

• Question 10:

  A user in the accounting department needs to only view and query the Customer_Location feature class in the goedatabse. The user can already lane a Database Connection will the operating system login, but CANNOT see any data in the geodatabase. What is the recommended workflow to give the user the necessary access to the feature class?

  A. Have a data editor grant SELECT dataset the user the necessary access to the feature class

  B. Have a data editor grant SELECT, INSRT, UPDATE, and DELETE dataset privilege's to the operating system login.

  C. have the data owner grant SELECT, dataset privileges to the operating system login.

  D. Have the data owner grant SELECT, INSERT, UPDATE, and DELETE database privileges to the Active Directory

  Correct Answer: A