Splunk Updated SPLK-1002 Exam Questions and Answers by indigo

The fields sidebar is a panel that shows the fields that are present in your search results2. The fields sidebar has two sections: selected fields and interesting fields2. Selected fields are fields that you choose to display in your search results by clicking on them in the fields sidebar or by using the fields command2. Interesting fields are fields that appear in at least 20 percent of events or have high variability among values2. For each field in the fields sidebar, you can select one of the following options: events with this field, rare values, top values by time or top values2. If you select rare values, Splunk will automatically pipe your search results to the rare command, which shows the least common values of a field2. Therefore, option B is correct, while options A, C and D are incorrect because they do not pipe your search results to the rare command.

In this case, the outer join is applied, which means that all rows from the outer (left) table will be included, even if there are no matching rows in the inner (right) table. The result will include all five rows from the outer table, with the matched data from the inner table where employeeNumber matches. Rows without matching employeeNumber values will have null values for the fields from the inner table.

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.