Objective 2.3

Core Certified Power User

The fillnull command

Objective 2.3 sits in Filtering and Formatting Results, which carries 10% of the Core Certified Power User exam. The questions below are original, written from the official objective title above, and each explanation cites the Splunk page it rests on.

Objective title verbatim from the official objectives. Splunk exam page

A worked example

Shown solved, with the whole explanation open: this is what every question here carries.

2-3Filtering and Formatting Results

A report has gaps where some results lack a field. Which command does Splunk document for replacing those nulls?

fillnullCorrect · your answerCorrect.
evalThe eval command can compute a replacement, but fillnull is the documented command for this.
whereThe where command removes results rather than filling them.
renameThe rename command changes a field's name.

Correct.

Checked against help.splunk.com, August 2026

Concept

A missing value and a zero are different facts, and a table full of blanks is hard to read or chart. Filling them is a presentation decision that should be made deliberately rather than left to the renderer.

Why A

Splunk states that the fillnull command replaces null values with a specified value, and defines null values as field values missing in one result but present in another.

Source

Replaces null values with a specified value. Null values are field values that are missing in a particular result but present in another result. Use the fillnull command to replace null field values with a string.

Splunk Docs: fillnull command, checked August 2026
#fillnull#formatting

Now you: objective 2.3 questions

No account needed. The explanation opens when you answer.

Sample question 1 of 3

2-3Filtering and Formatting Results

A user runs fillnull without naming a replacement value. What does Splunk say is used by default?

Sample question 2 of 3

2-3Filtering and Formatting Results

An analyst asks what Splunk means by a null value in search results. How does Splunk define it?

Sample question 3 of 3

2-3Filtering and Formatting Results

An analyst needs to fill nulls in several fields at once. What does Splunk say fillnull can cover?

Full Core Certified Power User question bank coming

We’re writing the complete bank from the official objectives right now. Leave your email and we’ll tell you when it ships, nothing else, ever.

Read the sources

These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.

More objectives in Filtering and Formatting Results