Esri Exam EADP19-001 Topic 1 Question 63 Discussion

Actual exam question for Esri's EADP19-001 exam

Question #: 63
Topic #: 1

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[Parceii = residential

CParcel = residential

D'Parcel' = residential

Show Suggested Answer

Suggested Answer: C

by Sherell at Jan 28, 2025, 10:07 AM

Limited Time Offer

25%

Off

Get Premium EADP19-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Twana

5 days ago

Option B 'Parceii = residential' - that's gotta be the one, right? I mean, who doesn't love a little typo in their SQL statements?

upvoted 0 times

...

Zoila

7 days ago

Ah, the age-old debate of SQL syntax for geodatabases. I'm going with option C - keep it simple, keep it classic.

upvoted 0 times

...

Jesse

8 days ago

I'm not sure, but I think C) Parcel = residential could also be correct.

upvoted 0 times

...

Belen

9 days ago

Hmm, this is tricky. I'm torn between options C and D. Maybe I should just ask the instructor to clarify the syntax for file geodatabases.

upvoted 0 times

...

Nickolas

10 days ago

I think option D is the way to go. The field name 'Parcel' needs to be enclosed in double quotes since it might have spaces or special characters.

upvoted 0 times

...

Kristine

12 days ago

The error message indicates that the SQL statement used in the definition query is invalid for the file geodatabase. Option C 'Parcel = residential' looks like the correct SQL statement to use.

upvoted 0 times

...

Nana

12 days ago

I believe the correct SQL statement is D) \'Parcel\' = residential.

upvoted 0 times

...

Jaime

16 days ago

I think the correct SQL statement is A) {Parcel} = residential.

upvoted 0 times

...