Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

ServiceNow CIS-PA Exam - Topic 5 Question 13 Discussion

How many SQL queries are executed during a 30-day historical collection if all 10 indicators in the historical collection share the same daily indicator source?
C) 30
A) 300
B) 60
D) 1

ServiceNow CIS-PA Exam - Topic 5 Question 13 Discussion

Actual exam question for ServiceNow's CIS-PA exam
Question #: 13
Topic #: 5
[All CIS-PA Questions]

How many SQL queries are executed during a 30-day historical collection if all 10 indicators in the historical collection share the same daily indicator source?

Show Suggested Answer Hide Answer
Suggested Answer: C

Platform Analytics optimizes historical data collection by executing one query per indicator source per day, regardless of how many indicators reference that source. If 10 indicators share the same daily indicator source, the system executes only one SQL query per day, not one per indicator.

Over a 30-day historical collection period, this results in 30 SQL queries total. This optimization significantly reduces database load and improves performance. ServiceNow documentation explicitly highlights this behavior as a best-practice advantage of reusing indicator sources. Therefore, option C is the correct and documented answer.


Contribute your Thoughts:

0/2000 characters
Bettina
4 days ago
No way, it’s definitely A) 300. Daily means every indicator.
upvoted 0 times
...
Arlyne
9 days ago
I’m leaning towards B) 60. One query per indicator per day?
upvoted 0 times
...
Ashanti
15 days ago
I feel like it’s still A) 300. Each day counts.
upvoted 0 times
...
Alpha
20 days ago
But what if they share the same source? Maybe it's less?
upvoted 0 times
...
Gianna
25 days ago
I agree, A) 300 makes sense. Daily queries add up.
upvoted 0 times
...
Venita
1 month ago
I think it's A) 300. 10 indicators times 30 days.
upvoted 0 times
...
Evan
1 month ago
Nah, it's definitely not just 1!
upvoted 0 times
...
Emogene
1 month ago
I thought it would be less, maybe 60?
upvoted 0 times
...
Owen
2 months ago
Wait, are we sure about that? Seems like a lot!
upvoted 0 times
...
Jade
2 months ago
I agree, 300 makes sense!
upvoted 0 times
...
Glennis
2 months ago
It's definitely 300 queries. 10 indicators x 30 days.
upvoted 0 times
...
Merlyn
2 months ago
I’m leaning towards 300 since it seems logical to run a query for each indicator every day, but I could be overthinking it.
upvoted 0 times
...
Aleta
2 months ago
I’m confused about whether the daily source affects the total count. I thought it might just be 30 if it’s one query per day.
upvoted 0 times
...
Rosendo
2 months ago
I'm not entirely sure, but I feel like there was a similar question in our practice that involved daily queries. Could it be 60?
upvoted 0 times
...
Teddy
3 months ago
I think I remember something about multiplying the number of days by the number of indicators, so that might be 30 times 10?
upvoted 0 times
...

Save Cancel