Question 330

A crawler accidentally includes prior-year invoices stored under unrelated prefixes in the same S3 bucket. Which source configuration reduces contamination?

  1. S3 prefix-based ingestion
  2. Glue JDBC partition predicates
  3. DMS table mapping rules
  4. Glue job bookmarks

Explanation

Correct Answer

A:

Explicit S3 prefixes narrow the object keys examined by a batch ETL input; in this scenario, restrict its include path to the intended dataset prefix and use exclusions when required to avoid unrelated objects.

Incorrect Answers

B:

JDBC partitioning lets Glue spread relational reads over partitions instead of one serial scan; its benefit is accelerating a large batch read of a numeric-keyed table; that is different from scoping a daily batch to the intended landing folder.

C:

DMS table mappings select source schemas and tables and can apply supported transformations; the current need is for scoping a daily batch to the intended landing folder, not selecting only permitted source tables for replication.

D:

Glue job bookmarks can track previously processed source data between supported job runs; this can support avoiding the routine reread of already processed batches, but would not address the need for scoping a daily batch to the intended landing folder.

Question 331

A company expires every S3 object after thirty days, accidentally deleting records subject to seven-year financial retention rules. What governance control is missing?

  1. Purpose-based data minimization
  2. Data governance stewardship roles
  3. SageMaker Catalog asset subscription approval
  4. Retention schedule governance

Explanation

Correct Answer

D:

A retention schedule documents how long classes of data may be stored and when deletion or archiving is required; in this scenario, classify datasets by retention obligations and translate those schedules into compatible storage lifecycle and hold policies.

Incorrect Answers

A:

Data minimization limits collected and shared fields to those needed for the approved use case; its benefit is reducing unnecessary exposure in downstream analytics; that is different from aligning lake cleanup with legal data retention obligations.

B:

A governance framework assigns ownership and stewardship for datasets, definitions and access decisions; the current need is for aligning lake cleanup with legal data retention obligations, not establishing accountability for shared business datasets.

C:

SageMaker Unified Studio uses project-level data-asset subscription requests and approval workflows to grant governed Lake Formation table access; this can support approving a project subscription to a restricted catalog table, but would not address the need for aligning lake cleanup with legal data retention obligations.

Question 332

A custom EC2 ETL worker writes temporary sensitive data to its EBS volume and must protect that storage. Which encryption feature applies?

  1. EBS volume encryption
  2. S3 Bucket Key with SSE-KMS
  3. RDS storage encryption
  4. KMS key policy permissions
  5. SSE-KMS on S3 objects

Explanation

Correct Answer

A:

EBS encryption protects supported block volumes at rest and in transit between instance and volume; in this scenario, use encrypted EBS volumes and snapshots with an authorized KMS key and protect any exported application data separately.

Incorrect Answers

B:

S3 Bucket Keys can reduce the number of KMS requests made for eligible SSE-KMS object operations; this can support reducing KMS request costs for many encrypted objects, but would not address the need for protecting EC2-attached processing scratch volumes.

C:

RDS storage encryption uses KMS integration to protect underlying database storage and supported related backups; this helps with encrypting a managed relational source's stored data, not protecting EC2-attached processing scratch volumes.

D:

Key policies define key-level permission foundations for KMS operations, alongside other applicable access policies; although useful for allowing authorized ETL roles to decrypt with an existing customer-managed key, it leaves the need for protecting EC2-attached processing scratch volumes unmet.

E:

SSE-KMS uses an AWS KMS key for server-side encryption of objects stored in S3; it would target enforcing controlled key usage for stored sensitive lake objects, while the question is about protecting EC2-attached processing scratch volumes.

Question 333

Twenty-year audit images will almost never be accessed, and restoration may take many hours. Which tier is appropriate?

  1. S3 Standard-IA
  2. S3 Glacier Deep Archive
  3. S3 Glacier Flexible Retrieval
  4. S3 Intelligent-Tiering

Explanation

Correct Answer

B:

Glacier Deep Archive targets very rarely accessed data with long retrieval expectations; in this scenario, use Deep Archive for long retention and plan retrieval workflows and minimum storage-duration charges.

Incorrect Answers

A:

Standard-IA provides lower storage pricing for infrequently accessed objects with retrieval charges and minimum-duration constraints; although useful for storing infrequent but quickly retrievable lake archives, it leaves the need for storing long-term archives at low storage cost unmet.

C:

Glacier Flexible Retrieval offers archive storage with asynchronous retrieval options for infrequently needed objects; its benefit is archiving files when retrieval can take hours; that is different from storing long-term archives at low storage cost.

D:

Intelligent-Tiering monitors eligible object access and can move objects between access tiers automatically; the current need is for storing long-term archives at low storage cost, not handling unpredictable access frequency for retained objects.

Question 334

A DynamoDB row update must launch a change-enrichment function without scanning the table. What integration should be configured?

  1. S3 Event Notifications
  2. S3 EventBridge integration
  3. Amazon EventBridge event pattern
  4. DynamoDB Streams Lambda trigger

Explanation

Correct Answer

D:

A Lambda event source mapping polls DynamoDB Streams and sends batches to the function; in this scenario, turn on Streams and create a Lambda event source mapping; choose a stream view that contains the fields required by the function.

Incorrect Answers

A:

S3 event notifications publish supported object events to configured destinations such as SQS; its benefit is notifying a worker when a new object lands; that is different from processing database changes as they occur.

B:

S3 can send supported bucket events to EventBridge for routing across multiple targets; the current need is for processing database changes as they occur, not distributing new-object events through an event bus.

C:

EventBridge rules match event fields and route matching events to target services; this can support routing only events that satisfy structured filters, but would not address the need for processing database changes as they occur.

Question 335

A notebook must join several sizable S3 sources and inspect a sample of resulting rows. What Spark abstraction fits?

  1. Athena notebook Spark session
  2. Spark dataframe transformations
  3. Athena workgroup controls
  4. Athena query-result S3 location
  5. Athena SQL editor

Explanation

Correct Answer

B:

Spark DataFrames provide distributed operations such as filters, joins and aggregations within supported notebook sessions; in this scenario, use DataFrame operations with explicit schema and partition choices rather than collecting the whole dataset to the notebook driver.

Incorrect Answers

A:

Athena notebooks can provide an interactive Apache Spark environment for data exploration; the current need is for exploring joins on a distributed lake dataset, not exploring large datasets with Spark in an Athena-integrated notebook.

C:

Athena workgroups provide query settings, usage controls and separation for groups of users; this helps with limiting scanned query cost for exploratory users, not exploring joins on a distributed lake dataset.

D:

Athena SQL query results are written to an S3 output location subject to workgroup and permission settings; although useful for troubleshooting a query that fails before returning rows, it leaves the need for exploring joins on a distributed lake dataset unmet.

E:

Athena SQL editor runs interactive SQL queries over configured catalogs and workgroups; it would target running ad-hoc SQL against Glue catalog tables, while the question is about exploring joins on a distributed lake dataset.

Question 336

A buggy deployment corrupts many DynamoDB items, and engineers need to recover the table to a time just before the incident. What feature fits?

  1. DynamoDB point-in-time recovery
  2. S3 bucket versioning
  3. S3 delete-marker recovery
  4. S3 MFA Delete
  5. DynamoDB TTL attribute

Explanation

Correct Answer

A:

PITR supports continuous backups of a DynamoDB table within its supported recovery window; in this scenario, restore from a point-in-time backup to a new table and plan cutover or reconciliation rather than relying on TTL.

Incorrect Answers

B:

Versioning preserves separate revisions of an object key to aid recovery from overwrites and deletes; although useful for recovering a previously overwritten object revision, it leaves the need for restoring a table after accidental bulk writes unmet.

C:

Deleting the current delete marker can reveal an older object version in a versioned bucket; it would target restoring a logically deleted current object, while the question is about restoring a table after accidental bulk writes.

D:

MFA Delete adds an MFA requirement to certain versioning-related delete operations when configured by the root account; its benefit is adding strong protection to permanent deletion of object versions; that is different from restoring a table after accidental bulk writes.

E:

DynamoDB TTL uses a specified numeric epoch-seconds attribute to expire items asynchronously; the current need is for restoring a table after accidental bulk writes, not removing stale session records from DynamoDB.

Question 337

Analysts need a shared project containing approved assets and tools rather than exchanging account-wide credentials. Which organizational concept fits?

  1. Glue secret reference
  2. SageMaker Catalog business asset
  3. SageMaker domain unit
  4. SageMaker Unified Studio project
  5. Glue JDBC connection definition

Explanation

Correct Answer

D:

A Unified Studio project provides a collaborative workspace and governed resources for data and analytics activities; in this scenario, provision a project with appropriate membership and resources under the domain's governance boundaries.

Incorrect Answers

A:

A Glue connection can use a secret for database credentials when configured and permitted; its benefit is rotating shared source credentials without editing multiple jobs; that is different from organizing a data team's approved work context.

B:

SageMaker Catalog can provide business-oriented discovery and descriptions of governed data assets; the current need is for organizing a data team's approved work context, not helping analysts discover an approved business dataset.

C:

Domain units can organize teams and governance boundaries within a SageMaker Unified Studio domain; this can support delegating catalog administration to a business unit, but would not address the need for organizing a data team's approved work context.

E:

A Glue connection saves reusable endpoint, authentication and networking information for supported sources; although useful for reusing database connectivity settings across Glue jobs, it leaves the need for organizing a data team's approved work context unmet.

Question 338

A partner upload notification should initiate one transformation job when its event fields match. Which integration is most direct?

  1. Amazon MWAA DAG
  2. AWS Step Functions state machine
  3. Lambda direct invocation
  4. EventBridge rule
  5. Glue workflow

Explanation

Correct Answer

D:

EventBridge matches emitted events and routes them to targets without tracking a multi-step workflow state; in this scenario, create an event pattern and target; use a separate orchestration layer only if multi-step state and retries become necessary.

Incorrect Answers

A:

Amazon MWAA provides managed Apache Airflow for dependency graphs expressed as DAGs; this helps with running an established Airflow-based cross-platform DAG, not routing a completed-upload event to the next service.

B:

Step Functions coordinates service tasks with explicit states, branching, errors and retries; although useful for orchestrating a serverless ETL with conditional paths, it leaves the need for routing a completed-upload event to the next service unmet.

C:

One Lambda function can synchronously or asynchronously invoke another for small, bounded tasks; it would target initiating a single short helper action from code, while the question is about routing a completed-upload event to the next service.

E:

A Glue workflow links Glue triggers, crawlers and jobs into a managed ETL dependency sequence; the current need is for routing a completed-upload event to the next service, not sequencing a Glue-only crawl and transform chain.

Question 339

An EMR workload in isolated subnets needs S3 access but no general internet egress. Which endpoint should be used?

  1. Security group inbound rule
  2. NAT gateway stable egress IP
  3. VPC interface endpoint
  4. S3 gateway endpoint

Explanation

Correct Answer

D:

An S3 gateway endpoint adds a VPC route to S3 through the AWS private network path; in this scenario, associate a gateway endpoint with the relevant route tables and ensure S3 and endpoint policies permit the required object calls.

Incorrect Answers

A:

A security group rule allows specified inbound protocols, ports and sources to a resource interface; the current need is for reading S3 objects from a private subnet without a NAT gateway, not allowing a Glue job to reach a private JDBC database.

B:

A NAT gateway in a public subnet can provide predictable public egress through its Elastic IP; this can support providing fixed outbound addresses for a private-subnet API poller, but would not address the need for reading S3 objects from a private subnet without a NAT gateway.

C:

An interface VPC endpoint offers private connectivity to supported AWS service APIs using endpoint ENIs; this helps with avoiding public internet transit for a supported AWS API, not reading S3 objects from a private subnet without a NAT gateway.

Question 340

A Redshift join becomes slow after a new fact table is added, and analysts suspect poor distribution choices. What tool helps?

  1. Athena scanned-data metrics
  2. Kinesis shard throughput metrics
  3. Glue Spark stage metrics
  4. Redshift EXPLAIN plan

Explanation

Correct Answer

D:

EXPLAIN shows a planned Redshift query strategy, including joins, scans and potential data movement; in this scenario, inspect the query plan for redistribution and scan behavior before changing sort or distribution layouts.

Incorrect Answers

A:

Athena query execution statistics report the volume of data scanned and runtime behavior; it would target explaining a sudden rise in query cost, while the question is about identifying costly redistribution in warehouse SQL.

B:

Stream shard metrics reveal write or read throughput saturation and throttling within shard limits; its benefit is diagnosing write throttling on a hot partition key; that is different from identifying costly redistribution in warehouse SQL.

C:

Spark task and stage metrics reveal shuffle size, skew, spill and slow executors; the current need is for identifying costly redistribution in warehouse SQL, not identifying why one Spark stage dominates the run.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests