Question 100

A retailer needs to land incoming purchase events in S3 with managed buffering and minimal stream-consumer code. Which service should receive the events?

  1. Amazon MSK
  2. DynamoDB Streams
  3. Amazon Kinesis Data Streams
  4. Amazon Data Firehose

Explanation

Correct Answer

D:

Firehose buffers streaming records and delivers them to configured analytics destinations; in this scenario, configure an S3 destination and appropriate buffering; delivery is managed without maintaining custom shard readers.

Incorrect Answers

A:

Amazon MSK runs managed Apache Kafka brokers while retaining Kafka client and topic semantics; the current need is for continuously depositing events into an S3 data lake, not migrating existing Kafka producers without rewriting clients.

B:

DynamoDB Streams exposes item-level changes made to a DynamoDB table for downstream processors; this can support reacting to inserts and updates of table items, but would not address the need for continuously depositing events into an S3 data lake.

C:

A data stream retains ordered records in shards for applications that read at their own pace; this helps with keeping a replayable clickstream for independent consumers, not continuously depositing events into an S3 data lake.

Question 101

A fraud detection pipeline receives small events at extremely high frequency and needs low-latency decisions. Which dimension matters most?

  1. Data veracity validation
  2. High-velocity streaming architecture
  3. Schema-flexible variety handling
  4. High-volume batch architecture

Explanation

Correct Answer

B:

Velocity describes how rapidly data arrives and how quickly it needs to be handled; in this scenario, plan throughput, buffering and stream-consumer capacity around event arrival rate and latency objectives.

Incorrect Answers

A:

Veracity concerns trustworthiness and reliability of incoming information rather than its quantity or speed; this helps with checking suspicious and conflicting source records, not coping with millions of events arriving per second.

C:

Variety covers multiple structures and types including relational rows, JSON, images and free text; it would target ingesting incompatible structured and unstructured formats, while the question is about coping with millions of events arriving per second.

D:

Volume describes the total quantity of data that must be stored and processed; its benefit is scaling storage and parallelism for terabytes of historical data; that is different from coping with millions of events arriving per second.

Question 102

An incident handler needs to group Lambda error records by extracted message field over the last hour. Which tool fits?

  1. OpenSearch Service indexed audit exploration
  2. Athena over S3 CloudTrail logs
  3. CloudTrail Lake SQL query
  4. CloudWatch Logs subscription forwarding
  5. CloudWatch Logs Insights query

Explanation

Correct Answer

E:

Logs Insights performs interactive filtered searches and aggregations over CloudWatch application log groups; in this scenario, search the relevant log groups and parse structured fields to summarize exception frequency quickly.

Incorrect Answers

A:

OpenSearch can index log documents to support interactive search and visualization; this can support searching repeated substrings across a large normalized log index, but would not address the need for counting application exception types in Lambda logs.

B:

Athena can query CloudTrail files in S3 after defining compatible schemas and partitions; this helps with joining archived API logs with lake reference datasets, not counting application exception types in Lambda logs.

C:

CloudTrail Lake supports SQL-based analysis over events collected in event data stores; although useful for investigating account activity with structured SQL, it leaves the need for counting application exception types in Lambda logs unmet.

D:

Subscription filters can deliver matching CloudWatch log events to downstream processing destinations; it would target streaming application audit records to a central pipeline, while the question is about counting application exception types in Lambda logs.

Question 103

A Lake Formation access review finds a related IAM role policy changed yesterday. Which event class helps trace the actor?

  1. CloudTrail management-event records
  2. CloudTrail organization trail
  3. CloudTrail S3 object data events
  4. CloudTrail log file integrity validation

Explanation

Correct Answer

A:

Management events track AWS control-plane actions such as PutBucketPolicy and CreateRole; in this scenario, search relevant CloudTrail management operations with principal, request parameters and timestamp to identify the change.

Incorrect Answers

B:

An organization trail can collect supported management activity centrally for accounts in an AWS Organization; this helps with covering many accounts with one audit policy, not finding who changed resource permissions.

C:

CloudTrail can capture selected S3 object-level APIs as data events when explicitly configured; although useful for identifying who downloaded restricted data-lake objects, it leaves the need for finding who changed resource permissions unmet.

D:

Trail log file integrity validation provides digest files that can help detect tampering of delivered log files; it would target proving stored audit logs were not silently altered, while the question is about finding who changed resource permissions.

Question 104

An MWAA environment was offline for a week and now tries to execute every missed daily interval, flooding the source database. Which setting should be reviewed?

  1. Step Functions task token callback
  2. Airflow catchup configuration
  3. EventBridge Scheduler retry policy
  4. Glue workflow run properties

Explanation

Correct Answer

B:

Airflow catchup behavior determines whether a DAG schedules missed historical intervals when enabled; in this scenario, configure DAG catchup and start-date behavior to match whether historical backfills are actually required.

Incorrect Answers

A:

A task token lets a state-machine task wait for an external system to signal completion; this can support pausing a workflow for asynchronous external approval, but would not address the need for preventing a flood of old scheduled DAG runs.

C:

Scheduler targets can have retry policies and dead-letter queue configuration for failed delivery attempts; although useful for recovering from temporary failure to invoke a scheduled target, it leaves the need for preventing a flood of old scheduled DAG runs unmet.

D:

Glue workflow run properties allow pipeline components to share run-scoped configuration values; it would target passing an ingestion batch identifier between Glue jobs, while the question is about preventing a flood of old scheduled DAG runs.

Question 105

A data-center NAS must send millions of files to S3 with verification and managed scheduling. Which tool is appropriate?

  1. AWS DataSync transfer task
  2. S3 multipart upload
  3. AWS Snow Family offline transfer
  4. AWS Transfer Family SFTP server

Explanation

Correct Answer

A:

DataSync moves large datasets between supported on-premises or AWS storage locations with transfer management; in this scenario, deploy the source connectivity and run a DataSync task to copy and verify objects without custom recursive scripts.

Incorrect Answers

B:

Multipart upload sends large objects as separately uploaded parts that can be retried independently; its benefit is reliably uploading individual multi-gigabyte files over a variable connection; that is different from migrating terabytes from an on-premises file share into S3.

C:

Snow devices can support offline movement of large datasets when network bandwidth is inadequate; the current need is for migrating terabytes from an on-premises file share into S3, not seeding a cloud lake from a bandwidth-constrained site.

D:

Transfer Family exposes managed SFTP endpoints that can land partner files into S3 or EFS; this can support receiving external partner uploads over SFTP, but would not address the need for migrating terabytes from an on-premises file share into S3.

Question 106

An incorrect report must be traced back to the input object versions and ETL execution that produced it. What metadata should be retained?

  1. SageMaker ML Lineage Tracking
  2. Job-run lineage metadata
  3. Column-level lineage mapping
  4. SageMaker Catalog lineage graph

Explanation

Correct Answer

B:

Recording run identifiers, source versions and target outputs connects a materialized dataset to its producing workflow; in this scenario, store run IDs, input object identifiers and output versions as provenance records alongside the published dataset.

Incorrect Answers

A:

ML lineage facilities can record relationships among model-development artifacts and processing steps; its benefit is tracing artifacts in a supported ML-related data preparation workflow; that is different from auditing the exact files used in one derived table version.

C:

Column-level lineage records how source fields produce downstream columns through transformations; this can support determining whether a sensitive input field reaches a report column, but would not address the need for auditing the exact files used in one derived table version.

D:

Catalog lineage can represent data assets and transformations to help trace upstream and downstream dependencies; this helps with tracing business report fields to source datasets, not auditing the exact files used in one derived table version.

Question 107

A queue consumer normally finishes in a minute, but occasional transformations take twenty-five minutes. A fixed short visibility timeout causes another worker to process the same message before completion. Which API-based approach helps?

  1. SQS dead-letter queue
  2. Idempotent processing checkpoint
  3. Step Functions retry with backoff
  4. Multi-AZ dependent services
  5. SQS ChangeMessageVisibility heartbeat

Explanation

Correct Answer

E:

The SQS ChangeMessageVisibility API can dynamically extend the invisibility period of an in-flight message as a variable-length task proceeds; in this scenario, call ChangeMessageVisibility before the current interval ends during slow work, and delete the message only after successful processing; retain idempotency.

Incorrect Answers

A:

A dead-letter queue collects messages that repeatedly fail processing after configured receive attempts; the current need is for extending SQS visibility for a task whose running time varies widely, not isolating permanently failing messages for investigation.

B:

Durable checkpoints plus idempotent sink writes limit duplicate effects after task retries; this can support making a restarted pipeline safe to replay, but would not address the need for extending SQS visibility for a task whose running time varies widely.

C:

State machine Retry rules can handle selected errors with intervals and exponential backoff; this helps with recovering from transient downstream API failures, not extending SQS visibility for a task whose running time varies widely.

D:

Using supported multi-AZ data services can reduce interruption from a single Availability Zone failure; although useful for keeping stateful dependencies available during one AZ outage, it leaves the need for extending SQS visibility for a task whose running time varies widely unmet.

Question 108

A central lake hosts cataloged finance data and a separate analytics account needs scoped SQL access without copying all objects. What mechanism fits?

  1. S3 access point scoped sharing
  2. Lake Formation cross-account sharing
  3. AWS Data Exchange subscription
  4. Redshift producer datashare authorization

Explanation

Correct Answer

B:

Lake Formation can govern cross-account catalog resource permissions for supported data-lake sharing workflows; in this scenario, grant cross-account governance permissions and configure resource sharing and recipient access according to the integration path.

Incorrect Answers

A:

S3 access points can provide separate access and network controls for applications using a common bucket; this helps with sharing one lake bucket with several differently authorized applications, not granting another account access to approved governed S3 tables.

C:

AWS Data Exchange provides ways for subscribers to discover and access licensed third-party datasets; it would target obtaining an external provider's licensed dataset under managed terms, while the question is about granting another account access to approved governed S3 tables.

D:

Redshift producer administrators grant and authorize consumer access to datashares containing specified warehouse objects; its benefit is authorizing a new cross-account consumer of an existing Redshift datashare; that is different from granting another account access to approved governed S3 tables.

Question 109

A dashboard needs summary values but must not receive direct database credentials or arbitrary SQL access. What backend pattern helps?

  1. AppSync GraphQL resolver
  2. S3 presigned GET URL
  3. Lambda query facade
  4. API Gateway REST API integration

Explanation

Correct Answer

C:

A Lambda handler can validate inputs, query a datastore and serialize responses for API callers; in this scenario, put a narrowly scoped Lambda function behind the API and enforce authorized queries and output filtering server-side.

Incorrect Answers

A:

AppSync supports GraphQL operations with resolvers that access data sources; although useful for exposing a typed GraphQL interface to clients, it leaves the need for hiding database credentials and SQL behind a service endpoint unmet.

B:

A presigned S3 URL grants time-limited access to a specific object using the signer's permissions; it would target securely delivering a large generated report file, while the question is about hiding database credentials and SQL behind a service endpoint.

D:

API Gateway can expose authenticated HTTP methods that route to a backed data service; the current need is for hiding database credentials and SQL behind a service endpoint, not publishing filtered datasets through a governed API.

Question 110

A report must combine Redshift history with a small, live PostgreSQL table that cannot be copied nightly. What access mechanism helps?

  1. Redshift federated query
  2. Redshift materialized view
  3. Redshift Spectrum external tables
  4. Redshift datashare

Explanation

Correct Answer

A:

Redshift federated query reads supported operational relational databases from analytic SQL; in this scenario, query the supported external database through a federated schema and limit remote reads to avoid overloading the source.

Incorrect Answers

B:

A materialized view persists computed query results for repeated retrieval and planned refresh; its benefit is caching a recurring expensive analytic result inside the warehouse; that is different from joining current operational rows from a supported database without bulk replication.

C:

Redshift Spectrum queries external data in S3 via catalog-backed external table definitions; the current need is for joining current operational rows from a supported database without bulk replication, not joining S3 lake datasets without first loading them into warehouse tables.

D:

Redshift data sharing lets authorized consumers query shared warehouse data without making full copies; this can support exposing governed datasets to a separate Redshift consumer, but would not address the need for joining current operational rows from a supported database without bulk replication.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests