Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Esri Exam EADP19-001 Topic 6 Question 62 Discussion

Actual exam question for Esri's EADP19-001 exam
Question #: 62
Topic #: 6
[All EADP19-001 Questions]

After the ground water is the local community was contaminated by a landfill, the health department requested a map showing the cancer rate for each postal code. An ArcGlS user Is provided a file geodatabase feature class (FeatureClassA) that has been joined to a cancer rate table (TableB). The cancer rate table does not have data for each postal code In the study and also contains data outside the study area creating null values. To eliminate the null values from being symbolized.

Which exclusion query should be used?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Cyril at Jan 10, 2025, 01:39 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Irma
17 days ago
I'm gonna have to go with B on this one. Keeping it simple with the double-not-null check. Wouldn't want to accidentally include any 'cancer-free' postal codes, would we? *chuckles*
upvoted 0 times
Dominque
5 days ago
User 1: I think B is the way to go. Double check for those null values.
upvoted 0 times
...
...
Tora
29 days ago
I think D is the way to go. Seems more straightforward to check that both the object ID and cancer rate are not null in a single condition.
upvoted 0 times
...
Malinda
1 months ago
I'm not sure, but I think option C) is also a valid choice. It seems to be specifying the relationship between the two datasets.
upvoted 0 times
...
Matthew
1 months ago
I agree with Amie. Using that query will ensure we only symbolize data that is relevant to the study area.
upvoted 0 times
...
Dyan
1 months ago
Definitely going with B. Can't have any null values messing up the cancer rate map, right? Gotta get that data clean.
upvoted 0 times
Mable
4 days ago
Definitely, B is the way to go. We need accurate data for the map.
upvoted 0 times
...
Florencia
6 days ago
B) ('FeatureClassA OBJECTED' is Not Null) and (TableB.cancerrate is Not Null)
upvoted 0 times
...
Melodie
12 days ago
A) ('FeatureClassA OBJECTED' is Not Null) and (TableB.cancerrate is Not Null)
upvoted 0 times
...
...
Amie
1 months ago
I think the correct exclusion query should be A) (FeatureClassA OBJECTID is Not Null) and (TableB.cancerrate Is Not Null)
upvoted 0 times
...
Lynelle
1 months ago
Option B looks the most correct to me. The query should check that both the feature class object ID and the cancer rate column have non-null values.
upvoted 0 times
Peter
16 days ago
Exactly. It's important to eliminate any null values to get an accurate representation of the cancer rates.
upvoted 0 times
...
Whitley
24 days ago
That's true. We need to make sure both fields have data to accurately symbolize the map.
upvoted 0 times
...
Belen
27 days ago
Yes, I agree. It makes sense to check both the feature class object ID and the cancer rate column for non-null values.
upvoted 0 times
...
Glen
28 days ago
I think option B is the correct one.
upvoted 0 times
...
...

Save Cancel