Splunk
SPLK-3003 · Question #20
A customer has written the following search: How can the search be rewritten to maximize efficiency? A. B. C. D.
The correct answer is C. index=sales sourcetype=purchase:orders customer="timmy*" | lookup vip_customers customer OUTPUT vip_status | search vip_status = "true" | stats sum(amount) AS amount latest (_time) AS _time by customer, order_id | table _time, customer, order_id, amount. You've hit your limit · resets 5:20am (America/New_York)
Search Performance and Optimization
Question
A customer has written the following search:
How can the search be rewritten to maximize efficiency? A. B. C. D.
Exhibits
Options
- Aindex=sales sourcetype=purchase:orders | table _time, customer, product, amount, order_id | stats count sum(amount) AS amount latest (_time) AS _time by customer, order_id | search customer = "timmy*" | lookup vip_customers customer OUTPUT vip_status | table _time, customer, order_id, amount, vip_status | search vip_status="true"
- Bindex=sales sourcetype=proxydata:syslog user="timmy*" | table _time, user, url, duration, category, action | stats sum(duration) AS duration latest(url) AS url latest (_time) AS _time by user | lookup user_status user OUTPUT user | table _time, user, status
- Cindex=sales sourcetype=purchase:orders customer="timmy*" | lookup vip_customers customer OUTPUT vip_status | search vip_status = "true" | stats sum(amount) AS amount latest (_time) AS _time by customer, order_id | table _time, customer, order_id, amount
- Dindex=sales sourcetype=purchase:orders customer="timmy*" | lookup vip_customers customer OUTPUT vip_status | stats sum(amount) AS amount latest (_time) AS _time by customer, order_id | search vip_status="true" | table _time, customer, order_id, amount, vip_status
How the community answered
(24 responses)- A13% (3)
- B17% (4)
- C67% (16)
- D4% (1)
Explanation
You've hit your limit · resets 5:20am (America/New_York)
Topics
#search optimization#SPL best practices#search efficiency#search performance
Community Discussion
No community discussion yet for this question.




