SPLK-1002 Advanced Visualization and Lookups Practice Question
A security analyst is using a lookup table to enrich IP addresses with threat intelligence. Which THREE statements about lookups are true?
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
✓
Lookups can be used to add fields from an external source
Lookups can be automatic via props.conf, can be based on CSV or KV Store, and are used to add fields from an external source. They are not limited to exact match (range lookups exist) and do not require data to be indexed in Splunk.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Lookups can be used to add fields from an external source
Why this is correct
That is the primary purpose of lookups: enrichment.
- ✗
Lookups can only be used with exact match
Why it's wrong here
Lookups support various match types including CIDR, range, and exact.
- ✗
Lookups require the data to be indexed in Splunk
Why it's wrong here
Lookups reference external data; the data does not need to be indexed.
- ✓
A lookup can be configured as automatic in props.conf
Why this is correct
Automatic lookups are defined in props.conf using the LOOKUP attribute.
- ✓
Lookups can be based on CSV files or KV store
Why this is correct
Both file-based (CSV) and KV Store lookups are valid.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SPLK-1002 question from scratch — 475 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
5 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. Which TWO statements about lookups in Splunk are correct? (Choose two.)
medium- ✓ A.The lookup command can be used to add fields from a lookup table to search results
- B.External lookups can only be used with CSV files
- ✓ C.KV store lookups support real-time updates during a search
- D.CSV lookups can be updated in real-time by adding rows to the CSV file
- E.Automatic lookups are configured in macros.conf
Why A: The `lookup` command in Splunk is specifically designed to enrich search results by adding fields from a lookup table (such as CSV, KV Store, or external lookups) based on matching field values. This is a fundamental use case for lookups in Splunk, allowing you to augment raw event data with additional context from a static or dynamic source.
Variation 2. Which TWO of the following statements about lookup tables in Splunk are true?
medium- A.Lookups can only add new fields to events; they cannot replace existing field values.
- B.External lookups can only retrieve data from CSV files.
- ✓ C.KV Store lookups require defining a collection in collections.conf.
- ✓ D.CSV lookups can be updated by replacing the CSV file without restarting Splunk.
- E.Lookup files can only be stored in $SPLUNK_HOME/etc/system/lookups/.
Why C: CSV lookups can be updated by replacing the file; Splunk automatically reloads them. KV Store lookups require a collection definition in collections.conf. The other options are false: lookup files can be stored in app directories, external lookups can connect to various data sources via scripts, and lookups can replace field values if configured with overwrite=true.
Variation 3. Which TWO statements about lookup tables are true?
easy- A.Lookups can only be defined by administrators.
- ✓ B.A lookup definition can include time-based expiration.
- C.Lookups are case-sensitive by default.
- ✓ D.Lookups can be defined from CSV files or KV store collections.
- E.Lookups can only be used in the 'lookup' command.
Why B: Options B and D are correct. B: A lookup definition can include time-based expiration, allowing lookups to automatically refresh after a specified period. D: Lookups can be defined from CSV files or KV store collections, providing flexibility in data sources. A is false because lookups can be defined by power users and administrators, not just administrators. C is false because lookups are case-insensitive by default, not case-sensitive. E is false because lookups can be used in multiple commands such as 'lookup', 'inputlookup', and 'outputlookup'.
Variation 4. A company needs to enrich search results with additional fields from a CSV file. Which method should they use to define the lookup table so that it is available in all searches?
easy- A.Define the lookup in props.conf with an automatic lookup stanza.
- B.Use the inputlookup command in a search.
- ✓ C.Define the lookup in transforms.conf with a filename and field mapping.
- D.Use the lookup command with the file path.
- E.Use the eval command with the lookup function directly in search.
Why C: To make a lookup table available in all searches, the lookup definition must be created in transforms.conf. This file defines the lookup table filename, field mapping, and other properties. Once defined, the lookup can be used with the lookup command, the inputlookup command, or automatic lookups configured in props.conf. Option C correctly identifies this requirement.
Variation 5. A security analyst wants to map IP addresses to hostnames using a CSV lookup file. Which command is correct to define a lookup that maps the IP field to hostname field, with the file named 'ip_host.csv'?
easy- A.lookup ip_host.csv hostname OUTPUT ip
- B.lookup ip_host.csv hostname as hostname ip as ip_output
- C.inputlookup ip_host.csv
- ✓ D.lookup ip_host.csv ip as ip_output hostname as hostname_output
Why D: The lookup command syntax for mapping multiple fields is 'lookup <lookup-table> <input-field1> as <output-field1> <input-field2> as <output-field2>'. Here, 'lookup ip_host.csv ip as ip_output hostname as hostname_output' correctly maps the ip field from your data to ip_output in the lookup, and hostname from the lookup to hostname_output. Option A incorrectly uses OUTPUT, which is used for single field output. Option B has reversed order and missing output alias. Option C returns all rows without mapping.
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.