HikeHills.com (HH) is an online specialty retailer that sells clothing and outdoor refreshment gear for trekking, go camping, boulevard biking, mountain biking, rock hiking, ice mountaineering, skiing, avalanche protection, snowboarding, fly fishing, kayaking, rafting, road and trace running, and many more.
HH runs their entire online infrastructure on java based web applications running on AWS. The HH is capturing clickstream data and use custom-build recommendation engine to recommend products which eventually improve sales, understand customer preferences and already using AWS Streaming capabilities to collect events and transaction logs and process the stream.
HH is using kinesis analytics to build SQL querying capability on streaming and planning to use windowed Queries to process the data. What kind of windows queries need to be used to that aggregates data continuously, using a fixed time or rowcount interval for e.g. after 1 minute or after 2000 rows. select 1 option.

Answer options:

A.Stagger Windows queries
B.Tumbling Windows queries
C.Sliding windows queries
D.Continuous queries

Answer: C
Option A is incorrect -Stagger windows query, A query that aggregates data using keyed time-based windows that open as data arrives. The keys allow for multiple overlapping windows. This is the recommended way to aggregate data using time-based windows
https://docs.aws.amazon.com/kinesisanalytics/latest/dev/stagger-window-concepts.html
Option B is incorrect -Tumbling Windows query, A query that aggregates data using distinct time-based windows that open and close at regular intervals.
https://docs.aws.amazon.com/kinesisanalytics/latest/dev/tumbling-window-concepts.html
Option C is correct -Sliding windows query, A query that aggregates data continuously, using a fixed time or rowcount interval.
https://docs.aws.amazon.com/kinesisanalytics/latest/dev/sliding-window-concepts.html
Option D is incorrect -Continuous Query is a query over a stream executes continuously over streaming data. This continuous execution enables scenarios, such as the ability for applications to continuously query a stream and generate alerts.
https://docs.aws.amazon.com/kinesisanalytics/latest/dev/continuous-queries-concepts.html