Objective 2.2

Core Certified Power User

Use the search and where commands to filter results

Objective 2.2 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-2Filtering and Formatting Results

An analyst needs to filter results using a calculation rather than a keyword. Which command does Splunk document for that?

whereCorrect · your answerCorrect.
searchThe search command matches terms and field values against the events.
tableThe table command selects columns without removing rows.
fillnullThe fillnull command replaces missing values.

Correct.

Checked against help.splunk.com, August 2026

Concept

Filtering on a computed comparison is different from filtering on a term that appears in the text. The command that takes an expression is the one that can compare two fields to each other.

Why A

Splunk states that the where command uses eval-expressions to filter search results, that those expressions must be Boolean, and that it returns only the results for which the expression returns true.

Source

The where command uses eval-expressions to filter search results. These eval-expressions must be Boolean expressions, where the expression returns either true or false. The where command returns only the results for which the eval expression returns true.

Splunk Docs: where command, checked August 2026
#where#filtering

Now you: objective 2.2 questions

No account needed. The explanation opens when you answer.

Sample question 1 of 3

2-2Filtering and Formatting Results

You filter search results with the where command, and it keeps only some of the rows it is given. What must the eval expression you hand it return for each result?

Sample question 2 of 3

2-2Filtering and Formatting Results

A team wants to keep only results where one field is larger than another field. Which command handles that comparison?

Sample question 3 of 3

2-2Filtering and Formatting Results

A new analyst types index=web status=500 into the search bar, gets events back, and never names a command first. What is the position of the search command here?

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