A company produces batch data from various databases and live stream data from network sensors and application APIs. The company needs to consolidate and process all incoming data, then stage it into different Amazon S3 buckets for one-time queries and later import into a BI tool for KPIs. Which combination of steps will meet these requirements with the LEAST operational overhead? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Use Amazon Athena for one-time queries, and use Amazon QuickSight to create dashboards for KPIs., Use blueprints in AWS Lake Formation to identify data to ingest into a data lake, and use AWS Glue to crawl the sources, extract the data, and load it into Amazon S3 in Apache Parquet format..
Why this is the answer
The correct options provide a serverless, managed approach with minimal operational overhead. Using AWS Lake Formation blueprints and AWS Glue for data ingestion and ETL into S3 in Parquet format is efficient. Lake Formation simplifies data lake setup, and Glue is a fully managed ETL service that can crawl diverse sources and convert data to an optimized format like Parquet for cost-effective storage and faster querying. Athena is a serverless query service perfect for ad-hoc analysis directly on S3 data, and QuickSight is a fully managed BI service for creating dashboards and KPIs. Incorrect options: Kinesis Data Analytics is for real-time analytics on streaming data, not typically for one-time queries on staged S3 data. Custom Lambda functions for moving individual records to Redshift would involve significant operational overhead for development, maintenance, and scaling, and Redshift is not ideal for consolidating diverse batch and stream data for staging before BI. AWS Glue ETL to JSON and loading into OpenSearch Service clusters would be more complex and costly than S
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed