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
Owen
49 minutes ago
Wait, are we sure about that? Seems like a lot!
upvoted 0 times
...
Jade
5 days ago
I agree, 300 makes sense!
upvoted 0 times
...
Glennis
10 days ago
It's definitely 300 queries. 10 indicators x 30 days.
upvoted 0 times
...
Merlyn
16 days 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
21 days 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
26 days 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
1 month 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