Troubleshooting Lookup Enrichment
Network Topology
Refer to the exhibit. An analyst runs a search over access_combined events and notices that some events are not getting the region_name and region_code fields. Which TWO changes could resolve this issue? (Choose two.)
Quick Answer
A lookup enrichment failure like missing region_name and region_code fields almost always traces back to one of two points in the pipeline: either the key field being used to join the lookup isn't extracted properly from the events, or the lookup table itself doesn't contain a matching row for every key value that appears in the data. Here, if clientip isn't reliably extracted from every access_combined event, the lookup command has nothing valid to match against for those events, so no enrichment happens regardless of how complete regions.csv is. Separately, even with clientip extracted correctly, if regions.csv itself doesn't contain an entry for a given IP address, the lookup runs but simply finds no match for that value, again leaving region_name and region_code blank. Because these are two independent failure points, checking that clientip is consistently extracted from the raw events and verifying that regions.csv actually covers the full range of clientip values seen in the data are both necessary changes, and neither one alone guarantees the other is fine. This is a useful general pattern for lookup troubleshooting on the exam: when enrichment is partially failing rather than completely broken, always separate the question of whether the key field exists correctly in your events from the question of whether the lookup table itself has complete coverage for that key.
⚠ Common exam trap
Splunk often tests the distinction between lookup configuration issues (missing key field or missing CSV data) versus lookup performance settings (like `max_matches`), leading candidates to incorrectly choose options that adjust lookup behavior rather than fixing the data or extraction problem.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Check whether the field used for the lookup (clientip) is correctly extracted in the events
If the `clientip` field is not properly extracted from the events, the lookup against `regions.csv` will fail to match, resulting in missing `region_name` and `region_code` fields. The lookup command or LOOKUP- stanza relies on a correctly extracted field to perform the key-value match; without it, no enrichment occurs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase max_matches to a higher value
Why it's wrong here
Max_matches controls the number of rows returned, not whether a match is found.
- ✓
Check whether the field used for the lookup (clientip) is correctly extracted in the events
Why this is correct
If clientip field is not extracted, lookup cannot match.
- ✗
Remove the LOOKUP- stanza and use the lookup command in each search
Why it's wrong here
Automatic lookup is more convenient; removing it is unnecessary.
- ✓
Verify that the lookup file regions.csv contains matching values for all clientip values in the events
Why this is correct
If the lookup file lacks entries, no match occurs.
- ✗
Set default_match to the desired default values for all fields
Why it's wrong here
Default_match only populates fields when there is no match; it doesn't cause missing fields.
Visual reference
Go deeper
Related to this question
About these practice questions
This SPLK-1002 question is part of Courseiva's 475-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on SPLK-1002
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. An admin configured an automatic lookup but events for mysourcetype are not being enriched. What is the most likely problem?
medium- A.The lookup file is too large and memory limit is exceeded.
- ✓ B.The match_type should be 'EXACT' instead of 'WILDCARD'.
- C.The LOOKUP stanza in props.conf is missing the input field specification.
- D.The lookup is defined in transforms.conf but not referenced in any search.
Why B: The WILDCARD match_type requires the event value to contain wildcard characters or be matched glob-style; typical exact matches require EXACT match_type. Option C is possible but the syntax can omit INPUT if the field names match. Options A and D are less likely.
Variation 2. A Splunk admin notices that a time-based lookup (defined in transforms.conf with time_range=TRUE) is not returning correct results for events outside the lookup's time boundaries. The lookup file contains rows with a valid time range. What is the most likely cause?
hard- A.The lookup is defined as an automatic lookup and runs at index time
- B.The lookup table has max_matches set to 1, limiting matches
- C.The lookup file does not contain a time field
- ✓ D.The event time is outside the time range defined in the lookup
Why D: When a time-based lookup is configured with time_range=TRUE in transforms.conf, Splunk restricts lookup matches to events whose timestamps fall within the time range specified in the lookup file. If an event's timestamp is outside that range, the lookup will not return any results, even if other fields match. This is the most likely cause because the question explicitly states that events are outside the lookup's time boundaries.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SPLK-1002 practice question is part of Courseiva's free Splunk certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SPLK-1002 exam.