Esri ArcGIS Desktop Professional 19-001 EADP19-001 Exam Practice Test

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 school bus dispatcher needs to create a bus route that stops at student homes during specific time ranges. Which Network Analyst setting should the dispatcher use to accomplish this task?

An ArcGIS user is given a geodatabase containing polygon and point features.

To ensure that the points fall on the boundary, which topology rule should the user set?

An ArcGIS user has multiple tables that must be input into a single model. What can the user add to the model to automate the model to run on all tables?

In a disconnected environment a data receiver fails to send acknowledgement messages often enough. How will the data sender respond?

A tax preparation company completes a quarterly cleaning of their records. Using a Python script they automate the deletion of records that are more than seven years old or records for customers who have not been seen in more than five years.

When using a cursor function, what deletes the appropriate records?

Given an elevation surface, a raster of forest stands, and a point feature class of saw mills, which analysis is used to determine the optimal route from each forest stand to the nearest saw mill?