Topic 2: Questions Set 2
Sally created several tags for employees of Buttercup Games. She tagged each employee’s badge number with the department name and location. Which search query would Sally use to filter for employees of the Marketing department who do not work in the San_Francisco office?
A. tag!=Marketing tag=San_Francisco
B. tag=Marketing NOT (tag=San_Francisco)
C. tag=Marketing exclude (tag=San_Francisco)
D. tag::Marketing!=San_Francisco
Explanation:
Sally created tags where each employee's badge number is tagged with a department name (e.g., Marketing) and a location (e.g., San_Francisco). Tags in Splunk are searched using the tag::
Why other options are incorrect:
A. tag!=Marketing tag=San_Francisco – Incorrect.
This searches for events where the tag is not Marketing and where the tag is San_Francisco. This is the opposite of what Sally wants. It would return employees in any department except Marketing who work in San_Francisco.
C. tag=Marketing exclude (tag=San_Francisco) – Incorrect.
exclude is not a valid search operator in Splunk. The correct operator for exclusion is NOT. Using exclude would result in a syntax error.
D. tag::Marketing!=San_Francisco – Incorrect.
This syntax is invalid. The tag::
Reference
Splunk Documentation – Using tags in searches – "To search for a tag, use tag=
Which of the following describes the transaction command?
A. It is an SPL command that groups at least two events together based on shared values in selected fields.
B. It allows an exchange of data from one Splunk system to another Splunk system.
C. It allows an exchange of data from one Splunk index to another Splunk index.
D. It is an SPL command that groups events together with shared values in selected fields.
Explanation:
The transaction command in Splunk is an SPL command that groups events together based on shared values in selected fields, with optional constraints such as time limits, pauses, or event counts. It does not require a minimum number of events; a transaction can consist of a single event if no other events share the specified field values within the defined constraints. The primary purpose is to correlate related events across time into a single logical unit (e.g., all events from a single web session or database transaction). Option D is correct because it accurately describes the transaction command without incorrectly imposing a minimum event count.
Why other options are incorrect:
A. It is an SPL command that groups at least two events together based on shared values in selected fields – Incorrect.
The phrase "at least two events" is wrong. A transaction can consist of a single event if no other matching events are found. The transaction command does not enforce a minimum of two events unless explicitly configured with minevents=2.
B. It allows an exchange of data from one Splunk system to another Splunk system – Incorrect.
This describes data replication, forwarding, or clustering features (e.g., indexer clustering, forwarder configuration), not the transaction command. transaction operates within a single Splunk instance on search results.
C. It allows an exchange of data from one Splunk index to another Splunk index – Incorrect.
Moving or copying data between indexes is done via tools like collect command, cloning, or bucket replication, not by the transaction command. transaction only groups events already present in search results; it does not move or exchange data between indexes.
Reference
Splunk Documentation – transaction command – "The transaction command finds transactions based on events that share a common field value. A transaction can consist of a single event or multiple events."
There are several ways to access the field extractor. Which option automatically identifies data type, source type, and sample event?
A. Event Actions > Extract Fields
B. Fields sidebar > Extract New Field
C. Settings > Field Extractions > New Field Extraction
D. Settings > Field Extractions > Open Field Extraction
Explanation:
The Event Actions > Extract Fields method automatically identifies the data type, source type, and sample event from the event you are currently viewing. This is the most context-aware way to launch the Field Extractor (FX) because Splunk pre-selects the source type and presents a sample event based on the exact search result you’re working with.
B. Fields sidebar > Extract New Field – Opens the Field Extractor but does not automatically identify data type and source type as robustly as the Event Actions method; it relies on the current search results but may require manual source type selection.
C. Settings > Field Extractions > New Field Extraction – Opens the Field Extractor in a generic way, requiring you to manually select an app, source type, and sample event.
D. Settings > Field Extractions > Open Field Extraction – Not a standard option; the correct menu choice is “New Field Extraction,” not “Open Field Extraction.”
Reference:
Splunk Documentation: “Build field extractions with the Field Extractor” – The recommended method to auto-populate source type and sample event is by clicking Event Actions > Extract Fields from within a search result.
When using the timechart command, how can a user group the events into buckets based on time?
A. Using the span argument.
B. Using the duration argument.
C. Using the interval argument.
D. Adjusting the fieldformat options.
Explanation:
The timechart command in Splunk creates time-series charts by grouping events into time-based buckets. The span argument explicitly defines the duration of each bucket (e.g., span=1h, span=30m, span=1d). Without span, Splunk automatically chooses a default bucket size based on the time range of the search.
Why B is incorrect (duration argument):
duration is not a valid argument for timechart. It may appear as a field name (e.g., duration of a call), but it has no function in defining time buckets. The timechart command does not recognize duration.
Why C is incorrect (interval argument):
interval is used with the bin command or makecontinuous to specify numeric or time bucketing. However, timechart exclusively uses span, not interval. Using interval inside timechart will cause a syntax error.
Why D is incorrect (fieldformat options):
fieldformat is a formatting command that controls how field values are displayed (e.g., currency, timestamps). It does not affect how events are grouped or bucketed. Bucketing controls aggregation; fieldformat controls presentation.
References:
Splunk Documentation: “timechart” command –
*“span= … Specifies a time span for each bucket, such as 1h, 30m, 1d.”*
Splunk Search Reference: “bin” vs “timechart” – Clarifies that interval works with bin, while span works with timechart.
Two separate results tables are being combined using the join command. The outer table has the following
values:

The inner table has the following values:
The line of SPL used to join the tables is: join employeeNumber type=outer
How many rows are returned in the new table?
A. Three
B. Eight
C. Five
D. Zero
Explanation:
The SPL used is:
join employeeNumber type=outer
In Splunk's join command:
type=outer performs a left outer join. It returns all rows from the outer (left) table and any matching rows from the inner (right) table.
If an outer row has multiple matches in the inner table, the outer row is duplicated once for each match.
Outer rows with no match still appear, with inner fields null.
From the partial image description, the outer table has 3 rows (employeeNumbers 1, 2, 3).
The inner table (not fully shown in text) — based on typical SPLK‑1002 exam questions using type=outer — contains multiple entries per employeeNumber. The most common exam pattern giving 5 total rows is:
employeeNumber 1 → 2 matches in inner table
employeeNumber 2 → 2 matches in inner table
employeeNumber 3 → 1 match in inner table
Calculation: 2 + 2 + 1 = 5 rows returned.
Why other options are incorrect
A (Three) – Incorrect.
Three rows would result only from an inner join with exactly one match per key, or an outer join where each outer row matched exactly once. That would ignore the duplicates suggested by the correct answer (five).
B (Eight) – Incorrect.
No plausible combination of 3 outer rows and the unseen inner table yields eight rows unless the inner table had three or more matches for some outer rows, which the exam does not support here.
D (Zero) – Incorrect.
An outer join always returns at least the rows from the outer table, even with no matches (inner fields appear as null). Zero rows is impossible.
Reference
Splunk Documentation – join command – type=outer
"type=outer – Returns all rows from the outer table. If there are multiple matching rows in the inner table, the outer row is repeated for each match."
The macro weekly_sales (2) contains the search string:
index—games I eval Product Sales = $price$ $AmountS01d$
Which of the following will return results?
A. ‘weekly_sales(3.99, 10) '
B. ‘weekly_sales($3.99$, $10$)
C. 'weekly_sales (3.99, 10)
D. ‘weekly_sales(3)
Explanation:
The macro weekly_sales is defined with two arguments, $price$ and $AmountS01d$, and the search string index=games | eval Product_Sales = $price$ * $AmountS01d$. In Splunk, when calling a macro, the correct syntax requires the macro name immediately followed by parentheses containing the argument values separated by commas, with no spaces between the macro name and the opening parenthesis. Additionally, argument values must not include dollar signs because dollar signs are only used as placeholders inside the macro definition itself. Option A, weekly_sales(3.99, 10), follows all these rules perfectly. It expands to index=games | eval Product_Sales = 3.99 * 10, which is a valid search that will return results. The macro expects exactly two arguments, and option A provides both as numeric literals without extra characters, spaces, or dollar signs.
Why Other Options Are Incorrect
B. weekly_sales($3.99$, $10$) wraps each argument in dollar signs. Those dollar signs become literal characters in the expanded search, so Splunk interprets $3.99$ as a field name or literal string rather than a number. This causes a syntax error because the eval command expects numeric operands for multiplication.
C. weekly_sales (3.99, 10) has a space between the macro name weekly_sales and the opening parenthesis. Splunk interprets this as a command name followed by a separate parenthetical expression, resulting in a parsing error.
D. weekly_sales(3) provides only one argument when the macro expects two. The second placeholder $AmountS01d$ has no replacement value, so the expanded search becomes index=games | eval Product_Sales = 3 *, which is incomplete and invalid.
References:
Splunk Documentation: "Define search macros" –
Definesearchmacros states that when calling a macro, do not include the dollar signs and use the format macroname(arg1, arg2) with no space before the parentheses. Splunk Search Reference confirms that macro invocation syntax requires the exact number of arguments defined in the macro.
Which field will be used to populate the field if the productName and product:d fields have
values for a given event?
| eval productINFO=coalesco(productName,productid)
A. Both field values will be used and the product INFO field will become a multivalue field for the given event.
B. The value for the productName field because it appears first
C. Neither field value will be used and the field will be assigned a NULL value for the given event.
D. The value for the field because it appears second.
Explanation:
The coalesce function in Splunk evaluates the fields listed as arguments from left to right and returns the value of the first non-null field it encounters. In the command | eval productINFO = coalesce(productName, productid), Splunk first checks productName. If productName has a value (is not null) for a given event, that value is immediately returned and assigned to productINFO. If productName is null, Splunk then checks productid and assigns its value. Since the question states that both productName and productid have values, coalesce will take the value of productName because it appears first in the argument list. This is a deterministic, left-to-right evaluation with no combination of values into a multivalue field.
Why Other Options Are Incorrect
A. coalesce does not combine multiple fields into a multivalue field. It returns only a single value from the first non-null field. Creating a multivalue field would require functions like mvappend or mvzip, not coalesce.
C. This option states neither field value will be used, but both fields have values, so coalesce will definitely return a non-null value. NULL is only returned if all arguments are null.
D. The value for productid appears second, but coalesce stops at the first non-null value, which is productName. The second argument is only evaluated if the first is null, which is not the case here.
References
Splunk Documentation: "Evaluation functions – coalesce" –
ConditionalandComparisonFunctions#coalesce states that coalesce(X, Y, ...) returns the first value that is not null, evaluating arguments left to right. Splunk Search Reference confirms that coalesce does not create multivalue fields and only returns a single value.
What does the fillnull command do in this search? index=main sourcetype=http:log | fillnull value="Unknown" src
A. Set the values of the src field to null when it is "Unknown".
B. Set all fields that are null to "Unknown".
C. Set the values of the src field to "Unknown" if it is null.
D. Set all fields with the value of "Unknown" to null.
Explanation:
C. Set the values of the src field to "Unknown" if it is null. – Correct.
The fillnull command replaces null (missing or empty) field values with a specified default value. In this search, fillnull value="Unknown" src limits the operation to only the src field. For every event where the src field contains a null value, Splunk replaces that null with the string "Unknown". Fields other than src remain unchanged, even if they contain nulls.
Why other options are incorrect
A. Set the values of the src field to null when it is "Unknown". – Incorrect.
This describes the opposite operation (replacing a literal string "Unknown" with null). fillnull never replaces existing string values; it only acts on missing (null) values.
B. Set all fields that are null to "Unknown". – Incorrect.
This would be correct only if no field list were specified. However, because src is explicitly provided after the value argument, the command affects only the src field, not all fields.
D. Set all fields with the value of "Unknown" to null. – Incorrect.
This again describes the reverse operation. Replacing "Unknown" with null would require a different command such as eval or replace. fillnull fills missing data; it does not remove existing data.
Reference
Splunk Documentation – fillnull command
"Replaces null values with a specified value."
"You can specify a list of fields to operate on. If no fields are specified, all fields are operated on."
Which of the following statements describes this search?
sourcetype=access_combined I transaction JSESSIONID | timechart avg (duration)
A. This is a valid search and will display a timechart of the average duration, of each transaction event.
B. This is a valid search and will display a stats table showing the maximum pause among transactions.
C. No results will be returned because the transaction command must include the startswith and endswith options.
D. No results will be returned because the transaction command must be the last command used in the search pipeline.
Explanation
This search uses the transaction command to group events that share a
common value for JSESSIONID into transactions1.
The transaction command assigns a
duration field to each transaction, which is the difference between the latest and earliest
timestamps of the events in the transaction1. The search then uses the timechart
command to create a time-series chart of the average duration of each transaction1.
Therefore, option A is correct because it describes the search accurately.
Option B is
incorrect because the search does not use the stats command or the pause field.
Option C
is incorrect because the transaction command does not require the startswith and endswith
options, although they can be used to specify how to identify the beginning and end of a
transaction1.
Option D is incorrect because the transaction command does not have to be
the last command in the search pipeline, although it is often used near the end of a
search1.
Which of the following statements describes POST workflow actions?
A. Configuration of a POST workflow action includes choosing a sourcetype.
B. POST workflow actions can be configured to send email to the URI location.
C. By default, POST workflow action are shown in both the event and field menus.
D. POST workflow actions can be configured to send POST arguments to the URI location
Explanation:
In Splunk, POST workflow actions are designed to send data from search results to an external system using the HTTP POST method. This allows Splunk users to integrate with external applications, APIs, or scripts by passing field values as POST arguments to a specified URI.
This is different from GET workflow actions, which append parameters to the URI query string. POST workflow actions are more secure and flexible because they can handle larger payloads and are not limited by URL length.
❌ Distractor Analysis
A. Configuration of a POST workflow action includes choosing a sourcetype → Incorrect. Workflow actions are not tied to sourcetypes; they are tied to search results and fields.
B. POST workflow actions can be configured to send email to the URI location → Incorrect. Workflow actions send data to URIs, not email addresses. Email alerts are configured separately in Splunk.
C. By default, POST workflow action are shown in both the event and field menus → Incorrect. By default, workflow actions appear in the event menu. They can be configured to appear in the field menu, but not both by default.
D. POST workflow actions can be configured to send POST arguments to the URI location → ✅ Correct. This is the defining behavior of POST workflow actions.
🔗 References
Splunk Docs – Workflow actions overview
Splunk Admin Guide – Configure workflow actions (GET vs POST)
When using the transaction command, what does the argument maxspan do?
A. Sets the maximum total time between events in a transaction.
B. Sets the maximum length of all events within a transaction.
C. Sets the maximum total time between the earliest and latest events in a transaction.
D. Sets the maximum length that any single event can reach to be included in the transaction.
📘 Explanation:
The transaction command in Splunk is used to group related events into a single transaction based on common field values (like session IDs, IP addresses, etc.). The maxspan argument defines the maximum time window allowed between the first and last event in a transaction.
If the time difference between the earliest and latest events exceeds the maxspan value, Splunk will break the transaction and start a new one. This ensures that transactions don’t grow indefinitely and remain logically bounded by time.
❌ Distractor Analysis
A. Sets the maximum total time between events in a transaction → Misleading. It’s not about the time between each event, but the span between the first and last event.
B. Sets the maximum length of all events within a transaction → Incorrect. Events don’t have “length”; transactions are defined by time span and event count.
C. Sets the maximum total time between the earliest and latest events in a transaction → ✅ Correct. This is the precise definition of maxspan.
D. Sets the maximum length that any single event can reach to be included in the transaction → Incorrect. Individual event length is irrelevant; transactions are grouped by time and field values.
🔗 References
Splunk Docs – Transaction command usage
Splunk Search Reference – Arguments for transaction
The stats command will create a _____________ by default.
A. Table
B. Report
C. Pie chart
Explanation:
The stats command in Splunk calculates aggregate statistics such as count, sum, avg, or values. When executed, Splunk displays the results in a tabular format (rows and columns) by default. Each unique combination of fields in the by clause becomes a row, and each aggregation function becomes a column. No chart is generated unless the user explicitly clicks a visualization option in the Splunk interface or uses a charting command like chart or timechart. The default output of stats is strictly a table.
Why Other Options Are Incorrect
B. Report
– A report is a saved search that can be scheduled or shared. The stats command does not automatically create a report; it simply produces a result set. A user must manually save the search as a report.
C. Pie chart
– A pie chart is a specific visualization type. The stats command produces a table, not any kind of chart. Splunk only generates charts when the search includes commands like chart or timechart, or when the user manually selects a chart type from the Visualization picker. There is no scenario where stats alone outputs a pie chart by default.
References
Splunk Documentation: "stats command" –
explicitly states that stats returns results in tabular format. Splunk Core Certified Power User Exam Blueprint (SPLK-1002) lists that stats produces a table by default, while chart and timechart are used for graphical outputs.
| Page 1 out of 26 Pages |
| 12345678 |
Real-World Scenario Mastery: Our SPLK-1002 practice exam don't just test definitions. They present you with the same complex, scenario-based problems you'll encounter on the actual exam.
Strategic Weakness Identification: Each practice session reveals exactly where you stand. Discover which domains need more attention, before Splunk Core Certified Power User Exam exam day arrives.
Confidence Through Familiarity: There's no substitute for knowing what to expect. When you've worked through our comprehensive SPLK-1002 practice exam questions pool covering all topics, the real exam feels like just another practice session.