A company is designing a data lake architecture on AWS. They need to ingest streaming data from IoT devices, store it cost-effectively, and allow data scientists to run ad-hoc SQL queries on the data without provisioning database infrastructure. Which TWO services should be used? (Select TWO)

Answer options:

Amazon Kinesis Data Firehose

Amazon RDS for PostgreSQL

Amazon Athena

Amazon Redshift

AWS Glue DataBrew

Amazon DynamoDB

How to approach this question

Identify the ingestion service for streaming data to S3 (Firehose) and the serverless SQL query engine for S3 (Athena).

Full Answer

Amazon Kinesis Data Firehose Amazon Athena

Amazon Kinesis Data Firehose is the easiest way to reliably load streaming data into data lakes (S3). Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL without managing any infrastructure.

Common mistakes

Choosing Redshift for simple ad-hoc queries against S3, which is overkill and requires more setup.

Question 58 All questions Question 60

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 1

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 50 VPCs across two AWS Regions. They need to establish transitive routing betwe...Hard Q02A company uses AWS Organizations. The security team wants to ensure that no IAM user or role can ...Medium Q03An application requires a relational database with an RPO of 1 second and an RTO of less than 1 m...Hard Q04A company is setting up a new multi-account environment. They want to automate the provisioning o...Medium Q05An organization wants to allocate AWS costs to specific business units. They use AWS Organization...Hard

View all 75 questions →