KQL Flashcards

(51 cards)

1
Q

What does KQL stand for?

A

Kibana Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or False: KQL is a case-sensitive query language.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the primary use of Kibana Query Language?

A

To search and filter data in Kibana.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Fill in the blank: KQL is used to construct queries for _______.

A

Elasticsearch

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which operator is used to combine multiple conditions in KQL?

A

AND

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What operator would you use to specify an alternative condition in KQL?

A

OR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or False: You can use wildcards in KQL queries.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What symbol is used for a wildcard match in KQL?

A

*

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How do you denote a phrase search in KQL?

A

By enclosing the phrase in double quotes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the syntax to search for documents where ‘status’ is ‘active’?

A

status: active

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In KQL, how do you search for documents that do not contain a specific term?

A

Using the NOT operator.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

True or False: KQL supports regular expressions.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the purpose of the ‘exists’ query in KQL?

A

To check if a field is present in the document.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What operator would you use to search for a specific range of values?

A

The range operator.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How do you format a range search for values between 10 and 20 in KQL?

A

field:[10 TO 20]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What keyword is used to group conditions in KQL?

A

Parentheses

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

True or False: KQL allows for nested queries.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What would be the KQL syntax to search for documents where ‘user’ is ‘john’ and ‘status’ is ‘active’?

A

user: john AND status: active

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How do you search for documents that contain either ‘error’ or ‘warning’?

A

message: error OR message: warning

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is the function of the ‘field: value’ structure in KQL?

A

It specifies a query targeting a specific field with a specific value.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

True or False: KQL can be used to query numeric fields.

22
Q

What is the significance of using quotes around a term in KQL?

A

It indicates a phrase search.

23
Q

Fill in the blank: In KQL, the _____ operator is used to exclude terms.

24
Q

What is the KQL syntax for searching for documents where ‘category’ is not ‘finance’?

A

NOT category: finance

25
How do you perform a fuzzy search in KQL?
By appending a tilde (~) to the term.
26
True or False: KQL supports sorting of search results.
False
27
What would the KQL query 'status: active AND (user: john OR user: jane)' return?
Documents where status is active and user is either john or jane.
28
What is the result of the KQL query 'message: error*'?
Documents where the message field starts with 'error'.
29
How do you search for documents with a specific field value in KQL?
field: value
30
What does the 'wildcard' query do in KQL?
It allows for flexible matching of terms using wildcard characters.
31
True or False: KQL can be used in visualizations within Kibana.
True
32
What is the KQL syntax for searching for documents where the 'age' field is greater than 30?
age: >30
33
Fill in the blank: KQL queries can be saved and reused in ______.
Kibana dashboards
34
What would be the KQL syntax to find documents where 'status' is 'pending' and 'amount' is less than 500?
status: pending AND amount: <500
35
True or False: You can use KQL to perform aggregations.
False
36
What does the 'not' operator do in KQL?
It negates the condition that follows it.
37
How do you specify multiple fields in a single KQL query?
By separating them with commas.
38
What is the KQL syntax for searching for documents where 'status' is either 'active' or 'inactive'?
status: (active OR inactive)
39
True or False: KQL can be used to filter data in Kibana visualizations.
True
40
How do you indicate a phrase search for 'data analysis' in KQL?
"data analysis"
41
What is the KQL syntax to find documents where 'user' is not 'admin'?
NOT user: admin
42
Fill in the blank: KQL allows users to create queries based on ______ fields.
specific
43
What does the 'exists' function check in KQL?
It checks if a field exists in the document.
44
True or False: KQL supports joining of multiple data sources.
False
45
What is the KQL syntax for searching for documents that have a 'price' greater than or equal to 100?
price: >=100
46
How do you denote a query that includes both 'error' and 'timeout' in KQL?
message: error AND message: timeout
47
What is the purpose of the 'group by' function in KQL?
KQL does not have a 'group by' function.
48
Fill in the blank: KQL is designed for ______ users.
non-technical
49
True or False: KQL can be used for full-text search.
True
50
What is the KQL syntax for searching for a numeric range between 1 and 10?
number_field: [1 TO 10]
51
What is the correct way to search for a term that is not present in a field in KQL?
field: * NOT field: term