Question 300
A proposed AWS solution must satisfy TWO independent requirements: (1) An analytics team wants SQL queries directly over partitioned S3 objects with no persistent warehouse cluster to administer. (2) A warehouse must receive S3 event files with minimal delay while providing downstream consumers durable error handling. Which TWO design actions collectively meet the requirements?
Explanation
Correct Answers
Requirement (1): Use Amazon Athena with AWS Glue Data Catalog and a compatible format/partition scheme. Athena provides serverless SQL over S3 while scan size and partitions affect cost/performance. Validate separately that A time-bounded query returns accurate results without an always-running database cluster.
Requirement (2): Route new-object events through EventBridge/SQS and trigger validated ingestion workers with replay-safe processing. Event-driven ingestion needs durable notification/retry design because event delivery may repeat or fail. Validate separately that A new verified object appears in the curated dataset shortly after upload without duplicates.
Incorrect Answers
DataSync is built for file/object transfers with incremental synchronization, not transactional database migration.
Distributed data processing capacity can be provisioned per job while source data persists separately.
CDC semantics require handling inserts, updates and deletes, not only appending new records.