MENU
A GIS analyst has a countrywide parcel dataset and needs to determine the property owners for the northern region of the country. The analyst wants to find owners whose last name contains Jon.
Which query should the analyst use?
Suggested Answer: A
Get Premium EAPA_2025 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
20 comments · newest first
RE
Rene
2 months ago
Definitely A! It filters correctly for our needs.
LI
Ling
2 months ago
Right! A captures all variations of 'Jon'. It's the most effective.
NO
Norah
2 months ago
I feel option C is too restrictive. What if the last name is longer?
RA
Raymon
2 months ago
Option B is tempting, but it’s too broad. We need specific owners.
DO
Dorian
2 months ago
Agreed! A makes sense. We need both conditions to be true.
PR
Precious
3 months ago
I think option A is the best choice. It narrows down to the northern region and includes 'Jon'.
MO
Mollie
3 months ago
Definitely A, no doubt about it!
SH
Shawnda
3 months ago
Wait, does "LIKE" really work for partial matches?
VI
Virgilio
3 months ago
C is way too restrictive, it won't capture all the "Jon" owners.
LA
Laura
3 months ago
I think B could work too, but not as specific.
GE
Gerardo
3 months ago
Option A is the right choice!
LI
Ling
4 months ago
C is definitely wrong, it’s too strict!
FA
Fatima
4 months ago
Wait, why would they use LIKE for just 'Jon'? Seems odd.
CO
Corrina
4 months ago
I think B could work too, but it’s not specific enough.
CH
Cheryll
6 months ago
Totally agree, A is the way to go!
FA
Fatima
6 months ago
The correct query is A) Region = 'North' AND OwnerName LIKE 'Jon'.
MA
Marjory
6 months ago
I practiced a question similar to this, and I think it was about using AND for multiple criteria. So maybe A is the right choice?
CL
Claribel
6 months ago
I feel like the answer might be A, but I’m confused about whether LIKE can handle just 'Jon' or if it needs to be 'Jon%' for it to work properly.
RO
Royal
7 months ago
I’m not entirely sure, but I remember something about using LIKE for partial matches. Does that mean we need to include wildcards?
LE
Leana
7 months ago
I think the query needs to use AND because we want both conditions to be true, right?