Exactprep SPLK-1002 Questions

The where command can be used to complete the search below.

… | where failure>successes

The where command is a search command that allows you to filter events based on complex or custom criteria. The where command can use any boolean expression or function to evaluate each event and determine whether to keep it or discard it. The where command can also compare fields or perform calculations on fields using operators such as >, <, =, +, -, etc. The where command can be used after any transforming command that creates a table or a chart.

The search string below does the following:

It uses … to represent any search criteria or commands before the where command.

It uses the where command to filter events based on a comparison between two fields: failure and successes.

It uses the greater than operator (>) to compare the values of failure and successes fields for each event.

It only keeps events where failure is greater than successes.

https://docs.splunk.com/Documentation/Splunk/8.0.2/SearchReference/Eval

The eval command calculates an expression and puts the resulting value into a search results field.

If the field name that you specify does not match a field in the output, a new field is added to the search results.

If the field name that you specify matches a field name that already exists in the search results, the results of the eval expression overwrite the values in that field.

The correct command to show the total bytes for each unique combination of page and server is index=web | stats sum (bytes) BY page server. In Splunk, the stats command is used to calculate aggregate statistics over the dataset, such as count, sum, avg, etc. When using the BY clause, it groups the results by the specified fields. The correct syntax does not include commas or the word ‘AND’ between the field names. Instead, it simply lists the field names separated by spaces within the BY clause.

References:The usage of the stats command with the BY clause is confirmed by examples in the Splunk Community, where it’s explained that stats with a by foo bar will output one row for every unique combination of the by fields1.

The Splunk Common Information Model (CIM) is a collection of data models that apply a common structure and naming convention to data from any source. A data model is a type of knowledge object that defines the structure and relationships of fields in a dataset. A data model can have one or more datasets, which are subsets of the data model that represent different aspects of the data. For example, the Network Traffic data model has datasets such as All Traffic, DNS, HTTP, etc. The CIM contains 28 pre-configured data models that cover various domains such as authentication, network traffic, web, email, etc. The CIM is implemented as an add-on that contains the JSON files for the data models, documentation, and tools that support the consistent, normalized treatment of data for maximum efficiency at search time23

1: Splunk Core Certified Power User Track, page 10. 2: Splunk Documentation, Overview of the Splunk Common Information Model 1. 3: Splunkbase, Splunk Common Information Model (CIM) 2.