Discuss ServiceNow CIS-PA Exam Topic 5 Question 13

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?

A300

B60

C30

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.

Get Premium CIS-PA Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

24 comments · newest first

Juliana 3 days ago

A) 300 is logical. Daily for each indicator.

Scarlet 8 days ago

B) 60 seems plausible too, but I doubt it.

Venita 14 days ago

I agree with A) 300. Each day, each indicator.

Melda 19 days ago

But if they share the same source, it could be D) 1.

Martina 24 days ago

I’m leaning towards B) 60. Maybe daily queries?

Malcolm 29 days ago

I feel it's too straightforward. A) 300 makes sense.

Dorothy 1 month ago

I think it's A) 300. 10 indicators for 30 days.

Rozella 1 month ago

I’m with A) 300. It’s straightforward math.

Isaac 1 month ago

I see your point, but I still think it’s B) 60.

Bettina 2 months ago

No way, it’s definitely A) 300. Daily means every indicator.

Arlyne 2 months ago

I’m leaning towards B) 60. One query per indicator per day?

Ashanti 2 months ago

I feel like it’s still A) 300. Each day counts.

Alpha 2 months ago

But what if they share the same source? Maybe it's less?

Gianna 2 months ago

I agree, A) 300 makes sense. Daily queries add up.

Venita 3 months ago

I think it's A) 300. 10 indicators times 30 days.

Evan 3 months ago

Nah, it's definitely not just 1!

Emogene 3 months ago

I thought it would be less, maybe 60?

Owen 3 months ago

Wait, are we sure about that? Seems like a lot!

Jade 3 months ago

I agree, 300 makes sense!

Glennis 3 months ago

It's definitely 300 queries. 10 indicators x 30 days.

Merlyn 4 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.

Aleta 4 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.

Rosendo 4 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?

Teddy 4 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?

ServiceNow CIS-PA Exam - Topic 5 Question 13 Discussion