Splunk Power User 1002 Flashcards
Search Terms are not Case Sensitive? T or F
True
Command names are not Case Sensitive? T or F
True
Clauses and Functions are not case sensitive? T or F
True
If a command references a specific value, that value (Is / Is Not) case sensitive?
IS
What values from lookup tables ARE case-sensitive by default?
Field. Users with Admin Roles can set field values to not be case sensitive.
Booleans ARE Case Sensitive. T or F
True
Tag Values ARE case sensitive. T or F
True
Buckets have directories containing sets of:
Raw Data and indexing data
Buckets have configurable what set by admin users?
max size & max time span
What are the 3 searchable buckets in Splunk?
Hot, Warm, and Cold
When are “Hot” buckets rolled into “warm” buckets?
when it reaches max size, max time span, or indexer is restarted
When Splunk search is run, Splunk uses what on bucket directories to determine if it needs to open the bucket, uncompress raw data, and search content inside?
Timestamps
Wildcards are tested after all other search terms. T or F
True
Only ____ wildcards make efficient use of index
trailing
What happens when there is a wildcard at the beginning of a string?
Splunk searches all events in that time frame.
Wildcards ______ of string can cause inconsistent results
in the middle
Should you use wildcards to match punctuation?
No
What are the 3 search modes in Splunk?
Fast, Smart, and Verbose
As events are stored by time, what is the most efficient filter?
Time
After time, the default fields for _______ are most powerful.
index, source, host, and sourcetype.
o These fields are extracted at index time and do not need to be extracted for each search
o Use these fields to filter as early as possible in a search so processing is done on a minimum amount of data
Use _____ command to extract only the fields you will need for your search
“fields”
When should you apply filtering commands?
As early as possible
Helps determine which phase of a search is taking up the most time
Search Job Inspector
Search Job Inspector dissects the behavior of searches to help understand execution costs of ____ within a search.
knowledge objects, search commands, & other components
Any search job that has not expired can be inspected. T or F
True
Open job inspector by:
running a search, clicking “Job” dropdown menu, and then “Inspect Job”
The _______ component displays the time Splunk took when searching the index for the location of the raw data files
“Command Search Index”
The ______ component displays time Splunk took to filter out events that did not match
“Command Search Filter”
The ______ component is the time it took to read the events from the raw data files
“Command Search Raw Data”
Where do you find the “Search Job Properties” tab?
Under “Execution Costs”
Any search that returns ______ can be viewed as a chart
statistical values
Most visualizations require results structured as tables with at least __ columns
2
Looking at Statistics tab, if you see 2 columns, what values do the first column represent and what do the second column values represent?
First column = x-axis values
Second Column = y-axis values
Any stats function can be applied to the chart command. T or F
True
y-axis should always be numeric so that it can be charted. T or F
True
can remove NULL values by adding argument ______ to chart command
“usenull=f”
can remove OTHER column by adding argument ______
“usenull=f”
What do you use to show all of the plotted series?
limit=0
Performs stats aggregations against time
Timechart Command
_____ is always the x axis
Time
Timechart Command can split data with a ______ clause
“by”
Any stats function can be applied to timechart command. T or F
True
Only one value can be specified after the “by” modifier. T or F
True
Timechart command intelligently clusters data in time intervals dependent on ______.
time range selected
To change the span of the time of the cluster, you can use the ______ argument.
“span”
What command compares data over specific time periods?
Timewrap
To use timewrap command, we specify a period of time from the results of the:
timechart command
In a Line Graph, you can zoom in by clicking and dragging over a time period? T or F
True
Chart Overlay will allow you to lay a line chart of one series of data over another visualization. T or F
True
Area chart gives ability to show the data stacked. T or F
True
Can zoom into sections of the graph by clicking and dragging
Column chart
Uses horizontal bars to show comparisons, and can be stacked
Bar Graph
Takes the data and visualizes the percentage for each slice and can drill down to the events for a slice by clicking on the slice
Pie Chart
Shows the relationship between two discrete data values plotted on an x- and y-axis and is useful for values that do not occur at regular intervals or belong to a series
Scatter Chart
Provides a visual way to view a third dimension of data.
Each chart plots against 2-dimensions on the x and y axes and the size represents the value for the 3rd dimension. 3rd field in the table command will determine the size of the bubbles in our chart.
Bubble Chart
Trellis layout link allows us to split our visualizations by a selected field or aggregation. It has multiple visualizations, but originating search is only run ONCE. T or F
True
Can Transforming commands be used with visualizations?
yes
Top/rare – counts the frequency of fields. T or F
True
Calculates statistics between two or more fields when you do not need the data to be time-based
Stats
Calculates statistics with an arbitrary field as your x-axis that is not time
Chart
Calculates statistics with time as the x-axis
Timechart
Plots geographic coordinates as interactive markers on a world map
Marker Maps
Uses shading to show relative metrics for predefined geographic regions
Choropleth
Lookup and add location information to events. Data such as city, country, region, latitude, and longitude can be added to events that include external IP addresses
iplocation
Aggregates geographical data for use on a map visualization and uses the same functions as the stats command
Geostats Command
The Geostats command only accepts ___ “by” argument or arguments
1
To control column count, what argument can be used?
“globallimit”
Geostats can be used with iplocation. T or F
True
View data as a geographical location, uses shading to show relative metrics over predefined locations of a map
Choropleth Maps
To use choropleth you will need a ______ file that defines region boundaries
KMZ (Keyhold Markup Language) (.kml)
Used to prepare our events for use in a choropleth and
adds a field that includes geographical data structures that match polygons on our map
Geom Command
geom featureIdField=, or
sourcetype=crime_data cc=USA | lookup geo_us_states latitude, longitude | stats count by featureId | geom
2 different types of visualizations you can use to display
Single Value, Gauges
What computes moving averages of field values?
Trendline command
What 3 arguments are required in a Trendline command?
trendtype, time period, field
What options does the Field Format give you?
o Wrap results
o Show row numbers
o Change click selection from cell to row
o Add a data overlay – can be a heat map of values or highlight the high and low values in the table
Computes the sum of all numeric fields for each event/row and create a total column
Addtotals Command
Used to calculate and manipulate field values
Eval Command
Arithmetic, concatenation, and Booleans are supported by the Eval command. T or F
True
In the Eval Command, newly created field values are case-sensitive. T or F
True
Converts numerical values to strings so that they can be joined with other strings
Tostring Function. After using tostring, fields may not sort numerically because the field values are now ASCII values
Can be used if you want to format values without changing characteristics of underlying values
Fieldformat
Allows you to evaluate arguments and create values depending on the results
Eval command IF Function.
• takes 3 arguments [ “if(x, y, z)” ]
o x – a Boolean expression
o y – used if Boolean expression evaluates to true
o z – used if Boolean expression evaluates to false
o y & z must be in double quotes if not numerical
Can be used to filter results at any time in the search and allows you to use search terms further down the pipeline
Search Command
A Search command cannot compare values from 2 different fields. T or F
True
Filters events to only keep the results that evaluate as true
Where Command
Asterisks cannot be used as a wildcard inside eval or where commands. T or F
True
What replaces any null values in your events
Fillnull Command