An ArcGIS has created a definition query on a parcel feature in a personal geodatabase to only show areas classified as residential. The user's company has decided to update all personal geodatabase to file geodatabases.
When the ArcGIS user updates the source data to point to the parcel feature class in the file geodatabase they receive the following error.
"One or more layers failed to draw:
Parcel: An invalid SQL statement was used. [Select Shape FROM Parcel WHERE [Parcel] B residential] Parcel: An invalid SQL statement was used" What is the correct SQL statement for the file geodatabase?

• A. {Parcel} = residential
• B. Parcel = residential
• C. "Parcel" = residential
• D. [Parceii = residential

An ArcGIS user has overlayed two polygon feature classes to produce an output feature class with the following user-managed attributes:
* Soil_Code
* Aquifer_Type
* SuitabilityClass
Which geoprocessing operation should the user perform in order to combine the polygons of the output feature class based on the Suitability_Class attribute value?

• A. Dissolve
• B. Erase
• C. Merge
• D. Aggregate Polygons

An ArcGlS user adds an ESRl World Imagery service from ArcGlS Online to an empty Arc Map document.
The user then adds a polygon feature class representing national parks to the map.
The spatial reference of the national parks feature class is:
* Datum North American Datum 1927
* Linear units meters
* Protection Albers equal area
The user intends to digitize new national park boundaries using the features in the imagery.
What should the user avoid doing in the edit session?

• A. reprojecting the national park feature class and transforming the coordinate system to match the imagery from the Web service
• B. editing the park boundary laver without changing the original coordinate Systems
• C. transforming the coordinate system of the national parks to match the Imagery from the Web service
• D. projecting the coordinate system of the imagery to match the national parks

Upon opening a model In ModelBuilder. one 01 the tools has a repair icon next to it. How can the model be repaired?

• A. click the Auto Layout button to update the tool
• B. Select and update the problem tool
• C. validate and save the entire model to update the tool
• D. open the model properties and disable the use of relative path names

An ArcGIS user is making a map showing the standard deviation from the mean ocean temperature. Which type of color ramp should be used to display the standard deviation?

• A. a three-color multipart color ramp
• B. a thirteen-color preset color ramp
• C. a random color ramp
• D. a two-color algorithmic color ramp