Splunk Fundamentals 2 Flashcards
True or False. Tags, field values with “eval” and “where,” and “field values from lookup” are case insensitive.
False. They are case sensitive.
True or False. Field names, regular expressions and Boolean operators are case sensitive.
True
As events come into Splunk, they are placed into an index’s ____ ___ (which is the only writable bucket).
hot bucket
Which command returns tables containing only specified fields in a result set?
table
Which command renames a field in results?
rename
Which command includes or excludes specified fields?
fields
Which command sorts results by specified field?
sort
Which command adds field values from an external source (e.g., csv files)?
lookup
Are Boolean operators case sensitive?
yes
Are field names case sensitive?
yes
Using a ____ ____ in Splunk is a way to search through text to find pattern matches in your data.
Are they case sensitive?
regular expression
yes
True or False. Field values from lookup, tags, and field values with “eval” and “where” commands are not case sensitive.
False. They are case sensitive.
Are command names (i.e. stats, STATS), command clauses (i.e. “as,” “by,” “with), statistical functions (i.e. avg, AVG, Avg), search terms (i.e. failed, FAILED) and field values (i.e. host=www1, host=WWW1) case sensitive or case insensitive?
case insensitive
As events age in Splunk, they move from the ____ bucket, to the ____ bucket and finally to the ____ bucket.
hot, warm, cold
Who can configure settings and add more to buckets? Users, admins or power users?
admins
What is the most efficient filter to use when searching events? After time, the most powerful fields to filter are what?
time
index, host, source and sourcetype
What command would you use in order to only extract (discover) the fields you need?
fields command
____ mode in Splunk = performance over completeness.
____ mode in Splunk balances speed and completeness.
____ mode in Splunk focuses on completeness over performance
fast
smart
verbose
Removing duplicates then sorting is ____ (faster or slower) than sorting then removing duplicates?
faster
____ commands massage raw data in tables and transform specified cell values for each event into numerical values that you can use for statistical purposes.
transforming
What commands are required to ‘transform’ search results into visualizations?
transforming
What type of commands are the following?
top rare chart timechart stats geostats
transforming
In fast mode, verbose mode, and smart mode what is not available for non-transforming searches?
statistics and visualizations
Only metadata fields (host, source and sourcetype) and fields specified in a search are available in ___ mode.
fast
In fast mode transforming searches, ____ and ___ are not available. However, statistics and visualizations are.
events, patterns
In ___ mode, events and patterns are available in non-transforming searches, but statistics and visualizations are not.
Are events, patterns, statistics and visualizations available for transforming searches?
verbose
yes
In smart mode, events and patterns are NOT available. However ____ and ____ are.
statistics and visualizations
What tool allows you to examine the:
Overall stats of search (e.g., records processed and returned, processing time)
How search was processed
Where Splunk spent its time
Search Job Inspector tool
What is used to troubleshoot a search’s performance and understand the impact of knowledge objects on processing (e.g., event types, tags, lookups)?
Search Job Inspector tool
Header, execution costs and search job properties are the 3 ____ of what tool?
components
Search Job Inspector tool
Which component of the Search Job Inspector tool provides basic information, including time to run and # of events scanned?
header
Which component of the Search Job Inspector tool provides details on the cost to retrieve results?
execution costs
command.search.index, command.search.filter, and command.search.rawdata are all ____ ___ shown in the Search Job Inspector tool.
execution costs
Which execution cost of the Search Job Inspector tool specifies the time that it took to filter out events that did not match?
a. command.search.rawdata
b. command.search.index
c. command.search.filter
c. command.search.filter
Which execution cost of the Search Job Inspector tool specifies the time that it took to search the index for the location to read in rawdata files?
a. command.search.rawdata
b. command.search.index
c. command.search.filter
b. command.search.index
Which execution cost of the Search Job Inspector tool specifies the time that it took to read events from the rawdata files?
a. command.search.rawdata
b. command.search.index
c. command.search.filter
a. command.search.rawdata
As events are stored by time, ______ is the most efficient filter.
a. _time
b. _raw
c. _introspection
a. _time
Select all that are considered case sensitive.
a. Boolean operators
b. tags
c. keywords
d. command functions
a. Boolean operators
b. tags
The Search Job Inspector has three components. Select all that apply.
a. Header
b. Health check
c. Search job properties
d. Execution costs
a. Header
c. Search job properties
d. Execution costs
For general search best practices, only use
________ wildcards to make efficient use of index.
a. trailing
b. beginning
c. middle-of-string
a. trailing
When a search returns statistical values, results can be viewed in a table on the ___ tab or as a ____.
statistics
visualization
Lines, column charts, pie charts, single values, gauges, maps and many more are all examples of what?
visualizations
A ___ ____ is a sequence of related data points that are plotted in a visualization. They can generate various statistical or visualization results.
data series
Most visualizations require a ____ ___ table. A ___ ___ table consists of search results structured as a table with at least two columns.
single series
The leftmost column of a single series table provides x-axis values or y-axis values? What axis are subsequent columns on?
x-axis values
the y-axis
To get ___ ____ tables, you need to set up the underlying search with transforming commands such as “chart” and “timechart.”
multi-series tables
___ ___ tables display statistical trends over time. They can be single-series or multi-series.
time series
What command do you have to use for a time series result?
timechart command
What type of chart shows trends in the relationships between discrete data values?
scatter charts
____ charts show discrete values that do not occur at regular intervals or belong to a series.
scatter
The ____ command can display any data series plotted across one or two dimensions.
chart
What chart command function is being used in the following search strings? (Note: The difference between the two are the “over” clause and the “by” clause in the second lines).
index=security sourcetype=linux_secure
| chart count over vendor_action
index=security sourcetype=linux_secure
| chart count by vendor_action
count function
When you use the ___ function in Splunk, a table is created with a column that tallies the number of events for each value in the result set.
count
With the ____ command, you can use the “by” clause with the “over” clause to split results (ie. over vendor_action by user).
Or you can just use two “by” clauses (i.e. by vendor_action, user).
chart
You can only split chart results over a maximum
of how many dimensions using the chart command?
two
Chart and timechart commands automatically filter results to include the ____ highest values. Surplus values are grouped in “OTHER.” Results can be skewed by “NULL” and “OTHER.”
a. five
b. ten
c. twenty
d. fifteen
b. ten
What chart and timechart command values are shown by default?
NULL and OTHER
“useother=f” and “usenull=f” can be used to remove empty ____ and ____ values from display in a visualization using the chart command.
NULL and OTHER
What can be used to adjust the default number of plotted series (10) when using the chart command?
limit argument
The ____ command performs statistical aggregations against time. It also plots and trends data over time.
timechart command
“_time” using the timechart command is always on the x-axis or y-axis?
x-axis
Line or area charts are the best representation of what type of chart?
timecharts
With the timechart command,the default time intervals (or time ranges of a search) that can be used are span=1m which equals _____ minutes and span=30m which equals ____ hours.
60 minutes
24 hours
You can adjust the time interval of a timechart by using what argument?
“span” argument
The ____ layout allows you to display multiple charts based on one result set and allows visual comparison between different categories.
trellis layout
Which command displays the output of the timechart command, so that each time period is a separate series?
a. timechart command
b. chart command
c. timewrap command
c. timewrap command
Which command can compare data over a specific time period, such as day-over-day or month-over-month?
a. timechart command
b. timewrap command
c. chart command
b. timewrap command
What command is being used here?
index=security sourcetype=linux_secure
| stats count by src_ip, user, vendor_action, app
stats command
What clause would you use to calculate statistics for two or more non time-based fields?
“by” clause
To get multi-series tables, you need to set up the underlying search with transforming commands. Select all that apply.
a. chart
b. abstract
c. timechart
a. chart
c. timechart
When using the timechart command, what option is used to specify the _time interval?
a. group
b. trend
c. span
c. span
Which of the three transforming commands below allows you to split results over a maximum of TWO dimensions?
a. stats
b. chart
c. timechart
b. chart
Which of the three transforming commands below allows you to split results over a maximum of ONE dimension?
a. stats
b. chart
c. timechart
c. timechart
Which of the three transforming commands below allows you to split results over MANY dimensions?
a. stats
b. chart
c. timechart
a. stats
Which of the three transforming commands below does not allow you to limit the number of series shown, filter “other” and “null” series, and set value groups along the x-axis?
a. stats
b. chart
c. timechart
a. stats
Which transforming commands allow you to use “span” in order to set value groups along the x-axis?
a. stats
b. chart
c. timechart
b. chart
c. timechart
Which commands would you use to count the frequency of a field(s)?
a. stats
b. chart
c. top/rare
d. timechart
c. top/rare
Which command is non time-based and would be used to calculate statistics for two or more “by” fields?
a. stats
b. chart
c. top/rare
d. timechart
a. stats
Which command is used to calculate statistics using an arbitrary field as the x-axis? This command also allows you to use “over” or “by” to specify the x-axis, and WILL NOT allow you to use “_time” on the x-axis.
a. stats
b. chart
c. top/rare
d. timechart
b. chart
You would use the ____ command to calculate
statistics with “_time” as the x-axis.
a. stats
b. chart
c. top/rare
d. timechart
d. timechart
If a “by” field is used for the timechart command, the output is a ____.
table
To get multi-series tables, you need to set up the underlying search with transforming commands. Select all that apply.
a. chart
b. abstract
c. timechart
a. chart
c. timechart
When using the timechart command, what option is used to specify the _time interval?
a. group
b. trend
c. span
c. span
____ are aliases to field values. For example, if two host names refer to the same computer, you could give both host values the same ___ (for example, hal9000). When you search for ___=hal9000, Splunk returns events involving both host name values.
Note: Answers for all blanks are the same
tags
top, stats, chart, and timechart are all what type of commands?
a. Sorting Results
b. Filtering Results
c. Grouping Results
d. Reporting Results
e. Filtering, Modifying, and Adding Fields
d. Reporting Results
Which transforming command returns the most frequently occurring typle of field values, along with their count and percent?
a. stats
b. chart
c. top
d. rare
e. timechart
c. top
This command computes the moving averages of a field.
trendline
There are 3 ____ that must be included when using the trendline command. ____ (acronym for simple moving average), _____ (acronym for exponential moving average), and ____ (acronym for weighted moving average).
trendtypes
sma
ema
wma
The ___ over which to compute a trend (which can be between whole numbers of 2 and 10,000) must be included when using the trend line command.
period
When displaying data on maps, there are two types that can be used:
A ____ map (which shades areas based on metrics).
A ____ map (which displays statistical grouping based on geo location).
Choropleth
Cluster
Which command is used to look up and add location information to an event (including city, country, region, latitude and longitude)?
a. geostats
b. iplocation
c. stats
d. chart
e. timechart
b. iplocation
True or False. The iplocation command DOES NOT automatically define default lat and lon fields required by geostats.
False
The iplocation command AUTOMATICALLY defines default lat and lon fields required by geostats.
The ____ command is used to compute statistical functions and render a cluster map. Data must include latitude and longitude values.
a. chart
b. iplocation
c. stats
d. geostats
e. timechart
d. geostats
When using the geostats command, you can control the column count, using the ______ argument.
globallimit
____ maps use shading to show relative metrics, such as sales, network intruders, etc. for predefined geographic regions.
Choropleth
To define regional boundaries for a choropleth map, you must have what type of files? Select all that apply.
a. CSV
b. KML (Keyhole Markup Language)
c. JSON
d. KMZ (compressed Keyhole Markup Language)
e. XML
b. KML (Keyhole Markup Language)
d. KMZ (compressed Keyhole Markup Language)
The standard geo searches that Splunk ships with for the choropleth maps is:
- geo_us_states (which for what country?)
- geo_countries (which is for ____)
and
…| geom [featureCollection] [featureIdField=string]
(Note: No answer needed for this one)
United States
countries of the world
With gauge visualizations, you can make adjustments to color by using UI or the ____ command.
gauge
____ layout displays multiple gauges when using a by clause in the stats command.
trellis
With the timechart command, you can add a _____ and a trend. A ____ is an inline chart and is designed to display time-based trends associated with the primary key.
(Note: Same answer for both)
sparkline
The ____ command is used to compute the sum of all or selected columns, and place the total in the last row and last column.
a. top
b. stats
c. chart
d. addtotals
e. timechart
f. iplocation
g. geostats
d. addtotals
When using the add totals command, ___=t counts the fields in each row under a column named, while ____=t counts the fields in each row in a row named.
row=t
column=t
The trendline command provides three trend types. Select all that apply.
a. tma (time)
b. sma (simple)
c. ema (exponential)
d. wma (weighted)
b. sma (simple)
c. ema (exponential)
d. wma (weighted)
By default, the iplocation command adds fields to the results. Select all that apply.
a. City
b. lon
c. pid
d. Region
b. lon