Wednesday, October 2, 2019

Top Splunk Interview Questions and Answers

1. Compare Splunk & Spark
CriteriaSplunkSpark
Deployment areaCollecting large amounts of machine generated dataIterative applications & in-memory processing
Nature of toolProprietaryOpen Source
Working modeStreaming mode Both streaming and batch mode
2. What is Splunk?
Splunk is Google for your machine data.It’s a software/Engine which can be used for searching, visualizing, Monitoring, reporting, etc. of your enterprise data. Splunk takes valuable machine data and turns it into powerful operational intelligence by providing real? time insight to your data through charts, alerts, reports, etc.
3. What are common port numbers used by Splunk?
Below are common port numbers used by splunk,however you can change them if required
ServicePort number Used
Splunk Web Port: 8000
 Splunk Management Port: 8089
 Splunk Indexing Port: 9997
 Splunk Index Replication Port  8080
 Splunk network port514 (Used to get data in from netwok port i.e. UDP data)
KV store8191

4. What are components of splunk/splunk architecture?

Below are components of splunk:
1)  Search head  – provides GUI for searching
2) Indexer – indexes machine data
3) Forwarder -Forwards logs to Indexer
4) Deployment server -Manges splunk components in distributed environment
5. Which is latest splunk version in use?
Splunk 6.3
6. What is splunk indexer? what are stages of splunk indexing?
The indexer is the Splunk Enterprise component that creates and manages indexes. The primary functions of an  indexer are:
  • Indexing incoming data.
  • Searching the indexed data.
  • Picture
7. What is a splunk forwarder and What are types of splunk forwarder?
There are two types of splunk forwarder as below
a) universal forwarder(UF) -Splunk agent installed on non-Splunk system to gather data locally, can’t parse or index data
b) Heavy weight forwarder(HWF) – full instance of splunk with advance functionality.
– Generally works as a remote collector, intermediate forwarder, and possible data filter because they parse data, they are not recommended for production systems
8. what are most important configuration files of splunk OR can you tell name of few important configuration files in splunk?
props.conf
indexes.conf
inputs.conf
transforms.conf
server.conf
9. What are types of splunk licenses?
Enterprise license
Free license
Forwarder license
Beta license
Licenses for search heads (for distributed search)
Licenses for cluster members (for index replication)
10. What is Splunk app?
Splunk app is a container/directory of configurations, searches, dashboards, etc. in Splunk.
11. Where does splunk default configuration is stored?
$splunkhome/etc/system/default
12. What features are not available in splunkfree ?
splunk free lacks these features:
  • authentication and scheduled searches/alerting
  • distributed search
  • forwarding in TCP/HTTP (to non-splunk)
  • deployment management
13. what happens if the license master is unreachable?
license slave will start a 24-hour timer, after which search will be blocked on the license slave (though indexing continues). users Will not be able to search data in that slave until it can reach license master again
14. what is summary index insplunk?
The Summary index is the default summary index (the index thatSplunk Enterprise uses if you do not indicate another one).
If you plan to run a variety of summary index reports you may need to create additional summary indexes.
Learn more about Splunk in this Splunk training in New York to get ahead in your career!
15. What is splunk DB connect?
Splunk DB Connect is a generic SQL database plugin for Splunk that allows you to easily integrate database information with Splunk queries and reports.

16. Can you write down a general regular expression for extracting ip address from logs?
There are multiple ways we can extract IP address from logs. Below are few examples.
Regular Expression for extracting IP address:
rex field=_raw  "(?<ip_address>\d+\.\d+\.\d+\.\d+)"
OR
rex field=_raw  "(?<ip_address>([0-9]{1,3}[\.]){3}[0-9]{1,3})"
17. What is difference between stats vs transaction command?
The transaction command is most useful in two specific cases :
  • Unique id (from one or more fields) alone is not sufficient to discriminate between two transactions. This is the case
  • when the identifier is reused, for example web sessions identified by cookie/client IP. In this case, time span or pauses are also used to segment the data into transactions.
  • In other cases when an identifier is reused, say in DHCP logs, a particular message may identify the beginning or end of a transaction.
  • When it is desirable to see the raw text of the events combined rather than analysis on the constituent fields of the events.
  • In other cases, it’s usually better to use stats as the performance is higher, especially in a distributed search environment.
  • Often there is a unique id and stats can be used.
18. How to troubleshoot splunk performance issues?
Answer to this question would be very wide but basically interviewer would be looking for following keywords in interview :
  • Check  splunkd.log for any errors
  • Check server performance issues i.e. cpu/memory usage,disk i/o etc
  • Install SOS (Splunk on splunk) app and check for warning and errors in dashboard
  • check number of saved searches currently running and their system resources consumption
  • install Firebug, which is a firefox extension. After it’s installed and enabled, log into splunk (using firefox), open firebug’s panels,
switch to the ‘Net’ panel (you will have to enable it).The Net panel will show you the HTTP requests and responses along with the time spent in each. This will give you a lot of information quickly over which requests are hanging splunk for a few seconds, and which are blameless. etc..
19. What are buckets? Explain splunk bucket lifecycle?
Splunk places  indexed data in directories, called as “buckets”. It is physically a directory containing events of a certain period.
A bucket moves through several stages as it ages :
  • Hot – Contains newly indexed data. Open for writing. One or more hot buckets for each index.
  • Warm – Data rolled from hot. There are many warm buckets.
  • Cold – Data rolled from warm. There are many cold buckets.
  • Frozen – Data rolled from cold. The indexer deletes frozen data by default, but you can also archive it. Archived data can later be thawed (Data in  frozenbuckets is not searchable)
By default, your buckets are located in:
$SPLUNK_HOME/var/lib/splunk/defaultdb/db
You should see the hot-db there, and any warm buckets you have. By default, Splunk sets the bucket size to 10GB for 64bit systems and 750MB on 32bit systems.
20. What is the different between stats and eventstats commands?
Stats command generate summary statistics of all existing fields in your search results and save them as values in new fields.
Eventstats is similar to the stats command, except that aggregation results are added inline to each event and only if the
aggregation is pertinent to that event.
eventstats computes the requested statistics like stats, but aggregates them to the original raw data.
21. Who are the biggest direct competitors to Splunk?
logstash, Loggly, Loglogic,sumo logic etc..
22. splunk licenses specify what?
how much data you can index per calendar day
23. how does splunk determine 1 day, from a licensing perspective?
midnight to midnight on the clock of the license master
24. how are forwarder licenses purchased ?
They are included with splunk, no need to purchase separately
Interested in learning Splunk? Click here to learn more in this Splunk Training in Tornoto!
25. What is command for restarting just the splunk webserver?
splunk start splunkweb
26. What is command for restarting just the splunk daemon?
splunk start splunkd
27. What is command to check for running splunk processes on unix/Linux ?
ps aux | grep splunk
28. What is Command to enable splunk to boot start?
$SPLUNK_HOME/bin/splunk enable boot-start
29. How to disable Splunk boot start?
$SPLUNK_HOME/bin/splunk disable boot-start

30. What is sourcetype in Splunk?
Sourcetype is Splunk way of identifying data.
31. How to reset Splunk admin password?
It depends on the version of Splunk. If you are using Splunk  7.1 and above just refer to the following steps:
  • First, you will have to stop your Splunk Enterprise
  • Now you will have to find the passwd file and rename it to passwd.bk
  • Then create a file named user-seed.conf in your
  • $SPLUNK_HOME/etc/system/local/
    directory and in this file add the following command:
    [user_info]
    
    PASSWORD = NEW_PASSWORD
    In the place of “NEW_PASSWORD”, just add your own new password
  • After that just start the Splunk Enterprise and use the new password to log in
In case you have created other users earlier and know their login details, copy and paste their credentials from the passwd.bk file into the passwd file and restart Splunk.
Now, if you are using the versions prior to 7.1, follow the below steps:
  • First, stop the Splunk Enterprise
  • Find the passwd file and rename it to passw.bk
  • Start Splunk Enterprise and log in using the default credentials of admin/changeme
  • Then, you will be asked to enter a new password for your admin account
In case you have created other users earlier and know their login details, copy and paste their credentials from the passw.bk file into the passwd file and restart Splunk.
32. How to disable splunk launch message?
Set value OFFENSIVE=Less in splunk_launch.conf

33. How to clear splunk search history?
Delete the following file on Splunk server:
$splunk_home/var/log/splunk/searches.log
34. What is btool or how will you troubleshoot splunk configuration files?
splunk btool is a command line tool that helps us to  troubleshoot configuration file issues or just see what values are being used by your Splunk Enterprise installation in existing environment
35. What is difference between splunk app and splunk add on?
Basiclly both contains preconfigured configuration and reports etc but splunk add on do not have visual app. Splunk apps have preconfigured visual app
36. What is .conf files precedence in splunk?
File precedence is as follows :
System local directory — highest priority
App local directories
App default directories
System default directory — lowest priority
37. what is fishbucket or what is fishbucket index?
Its a directory or index at default location:
/opt/splunk/var/lib/splunk
It contains seek pointers and CRCs for the files you are indexing, so splunkd can tell if it has read them already. We can access it through GUI by seraching for
index=_thefishbucket

38. How do i exclude some events from being indexed by Splunk?
This can be done by defining a regex to match the necessary event(s) and send everything else to nullqueue. Here is a basic example that will drop everything except events that contain the string login In props.conf:
<code>[source::/var/log/foo]

# Transforms must be applied in this order

# to make sure events are dropped on the

# floor prior to making their way to the

# index processor

TRANSFORMS-set= setnull,setparsing

</code>
In transforms.conf:
[setnull] REGEX = . DEST_KEY = queue FORMAT = nullQueue

[setparsing]

REGEX = login

DEST_KEY = queue

FORMAT = indexQueue
39. How can i tell when splunk is finished indexing a log file?
By watching  data from splunk’s metrics log in real time.
index="_internal" source="*metrics.log" group="per_sourcetype_thruput" series="&lt;your_sourcetype_here&gt;" |

eval MB=kb/1024 | chart sum(MB)
or to watch everything happening split by sourcetype:
index="_internal" source="*metrics.log" group="per_sourcetype_thruput" | eval MB=kb/1024 | chart sum(MB) avg(eps) over series
And if you’re having trouble with a data input and you want a way to troubleshoot it, particularly if your whitelist/blacklist rules arent working the way you expect, go to this URL:
https://yoursplunkhost:8089/services/admin/inputstatus
These are described in more detail on Splunk Community!

40. How to set the default search time in Splunk 6?
To do this in Splunk Enterprise 6.0, use ui-prefs.conf. If you set the value in $SPLUNK_HOME/etc/system/local, all your users should see it as the default setting. For example, if your $SPLUNK_HOME/etc/system/local/ui-prefs.conf file includes:
  1. [search]
  1. dispatch.earliest_time = @d
  1. dispatch.latest_time = now
The default time range that all users will see in the search app will be today.
The configuration file reference for ui-prefs.conf is here:
http://docs.splunk.com/Documentation/Splunk/latest/Admin/Ui-prefsconf
41. What is dispatch directory?
$SPLUNK_HOME/var/run/splunk/dispatch contains a directory for each search that is running or has completed. For example, a directory named 1434308943.358 will contain a CSV file of its search results, a search.log with details about the search execution, and other stuff. Using the defaults (which you can override in limits.conf), these directories will be deleted 10 minutes after the search completes—unless the user saves the search results, in which case the results will be deleted after 7 days.
42. What is difference between search head pooling and search head clusttering?
Both are features provided splunk for high availability of splunk search head in case any one search head goes down. Search head cluster is newly introduced and search head pooling will be removed in next upcoming versions.Search head cluster is managed by captain and captain controls its slaves.Search head cluster is more reliable and efficient than search head pooling.
43. If I want add/onboard folder access logs from a windows machine to splunk how can I add same?
Below are steps to add folder access logs to splunk
  1. Enable Object Access Audit through group policy on windows machine on which folder is located
  2. Enable auditing on specific folder for which you want to monitor logs
  3. Install splunk universal forwarder on windows machine
  4. Configure universal forwarder to send security logs to splunk indexer
44. How would you handle/troubleshoot splunk license violation warning error?
License violation warning  meanssplunk has indexed more data than  our purchased license  quota.We have to identify which index/sourcetype has received more data recently than usual daily data volume.We can check on splunk license master pool wise available quota and identify the pool for which violation is occurring.Once we know the pool for which we are receiving more data then we have to identify top sourcetype for which we are receiving more data than usual data.Oncesourcetype is identified then we have to find out source machine which is sending huge number of logs and root cause for the same and troubleshoot accordingly.
45. What is mapreduce algorithm?
MapReduce algorithm is secret behind splunk fast data searching speed.It’s an algorithm typically used for batch based large scale parallelization.It’s inspired by functional programming’s map() and reduce () functions.
46. How splunk avoids duplicate indexing of logs ?
At indexer, Splunk keeps track of indexed events in a directory called fish buckets with the default location:
/opt/splunk/var/lib/splunk
It contains seek pointers and CRCs for the files you are indexing, so splunkd can tell if it has read them already.
See more at:
http://www.learnsplunk.com/splunk-indexer-configuration.html#sthash.t1ixi19P.dpuf.
47. What is difference between splunk SDK and splunk framework?
Splunk SDKs are designed to allow you to develop applications from the ground up and not require Splunk Web or any components from the Splunk App Framework. These are separately licensed to you from the Splunk Software and do not alter the Splunk Software. Splunk App Framework resides within Splunk’s web server and permits you to customize the Splunk Web UI that comes with the product and develop Splunk apps using the Splunk web server. It is an important part of the features and functionalities of Splunk Software, which does not license users to modify anything in the Splunk Software.
48. For what purpose inputlookup and outputlook are used in Splunk search?
The inputlookup command is used to search the contents of a lookup table. The lookup table can be a CSV lookup or a KV store lookup. The inputlookup command is considered to be an event-generating command. An event-generating command generates events or reports from one or more indexes without transforming them. There are many commands that are under the event-generating command like metadata, loadjob, inputcsv, and many more. The inputlookup command is one of them.
Syntax:
inputlookup [append=<bool>] [start=<int>] [max=<int>] [<filename> | <tablename>] [WHERE <search-query>]
Now coming to the outputlookup, it writes the search results to a static lookup table, or KV store collection, that you specify. The outputlookup command is not being used with external lookups.
Syntax:
outputlookup [append=<bool>] [create_empty=<bool>] [max=<int>] [key_field=<field_name>] [createinapp=<bool>] [override_if_empty=<bool>] (<filename> | <tablename>)
Splunk Data Science

No comments:

Post a Comment

Get max value for identity column without a table scan

  You can use   IDENT_CURRENT   to look up the last identity value to be inserted, e.g. IDENT_CURRENT( 'MyTable' ) However, be caut...