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 EADP19-001 Exam - Topic 6 Question 62 Discussion

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?
A) (FeatureClassA OBJECTED is Not Null) and (TableB.cancerrate Is Not Null)
B) ('FeatureClassA OBJECTED' is Not Null) and (TableB.cancerrate is Not Null)
C) ('FeatureClassA OBJECTED'. 'TableB cancerrate' is Not Null)
D) ('FeatureClassA OBJECTED' and 'TableB cancerrate' is Not Null)

Esri EADP19-001 Exam - 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:

0/2000 characters
Submit Cancel
Nadine
9 months ago
Wait, are we sure any of these will work? Sounds off.
upvoted 0 times
...
Rosalyn
10 months ago
D? Really? That doesn’t even follow the syntax!
upvoted 0 times
...
Mohammad
10 months ago
C doesn't make sense, it’s not properly formatted.
upvoted 0 times
...
Wei
10 months ago
I think B is the right choice, looks cleaner.
upvoted 0 times
...
Bonita
10 months ago
Option A seems correct, both need to be not null.
upvoted 0 times
...
Laticia
10 months ago
I'm leaning towards option B, but I keep second-guessing myself about the use of quotes around OBJECTID.
upvoted 0 times
...
Alishia
11 months ago
I feel like we did a similar question in class, and I think it was about checking for null values in both tables.
upvoted 0 times
...
Annabelle
11 months ago
I think option A looks familiar, but I can't recall if the OBJECTID needs to be in quotes or not.
upvoted 0 times
...
Merrilee
11 months ago
I remember we practiced exclusion queries, but I'm not sure if the syntax is exactly right for this question.
upvoted 0 times
...
Eura
11 months ago
I think option A is the way to go. It clearly checks that both the feature class object ID and the cancer rate are not null, which should give us the clean data we need for the map.
upvoted 0 times
...
Vanda
11 months ago
This is a tricky one. I'm a bit confused by the syntax in some of the options, like the use of single quotes. I'll need to double-check the proper syntax for ArcGIS queries.
upvoted 0 times
...
Cherilyn
11 months ago
I'm leaning towards option A. The wording looks the most precise in terms of checking that both the feature class object ID and the cancer rate are not null.
upvoted 0 times
...
Stephanie
11 months ago
Okay, let's think this through step-by-step. We need to use a query that checks both the feature class and the cancer rate table to ensure we only include records with non-null values in both.
upvoted 0 times
...
Leoma
11 months ago
This question seems straightforward, but I want to make sure I understand the requirements correctly. The key seems to be eliminating the null values from the cancer rate data.
upvoted 0 times
...
Irma
2 years 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
Irene
2 years ago
User 2: Agreed, we don't want any 'cancer-free' postal codes in there. B it is.
upvoted 0 times
...
Dominque
2 years ago
User 1: I think B is the way to go. Double check for those null values.
upvoted 0 times
...
...
Tora
2 years 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
2 years 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
2 years 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
2 years 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
2 years ago
Definitely, B is the way to go. We need accurate data for the map.
upvoted 0 times
...
Florencia
2 years ago
B) ('FeatureClassA OBJECTED' is Not Null) and (TableB.cancerrate is Not Null)
upvoted 0 times
...
Melodie
2 years ago
A) ('FeatureClassA OBJECTED' is Not Null) and (TableB.cancerrate is Not Null)
upvoted 0 times
...
...
Amie
2 years 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
2 years 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
2 years ago
Exactly. It's important to eliminate any null values to get an accurate representation of the cancer rates.
upvoted 0 times
...
Whitley
2 years ago
That's true. We need to make sure both fields have data to accurately symbolize the map.
upvoted 0 times
...
Belen
2 years 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
2 years ago
I think option B is the correct one.
upvoted 0 times
...
...

Save Cancel