A company needs to collect and process streaming data from IoT sensors at a rate of 10,000 records per second. The data needs to be analyzed in near real-time and stored in S3 for long-term analysis. Which AWS service combination is MOST appropriate?
Aws De Ingestion Transformation
Question · Medium
4 database copies. 1 is lying.
Short
FREE AWS Data Engineer DEA-C01 Exam Guide 2026: Pass First Try
Free 2026 AWS Certified Data Engineer Associate (DEA-C01) study guide: 65 questions, 130 min, $150 fee, 720 pass, 4 domains, Glue/Redshift/Kinesis, 12-week plan.
Blog
Which Amazon Kinesis feature allows you to replay data from a specific point in time within the retention period?
Chapter 1: Streaming Data Ingestion
1.1 Kinesis Data Streams vs. Firehose Architecture & Partitioning
Study guide
A data engineer needs to process clickstream data with multiple independent applications reading the same stream. Each application must read at its own pace without affecting others. Which Kinesis feature should be used?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
What is the maximum retention period for data in Amazon Kinesis Data Streams?
Question · Easy
A company needs to build an ETL pipeline that transforms data from S3 and loads it into Redshift. The transformation requires complex business logic written in Python. Which AWS service should be used?
Deep Archive: a lullaby for cold data
Which AWS Glue feature automatically discovers and catalogs metadata from data sources?
1.2 Amazon MSK (Managed Streaming for Apache Kafka) & Serverless Patterns
A data engineer needs to transform JSON data to Parquet format and partition it by date for better query performance. Which AWS Glue feature is MOST suitable?
What is the purpose of AWS Glue bookmarks?
A company uses Amazon DynamoDB and needs to capture item-level changes to replicate data to an S3 data lake in near real-time. Which solution is MOST appropriate?
Which Amazon MSK feature helps automatically provision and manage Apache Kafka clusters?
1.3 Event-Driven Streaming Ingestion with DynamoDB Streams & Lambda
A data engineer needs to migrate data from an on-premises Oracle database to Amazon S3 with minimal downtime. Which AWS service should be used?
A data pipeline needs to execute a sequence of steps: check for new files in S3, run a Glue job if found, then send a notification. Which service is BEST suited for this orchestration?
Which feature of Amazon MWAA (Managed Workflows for Apache Airflow) allows integration with AWS services?
A company needs to process large-scale log data using Apache Spark with the ability to run machine learning libraries. Which service should be recommended?
1.4 Streaming Distribution, Replay & Processing State
What is the maximum execution timeout for an AWS Lambda function?
A data engineer needs to validate incoming data for schema compliance and data quality rules before loading to the data warehouse. Which AWS service provides built-in data quality capabilities?
Which AWS service can be used to schedule recurring data pipeline executions using cron expressions?
Which S3 storage class is MOST cost-effective for data that is accessed less than once per year but requires milliseconds retrieval time?
Aws De Data Stores
Chapter 2: Batch Data Ingestion & Migration
2.1 AWS DMS (Database Migration Service) & Change Data Capture (CDC)
A data lake stores data in S3 partitioned by year, month, and day. Which feature helps optimize query performance when using Athena?
Question · Hard
What is the default maximum size of an S3 object?
Which Amazon Redshift feature automatically optimizes query performance by choosing the most efficient distribution style and sort keys?
A company needs to load data from S3 into Redshift with the fastest performance. Which COPY command option should be used?
2.2 S3 Batch Operations & High-Throughput Bulk Data Ingestion
Which distribution style in Amazon Redshift is MOST appropriate for small dimension tables that are frequently joined with large fact tables?
A data engineer needs to query data stored in S3 using SQL without loading it into a database. Which service is MOST appropriate?
Which file format typically provides the best query performance in Amazon Athena for large datasets?
Which AWS service provides centralized access control for data lakes across multiple analytics services?
2.3 Hybrid Data Transfer with Snow Family & AWS DataSync
A data engineer needs to grant SELECT permission on specific columns of a table to a group of analysts. Which Lake Formation feature enables this?
Which Amazon DynamoDB feature enables point-in-time recovery (PITR) for accidental deletion protection?
A data engineer needs a NoSQL database for storing graph data with billions of relationships. Which service should be recommended?
Which RDS feature creates a standby instance in a different Availability Zone for high availability?
2.4 Application, API & Managed File Ingestion
Which Amazon CloudWatch feature can trigger an alert when an AWS Glue job fails?
Aws De Operations Support
A data engineer needs to track API calls made to AWS services for security auditing. Which service should be used?
Which CloudWatch metric is MOST important for monitoring Amazon Kinesis Data Streams capacity?
An AWS Glue job is failing with "OutOfMemoryError" errors. Which is the MOST appropriate solution?
Chapter 3: ETL Transformation with AWS Glue
3.1 AWS Glue Jobs, DynamicFrames & PySpark Transformations
A Redshift query is running slowly due to disk-based operations. Which metric in CloudWatch indicates this issue?
Loading more…