Question 330
A crawler accidentally includes prior-year invoices stored under unrelated prefixes in the same S3 bucket. Which source configuration reduces contamination?
- S3 prefix-based ingestion
- Glue JDBC partition predicates
- DMS table mapping rules
- 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?
- Purpose-based data minimization
- Data governance stewardship roles
- SageMaker Catalog asset subscription approval
- 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?
- EBS volume encryption
- S3 Bucket Key with SSE-KMS
- RDS storage encryption
- KMS key policy permissions
- 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?
- S3 Standard-IA
- S3 Glacier Deep Archive
- S3 Glacier Flexible Retrieval
- 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?
- S3 Event Notifications
- S3 EventBridge integration
- Amazon EventBridge event pattern
- 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?
- Athena notebook Spark session
- Spark dataframe transformations
- Athena workgroup controls
- Athena query-result S3 location
- 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?
- DynamoDB point-in-time recovery
- S3 bucket versioning
- S3 delete-marker recovery
- S3 MFA Delete
- 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?
- Glue secret reference
- SageMaker Catalog business asset
- SageMaker domain unit
- SageMaker Unified Studio project
- 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?
- Amazon MWAA DAG
- AWS Step Functions state machine
- Lambda direct invocation
- EventBridge rule
- 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?
- Security group inbound rule
- NAT gateway stable egress IP
- VPC interface endpoint
- 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?
- Athena scanned-data metrics
- Kinesis shard throughput metrics
- Glue Spark stage metrics
- 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.