Question 290

A scheduled job sometimes fails to start because its target invocation is temporarily unavailable. What scheduler behavior should be configured?

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

Explanation

Correct Answer

D:

Scheduler targets can have retry policies and dead-letter queue configuration for failed delivery attempts; in this scenario, set bounded retries and a dead-letter destination while ensuring the invocation role permits the target operation.

Incorrect Answers

A:

Airflow catchup behavior determines whether a DAG schedules missed historical intervals when enabled; this can support preventing a flood of old scheduled DAG runs, but would not address the need for recovering from temporary failure to invoke a scheduled target.

B:

A task token lets a state-machine task wait for an external system to signal completion; this helps with pausing a workflow for asynchronous external approval, not recovering from temporary failure to invoke a scheduled target.

C:

Glue workflow run properties allow pipeline components to share run-scoped configuration values; although useful for passing an ingestion batch identifier between Glue jobs, it leaves the need for recovering from temporary failure to invoke a scheduled target unmet.

Question 291

A custom exporter repeatedly restarts a 50 GB upload after brief network failures. Which S3 upload feature improves resiliency?

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

Explanation

Correct Answer

C:

Multipart upload sends large objects as separately uploaded parts that can be retried independently; in this scenario, upload parts separately, retry only failed parts and complete the multipart upload after every expected part succeeds.

Incorrect Answers

A:

Transfer Family exposes managed SFTP endpoints that can land partner files into S3 or EFS; it would target receiving external partner uploads over SFTP, while the question is about reliably uploading individual multi-gigabyte files over a variable connection.

B:

DataSync moves large datasets between supported on-premises or AWS storage locations with transfer management; its benefit is migrating terabytes from an on-premises file share into S3; that is different from reliably uploading individual multi-gigabyte files over a variable connection.

D:

Snow devices can support offline movement of large datasets when network bandwidth is inadequate; this can support seeding a cloud lake from a bandwidth-constrained site, but would not address the need for reliably uploading individual multi-gigabyte files over a variable connection.

Question 292

A governance reviewer must know whether raw customer email contributes to any downstream table field after joins and hashing. What lineage granularity is needed?

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

Explanation

Correct Answer

D:

Column-level lineage records how source fields produce downstream columns through transformations; in this scenario, trace transformations at the column level, including derived and masked fields, not only table-to-table dependencies.

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 determining whether a sensitive input field reaches a report column.

B:

Catalog lineage can represent data assets and transformations to help trace upstream and downstream dependencies; the current need is for determining whether a sensitive input field reaches a report column, not tracing business report fields to source datasets.

C:

Recording run identifiers, source versions and target outputs connects a materialized dataset to its producing workflow; this can support auditing the exact files used in one derived table version, but would not address the need for determining whether a sensitive input field reaches a report column.

Question 293

A multi-step pipeline fails whenever its single-AZ relational endpoint becomes unavailable. What availability improvement targets this risk?

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

Explanation

Correct Answer

E:

Using supported multi-AZ data services can reduce interruption from a single Availability Zone failure; in this scenario, deploy a supported Multi-AZ configuration for the database and test application failover, because retry logic cannot restore a downed sole instance.

Incorrect Answers

A:

Durable checkpoints plus idempotent sink writes limit duplicate effects after task retries; the current need is for keeping stateful dependencies available during one AZ outage, not making a restarted pipeline safe to replay.

B:

State machine Retry rules can handle selected errors with intervals and exponential backoff; this can support recovering from transient downstream API failures, but would not address the need for keeping stateful dependencies available during one AZ outage.

C:

A dead-letter queue collects messages that repeatedly fail processing after configured receive attempts; this helps with isolating permanently failing messages for investigation, not keeping stateful dependencies available during one AZ outage.

D:

The SQS ChangeMessageVisibility API can dynamically extend the invisibility period of an in-flight message as a variable-length task proceeds; although useful for extending SQS visibility for a task whose running time varies widely, it leaves the need for keeping stateful dependencies available during one AZ outage unmet.

Question 294

Two applications should read distinct S3 prefixes with different policy restrictions while the physical bucket remains shared. Which entry-point design helps?

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

Explanation

Correct Answer

D:

S3 access points can provide separate access and network controls for applications using a common bucket; in this scenario, use separate access points and policy scopes, auditing how IAM and bucket permissions combine for each workload.

Incorrect Answers

A:

Redshift producer administrators grant and authorize consumer access to datashares containing specified warehouse objects; this helps with authorizing a new cross-account consumer of an existing Redshift datashare, not sharing one lake bucket with several differently authorized applications.

B:

Lake Formation can govern cross-account catalog resource permissions for supported data-lake sharing workflows; although useful for granting another account access to approved governed S3 tables, it leaves the need for sharing one lake bucket with several differently authorized applications unmet.

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 sharing one lake bucket with several differently authorized applications.

Question 295

An API response would otherwise transfer a 500 MB report through a small Lambda invocation. Which handoff is more efficient?

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

Explanation

Correct Answer

A:

A presigned S3 URL grants time-limited access to a specific object using the signer's permissions; in this scenario, return a short-lived presigned URL for the finished object, limiting permissions and expiration rather than proxying all file bytes.

Incorrect Answers

B:

AppSync supports GraphQL operations with resolvers that access data sources; it would target exposing a typed GraphQL interface to clients, while the question is about securely delivering a large generated report file.

C:

API Gateway can expose authenticated HTTP methods that route to a backed data service; its benefit is publishing filtered datasets through a governed API; that is different from securely delivering a large generated report file.

D:

A Lambda handler can validate inputs, query a datastore and serialize responses for API callers; the current need is for securely delivering a large generated report file, not hiding database credentials and SQL behind a service endpoint.

Question 296

Two departments operate independent Redshift compute environments but need consistent access to the producer's curated tables. What feature fits?

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

Explanation

Correct Answer

A:

Redshift data sharing lets authorized consumers query shared warehouse data without making full copies; in this scenario, create a datashare, authorize the consumer and grant access to shared objects while data remains managed by the producer.

Incorrect Answers

B:

Redshift Spectrum queries external data in S3 via catalog-backed external table definitions; its benefit is joining S3 lake datasets without first loading them into warehouse tables; that is different from exposing governed datasets to a separate Redshift consumer.

C:

A materialized view persists computed query results for repeated retrieval and planned refresh; the current need is for exposing governed datasets to a separate Redshift consumer, not caching a recurring expensive analytic result inside the warehouse.

D:

Redshift federated query reads supported operational relational databases from analytic SQL; this can support joining current operational rows from a supported database without bulk replication, but would not address the need for exposing governed datasets to a separate Redshift consumer.

Question 297

A governance team needs lasting centralized activity logs from several AWS accounts under controlled ownership. What setup fits?

  1. CloudTrail S3 data events
  2. CloudTrail management events
  3. CloudTrail Lake event data store
  4. CloudTrail trail to S3

Explanation

Correct Answer

D:

An organization trail can deliver selected CloudTrail records to a centralized S3 destination for retention and auditing; in this scenario, configure a multi-Region or organization trail as required and protect the destination with appropriate permissions and integrity controls.

Incorrect Answers

A:

CloudTrail data events can record object-level operations for selected S3 resources when configured; it would target auditing individual object reads in a sensitive lake, while the question is about consolidating API audit records from multiple accounts.

B:

Management events record control-plane API operations such as creating or updating AWS resources; its benefit is auditing who modified a Kinesis stream configuration; that is different from consolidating API audit records from multiple accounts.

C:

CloudTrail Lake stores queryable event data for SQL-based investigation over configured event sources; the current need is for consolidating API audit records from multiple accounts, not searching years of selected API activity with SQL.

Question 298

Data engineers need to inspect suspicious event intervals, test distributions and iterate on hypotheses before productionizing checks. What environment is appropriate?

  1. DataBrew missing-value transform
  2. SageMaker Data Wrangler transformations
  3. Notebook exploratory validation
  4. Athena conditional validation SQL

Explanation

Correct Answer

C:

Notebooks enable iterative code, plots and checks for exploratory analysis of sampled datasets; in this scenario, use an authorized notebook environment with sampled data, then move reliable rules into scheduled quality jobs.

Incorrect Answers

A:

DataBrew recipes support data cleaning operations for missing or inconsistent tabular field values; although useful for standardizing blanks without custom ETL code, it leaves the need for investigating anomalies with repeatable interactive code unmet.

B:

Data Wrangler offers visual data preparation transformations in supported SageMaker data workflows; it would target preparing features or exploratory datasets through a visual workflow, while the question is about investigating anomalies with repeatable interactive code.

D:

Athena SQL can detect rule violations using predicates and aggregations over cataloged data; the current need is for investigating anomalies with repeatable interactive code, not quantifying invalid rows before publishing an S3 dataset.

Question 299

An MSK topic has twelve partitions and a processing service needs parallel work without duplicate assignment within its consumer group. Which pattern fits?

  1. Kinesis partition key design
  2. Kafka consumer groups
  3. Kinesis enhanced fan-out
  4. Separate registered stream consumers
  5. SQS standard queue fan-in

Explanation

Correct Answer

B:

Kafka consumer groups divide topic partitions among members within a group while different groups read independently; in this scenario, use members of the same consumer group to split partitions; separate groups can independently consume the topic when required.

Incorrect Answers

A:

A Kinesis partition key determines shard assignment and per-key ordering for records; it would target spreading heavy producer traffic across shards, while the question is about scaling workers for one Kafka subscription.

C:

Enhanced fan-out gives registered consumers dedicated throughput for a Kinesis Data Streams shard; the current need is for scaling workers for one Kafka subscription, not isolating high-throughput independent stream readers.

D:

Applications can register distinct Kinesis stream consumers to obtain their own enhanced fan-out paths; this can support creating separately managed read identities for independent applications, but would not address the need for scaling workers for one Kafka subscription.

E:

A standard SQS queue buffers messages from multiple producers for a pool of competing worker consumers; this helps with decoupling many asynchronous producers from workers, not scaling workers for one Kafka subscription.

Question 300

Executives want each region on one row and each product class as a separate total column. Which transformation pattern fits?

  1. Redshift SQL window function
  2. SQL PIVOT transformation
  3. Athena SQL view
  4. SQL GROUP BY aggregate

Explanation

Correct Answer

B:

Pivoting turns distinct category values into separate columns for cross-tab reports in supported SQL engines; in this scenario, pivot category groups or use equivalent conditional aggregation according to the SQL dialect and expected categories.

Incorrect Answers

A:

Window functions calculate values across related rows while preserving row-level output; the current need is for presenting monthly category totals as columns, not computing a rolling average for each device.

C:

An Athena view stores a query definition for reuse over underlying tables; this helps with exposing a stable SQL projection over lake data, not presenting monthly category totals as columns.

D:

GROUP BY collapses input rows into groups and computes aggregate measures per distinct key; although useful for producing daily totals per store, it leaves the need for presenting monthly category totals as columns unmet.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests