SPLK-1001 Using Fields and Lookups Practice Question
A security team needs to enrich their authentication events with risk scores from a CSV file that maps username to risk_score. The CSV is updated daily and has 100,000 rows. Which lookup configuration is most appropriate?
⚠ Common exam trap
Splunk often tests the distinction between static CSV lookups and dynamic KV Store lookups, and the trap here is that candidates over-engineer the solution by choosing a KV Store or external lookup when a simple CSV lookup is sufficient for a daily-updated static file.
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
✓
Configure a CSV lookup and use lookup command in search
A CSV lookup is the simplest and most efficient way to enrich events with static data from a file that is updated daily. The `lookup` command can be used in search to match the username field from events to the username column in the CSV and add the risk_score field. For 100,000 rows, a CSV lookup is appropriate as it is loaded into memory and can be refreshed by replacing the file, without needing complex infrastructure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a time-based lookup to match event time with lookup time
Why it's wrong here
Time-based lookups are for time-varying relationships; not applicable here.
- ✗
Set up an external lookup that calls a REST API
Why it's wrong here
External lookups add latency and complexity; not needed for a static CSV.
- ✗
Create a KV Store lookup and update it via REST
Why it's wrong here
KV Store is better for frequently changing data; overkill for daily CSV.
- ✓
Configure a CSV lookup and use lookup command in search
Why this is correct
CSV lookups are efficient for large, periodically updated reference data.
Go deeper
Related to this question
About these practice questions
One of 502 original SPLK-1001 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SPLK-1001 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-1001 exam.