SPLK-1002 Advanced Visualization and Lookups Practice Question
Exhibit
Refer to the exhibit. ``` | inputlookup asset_lookup | where asset_type="server" | stats count by location ``` The lookup definition `asset_lookup` points to a CSV file with columns: asset_id, asset_type, location, owner. The search returns an error: 'Error in 'where' command: The field asset_type does not exist.'
What is the MOST likely cause of this error?
⚠ Common exam trap
Splunk often tests the subtlety that CSV headers are parsed literally, including whitespace, and candidates mistakenly assume Splunk automatically trims or normalizes field names, leading them to overlook trailing spaces as the root cause.
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
✓
The CSV file has a trailing space in the column header 'asset_type'.
The error is most likely caused by a trailing space in the CSV column header 'asset_type'. When `inputlookup` reads a CSV file, it treats column headers as literal strings; a trailing space makes the field name 'asset_type ' (with a space) instead of 'asset_type'. This mismatch causes the `where` command to fail because it references 'asset_type' without the space, leading to a field-not-found error.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The lookup is not configured to output all fields.
Why it's wrong here
`inputlookup` outputs all fields by default.
- ✗
The lookup definition filename is incorrect.
Why it's wrong here
The search would not find the lookup.
- ✓
The CSV file has a trailing space in the column header 'asset_type'.
Why this is correct
Trailing spaces cause field name mismatch.
- ✗
The `where` command cannot be used after `inputlookup`.
Why it's wrong here
It can be used.
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 →
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.