Month End Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > Splunk > Splunk Core Certified Power User > SPLK-1002

SPLK-1002 Splunk Core Certified Power User Exam Question and Answers

Question # 4

A user wants a table that will show the total revenue made for each product in each sales region. Which would be the correct SPL query to use?

A.

index=X sourcetype=Y | chart sum(product) by price AND region

B.

index=X | chart sum(price) by product, region

C.

index=X | chart total(product) over price by region

D.

index=X | chart total(price) by product, region

Full Access
Question # 5

What commands can be used to group events from one or more data sources?

A.

eval, coalesce

B.

transaction, stats

C.

stats, format

D.

top, rare

Full Access
Question # 6

Which of the following searches would return a report of sales by product-name?

A.

chart sales by product_name

B.

chart sum(price) as sales by product_name

C.

stats sum(price) as sales over product_name

D.

timechart list(sales), values(product_name)

Full Access
Question # 7

When using the transaction command, how are evicted transactions identified?

A.

Closed_txn field is set to o, or false.

B.

Max_txn field is set to O, or false.

C.

Txn_field is set to 1, or true.

D.

open_txn field is set to 1, or true.

Full Access
Question # 8

What is a limitation of searches generated by workflow actions?

A.

Searches generated by workflow action cannot use macros.

B.

Searches generated by workflow actions must be less than 256 characters long.

C.

Searches generated by workflow action must run in the same app as the workflow action.

D.

Searches generated by workflow action run with the same permissions as the user running them.

Full Access
Question # 9

This function of the stats command allows you to return the sample standard deviation of a field.

A.

stdev

B.

dev

C.

count deviation

D.

by standarddev

Full Access
Question # 10

__________ datasets can be added to root dataset to narrow down the search

A.

parent

B.

extracted

C.

event

D.

child

Full Access
Question # 11

What is the correct format for naming a macro with multiple arguments?

A.

monthly_sales(argument 1, argument 2, argument 3)

B.

monthly_sales(3)

C.

monthly_sales[3]

D.

monthly_sales[argument 1, argument 2, argument 3)

Full Access
Question # 12

Tags can reference which of the following knowledge objects?

A.

Lookups and event types only.

B.

Extracted fields, field aliases, calculated fields, lookups, and event types.

C.

Tags cannot reference any of these knowledge objects because tags are the last knowledge objects generated in the search-time operation sequence.

D.

Extracted fields, calculated fields, and field aliases only.

Full Access
Question # 13

The macro weekly_sales (2) contains the search string:

index—games I eval Product Sales = $price$ $AmountS01d$

Which of the following will return results?

A.

‘weekly_sales(3.99, 10) '

B.

‘weekly_sales($3.99$, $10$)

C.

'weekly_sales (3.99, 10)

D.

‘weekly_sales(3)

Full Access
Question # 14

When using multiple expressions in a single eval command, which delimiter is used?

A.

, (comma)

B.

I (pipe)

C.

/ (forward slash)

D.

: (colon)

Full Access
Question # 15

When creating a data model, which root dataset requires at least one constraint?

A.

Root transaction dataset

B.

Root event dataset

C.

Root child dataset

D.

Root search dataset

Full Access
Question # 16

What are search macros?

A.

Lookup definitions in lookup tables.

B.

Reusable pieces of search processing language.

C.

A method to normalize fields.

D.

Categories of search results.

Full Access
Question # 17

When using a field value variable with a Workflow Action, which punctuation mark will escape the data

A.

*

B.

!

C.

^

D.

#

Full Access
Question # 18

When should the delimiter method be used in the Field Extractor?

A.

When the events do not have the correct permissions set.

B.

When the events are separated by a consistent character or set of characters.

C.

When the events need a regular expression to define the matching pattern.

D.

When the events need to be calculated using special characters.

Full Access
Question # 19

Which of the following statements describes field aliases?

A.

Field alias names replace the original field name.

B.

Field aliases can be used in lookup file definitions.

C.

Field aliases only normalize data across sources and sourcetypes.

D.

Field alias names are not case sensitive when used as part of a search.

Full Access
Question # 20

When multiple event types with different color values are assigned to the same event, what determines the color displayed for the events?

A.

Rank

B.

Weight

C.

Priority

D.

Precedence

Full Access
Question # 21

The time range specified for a historical search defines the ____________ .------questionable on ans

A.

Amount of data shown on the timeline as data streams in

B.

Amount of data fetched from index matching that time range

C.

Time range for the static results

Full Access
Question # 22

How could the following syntax for the chart command be rewritten to remove the OTHER category? (select all that apply)

A.

| chart count over CurrentStanding by Action useother=f

B.

| chart count over CurrentStanding by Action usenull-f useother-t

C.

| chart count over CurrentStanding by Action limit=10 useother=f

D.

| chart count over CurrentStanding by Action limit-10

Full Access
Question # 23

Which search string would only return results for an event type called success ful_purchases?

A.

tag=success ful_purchases

B.

Event Type:: successful purchases

C.

successful_purchases

D.

event type—success ful_purchases

Full Access
Question # 24

Which of the following searches will return all clientip addresses that start with 108?

A.

… | where like (clientip, “108.% )

B.

… | where (clientip, "108. %")

C.

… | where (clientip=108. % )

D.

… | search clientip=108

Full Access
Question # 25

A user wants to convert numeric field values to strings and also to sort on those values.

Which command should be used first, the eval or the sort?

A.

It doesn't matter whether eval or sort is used first.

B.

Convert the numeric to a string with eval first, then sort.

C.

Use sort first, then convert the numeric to a string with eval.

D.

You cannot use the sort command and the eval command on the same field.

Full Access
Question # 26

When a search returns __________, you can view the results as a list.

A.

a list of events

B.

transactions

C.

statistical values

Full Access
Question # 27

When using the Field Extractor (FX), which of the following delimiters will work? (select all that apply)

A.

Tabs

B.

Pipes

C.

Colons

D.

Spaces

Full Access
Question # 28

Which of the following file formats can be extracted using a delimiter field extraction?

A.

CSV

B.

PDF

C.

XML

D.

JSON

Full Access
Question # 29

Which of the following is true about the Splunk Common Information Model (CIM)?

A.

The data models included in the CIM are configured with data model acceleration turned off.

B.

The CIM contains 28 pre-configured datasets.

C.

The CIM is an app that needs to run on the indexer.

D.

The data models included in the CIM are configured with data model acceleration turned on.

Full Access
Question # 30

Which of the following statements describes the use of the Filed Extractor (FX)?

A.

The Field Extractor automatically extracts all field at search time.

B.

The Field Extractor uses PERL to extract field from the raw events.

C.

Field extracted using the Extracted persist as knowledge objects.

D.

Fields extracted using the Field Extractor do not persist and must be defined for each search.

Full Access
Question # 31

Which of these is NOT a field that is automatically created with the transaction command?

A.

maxcount

B.

duration

C.

eventcount

Full Access
Question # 32

Given the event below, how can the value in the Zip_Code field be used to retrieve the local weather from an external resource?

25/Oct/2023:20:29:43 , 151.131.173.143 , V2.003 , Zip_Code: 75890 , DataCenter: DC1

A.

Create a POST workflow action.

B.

Create a GET workflow action.

C.

Create a PUT workflow action.

D.

Create a Search workflow action.

Full Access
Question # 33

Which of the following eval commands will provide a new value for host from src if it exists?

A.

| eval host = if (isnu11 (src), src, host)

B.

| eval host = if (NOT src = host, src, host)

C.

| eval host = if (src = host, src, host)

D.

| eval host = if (isnotnull (src), src, host)

Full Access
Question # 34

The Field Extractor (FX) is used to extract a custom field. A report can be created using this custom field. The created report can then be shared with other people in the organization. If another person in the organization runs the shared report and no results are returned, why might this be? (select all that apply)

A.

Fast mode is enabled.

B.

The dashboard is private.

C.

The extraction is private-

D.

The person in the organization running the report does not have access to the index.

Full Access
Question # 35

Which of the following searches show a valid use of a macro? (Choose all that apply.)

A.

index=main source=mySource oldField=* |’makeMyField(oldField)’| table _time newField

B.

index=main source=mySource oldField=* | stats if(‘makeMyField(oldField)’) | table _time newField

C.

index=main source=mySource oldField=* | eval newField=’makeMyField(oldField)’| table _time newField

D.

index=main source=mySource oldField=* | "’newField(‘makeMyField(oldField)’)’" | table _time newField

Full Access
Question # 36

This is what Splunk uses to categorize the data that is being indexed.

A.

sourcetype

B.

index

C.

source

D.

host

Full Access
Question # 37

Which tool uses data models to generate reports and dashboard panels without using SPL?

A.

Visualization tab

B.

Pivot

C.

Datasets

D.

splunk CIM

Full Access
Question # 38

Given the macro definition below, what should be entered into the Name and Arguments fileds to correctly configured the macro?

A.

The macro name is sessiontracker and the arguments are action, JESSIONID.

B.

The macro name is sessiontracker(2) and the arguments are action, JESSIONID.

C.

The macro name is sessiontracker and the arguments are $action$, $JESSIONID$.

D.

The macro name is sessiontracker(2) and the Arguments are $action$, $JESSIONID$.

Full Access
Question # 39

Calculated fields can be based on which of the following?

A.

Tags

B.

Extracted fields

C.

Output fields for a lookup

D.

Fields generated from a search string

Full Access
Question # 40

Two separate results tables are being combined using the join command. The outer table has the following values:

The inner table has the following values:

The line of SPL used to join the tables is: join employeeNumber type=outer

How many rows are returned in the new table?

A.

Three

B.

Eight

C.

Five

D.

Zero

Full Access
Question # 41

Which syntax will find events where the values for the 1 field match the values for the Renewal-MonthYear field?

A.

| where 10yearAnnerversary=Renewal-MonthYear

B.

| where ‘10yearAnnerversary=Renewal-MonthYear

C.

| where 10yearAnnerversary=’Renewal-MonthYear’

D.

| where ‘10yearAnnerversary’=’Renewal-MonthYear’

Full Access
Question # 42

What does the Splunk Common Information Model (CIM) add-on include? (select all that apply)

A.

Custom visualizations

B.

Pre-configured data models

C.

Fields and event category tags

D.

Automatic data model acceleration

Full Access
Question # 43

Using the export function, you can export search results as __________.( Select all that apply)

A.

Xml

B.

Json

C.

Html

D.

A php file

Full Access
Question # 44

How are arguments defined within the macro search string?

A.

Åžarg$

B.

'arg'

C.

%arg%

D.

"arg"

Full Access
Question # 45

Why are tags useful in Splunk?

A.

Tags look for less specific data.

B.

Tags visualize data with graphs and charts.

C.

Tags group related data together.

D.

Tags add fields to the raw event data.

Full Access
Question # 46

In most large Splunk environments, what is the most efficient command that can be used to group events by fields/

A.

join

B.

stats

C.

streamstats

D.

transaction

Full Access
Question # 47

A calculated field is a shortcut for performing repetitive, long, or complex transformations using which of the following commands?

A.

transaction

B.

lookup

C.

stats

D.

eval

Full Access
Question # 48

How is a variable for a macro defined?

A.

Place the variable name inside of curly braces: {variable name}.

B.

Place the variable name inside of asterisks: variable name.

C.

Place the variable name inside of dollar signs: $variable name$.

D.

Place the variable name inside of percentage signs: %variable name%.

Full Access
Question # 49

Which statement is true?

A.

Pivot is used for creating datasets.

B.

Data model are randomly structured datasets.

C.

Pivot is used for creating reports and dashboards.

D.

In most cases, each Splunk user will create their own data model.

Full Access
Question # 50

The stats command will create a _____________ by default.

A.

Table

B.

Report

C.

Pie chart

Full Access
Question # 51

When performing a regular expression (regex) field extraction using the Field Extractor (FX), what happens when the require option is used?

A.

The regex can no longer be edited.

B.

The field being extracted will be required for all future events.

C.

The events without the required field will not display in searches.

D.

Only events with the required string will be included in the extraction.

Full Access
Question # 52

What does the transaction command do?

A.

Groups a set of transactions based on time.

B.

Creates a single event from a group of events.

C.

Separates two events based on one or more values.

D.

Returns the number of credit card transactions found in the event logs.

Full Access
Question # 53

Which knowledge object is used to normalize field names to comply with the Splunk Common Information Model (CIM)?

A.

Field alias

B.

Event types

C.

Search workflow action

D.

Tags

Full Access
Question # 54

We can use the rename command to _____ (Select all that apply.)

A.

Change indexed fields

B.

Exclude fields from our search results

C.

Extract new fields from our data using regular expressions

D.

Give a field a new name at search time

Full Access
Question # 55

Consider the the following search run over a time range of last 7 days:

index=web sourcetype=access_conbined | timechart avg(bytes) by product_nane

Which option is used to change the default time span so that results are grouped into 12 hour intervals?

A.

span=12h

B.

timespan=12h

C.

span=12

D.

timespan=12

Full Access
Question # 56

Which of the following is included with the Common Information Model (CIM) add-on?

A.

Search macros

B.

Event category tags

C.

Workflow actions

D.

tsidx files

Full Access
Question # 57

Which of the following search control will not re-rerun the search? (Select all that apply.)

A.

zoom out

B.

selecting a bar on the timeline

C.

deselect

D.

selecting a range of bars on the timelines

Full Access
Question # 58

Which of the following statements describes macros?

A.

A macro is a reusable search string that must contain the full search.

B.

A macro is a reusable search string that must have a fixed time range.

C.

A macro Is a reusable search string that may have a flexible time range.

D.

A macro Is a reusable search string that must contain only a portion of the search.

Full Access
Question # 59

The gauge command:

A.

creates a single-value visualization

B.

allows you to set colored ranges for a single-value visualization

C.

creates a radial gauge visualization

Full Access
Question # 60

How is an event type created from the search window? (select all that apply)

A.

In the top right corner, click Save As > Event Type.

B.

In an event's detail dropdown, click Event Actions > Build Event Type.

C.

Edit eventtypes.conf and add a new stanza.

D.

Add | eventtype to the SPL and execute the search.

Full Access
Question # 61

When using the Field Extractor (FX) to perform a field extraction, which delimiter can be used?

A.

A period or comma.

B.

A comma.

C.

A tab or space.

D.

Any consistent character.

Full Access
Question # 62

What approach is recommended when using the Splunk Common Information Model (CIM) add-on to normalize data?

A.

Consult the CIM data model reference tables.

B.

Run a search using the authentication command.

C.

Consult the CIM event type reference tables.

D.

Run a search using the correlation command.

Full Access
Question # 63

During the validation step of the Field Extractor workflow:

Select your answer.

A.

You can remove values that aren't a match for the field you want to define

B.

You can validate where the data originated from

C.

You cannot modify the field extraction

Full Access
Question # 64

Which of the following searches show a valid use of macro? (Select all that apply)

A.

index=main source=mySource oldField=* |'makeMyField(oldField)'| table _time newField

B.

index=main source=mySource oldField=* | stats if('makeMyField(oldField)') | table _time newField

C.

index=main source=mySource oldField=* | eval newField='makeMyField(oldField)'| table _time newField

D.

index=main source=mySource oldField=* | "'newField('makeMyField(oldField)')'" | table _time newField

Full Access
Question # 65

Which workflow action method can be used the action type is set to link?

A.

GET

B.

PUT

C.

Search

D.

UPDATE

Full Access
Question # 66

Which syntax is used to represent an argument in a macro definition?

A.

"argument"

B.

%argument%

C.

‘argument’

D.

$argument$

Full Access
Question # 67

Information needed to create a GET workflow action includes which of the following? (select all that apply.)

A.

A name of the workflow action

B.

A URI where the user will be directed at search time.

C.

A label that will appear in the Event Action menu at search time.

D.

A name for the URI where the user will be directed at search time.

Full Access
Question # 68

The macro weekly_sales (2) contains the search string:

index=games | eval ProductSales = $Price$ * $AmountSold$

Which of the following will return results?

A.

‘weekly sales (3)’

B.

‘weekly_sales($3.995, $108)’

C.

'weekly_sales (3.99, 10)’

D.

‘weekly sales (3.99, 10)’

Full Access
Question # 69

Which of the following statements about tags is true? (select all that apply.)

A.

Tags are case-insensitive.

B.

Tags are based on field/vale pairs.

C.

Tags categorize events based on a search.

D.

Tags are designed to make data more understandable.

Full Access
Question # 70

When is a GET workflow action needed?

A.

To send field values to an external resource.

B.

To retrieve information from an external resource.

C.

To use field values to perform a secondary search.

D.

To define how events flow from forwarders to indexes.

Full Access
Question # 71

It is mandatory for the lookup file to have this for an automatic lookup to work.

A.

Source type

B.

At least five columns

C.

Timestamp

D.

Input filed

Full Access
Question # 72

Consider the following search:

Index=web sourcetype=access_combined

The log shows several events that share the same JSESSIONID value (SD404K289O2F151). View the events as a group. From the following list, which search groups events by JSESSIONID?

A.

index=web sourcetype=access_combined SD404K289O2F151 I table JSESSIONID

B.

index=web sourcetype=access_combined JSESSIONID

C.

index=web sourcetype=access_combined I highlight JSESSIONID I search SD404K289O2F151

D.

index-web sourcetype=access_combined I transaction JSESSIONID I search SD404K289O2F151

Full Access
Question # 73

How does a user display a chart in stack mode?

A.

By using the stack command.

B.

By turning on the Use Trellis Layout option.

C.

By changing Stack Mode in the Format menu.

D.

You cannot display a chart in stack mode, only a timechart.

Full Access
Question # 74

Where are the descriptions of the data models that come with the Splunk Common Information Model (CIM) Add-on documented?

A.

Search and reporting user manual.

B.

CIM Add-on manual.

C.

Pivot users manual.

D.

Datamodel command reference guide.

Full Access
Question # 75

Which are valid ways to create an event type? (select all that apply)

A.

By using the searchtypes command in the search bar.

B.

By editing the event_type stanza in the props.conf file.

C.

By going to the Settings menu and clicking Event Types > New.

D.

By selecting an event in search results and clicking Event Actions > Build Event Type.

Full Access
Question # 76

A user wants to create a new field alias for a field that appears in two sourcetypes.

How many field aliases need to be created?

A.

One.

B.

Two.

C.

It depends on whether the original fields have the same name.

D.

It depends on whether the two sourcetypes are associated with the same index.

Full Access
Question # 77

Which of the following objects can a calculated field use as a source?

A.

An alias of a field.

B.

A field added by an automatic lookup.

C.

The tag field.

D.

The eventtype field.

Full Access
Question # 78

When used with the timechart command, which value of the limit argument returns all values?

A.

limit=*

B.

limit=all

C.

limit=none

D.

limit=0

Full Access
Question # 79

A POST workflow action will pass which types of arguments to an external website?

A.

Clear text only.

B.

A mix of clear text strings and variables.

C.

It can only send raw event data.

D.

Variables only.

Full Access
Question # 80

What are the two parts of a root event dataset?

A.

Fields and variables.

B.

Fields and attributes.

C.

Constraints and fields.

D.

Constraints and lookups.

Full Access
Question # 81

A space is an implied _____ in a search string.

A.

OR

B.

AND

C.

()

D.

NOT

Full Access
Question # 82

By default search results are not returned in ________ order.

A.

Chronological

B.

Reverser chronological

C.

ASCIE

D.

Alphabetical

Full Access
Question # 83

Which of the following statements about event types is true? (select all that apply)

A.

Event types can be tagged.

B.

Event types must include a time range,

C.

Event types categorize events based on a search.

D.

Event types can be a useful method for capturing and sharing knowledge.

Full Access
Question # 84

In what order arc the following knowledge objects/configurations applied?

A.

Field Aliases, Field Extractions, Lookups

B.

Field Extractions, Field Aliases, Lookups

C.

Field Extractions, Lookups, Field Aliases

D.

Lookups, Field Aliases, Field Extractions

Full Access
Question # 85

What field must be present in order to use the timechart command?

A.

_raw

B.

rime

C.

_time

D.

index

Full Access
Question # 86

Use this command to use lookup fields in a search and see the lookup fields in the field sidebar.

A.

inputlookup

B.

lookup

Full Access
Question # 87

What functionality does the Splunk Common Information Model (CIM) rely on to normalize fields with different names?

A.

Macros.

B.

Field aliases.

C.

The rename command.

D.

CIM does not work with different names for the same field.

Full Access
Question # 88

Clicking a SEGMENT on a chart, ________.

A.

drills down for that value

B.

highlights the field value across the chart

C.

adds the highlighted value to the search criteria

Full Access