Question 210

An EventBridge rule intermittently fails to invoke a restricted endpoint and losing these failed events is unacceptable. What safeguard helps?

  1. SNS subscription filtering
  2. CloudWatch alarm evaluation periods
  3. CloudWatch alarm composite
  4. EventBridge failed-event DLQ

Explanation

Correct Answer

D:

A rule target can use an SQS dead-letter queue to retain undelivered events after retry exhaustion; in this scenario, configure a target dead-letter queue and investigate delivery failures with suitable permissions and alerts.

Incorrect Answers

A:

SNS subscription filter policies select which topic messages are delivered to specific subscribers; its benefit is routing alerts by data pipeline ownership; that is different from capturing notifications that fail delivery to the target.

B:

Alarm evaluation periods govern how many datapoints must breach a threshold before the alarm changes state; the current need is for capturing notifications that fail delivery to the target, not suppressing alerts for harmless single-sample spikes.

C:

Composite alarms combine the states of other alarms using logical expressions; this can support paging only when error rate and backlog are both unhealthy, but would not address the need for capturing notifications that fail delivery to the target.

Question 211

A Glue process downloads all invoices and then drops all but one region. What optimization cuts extraction work?

  1. Vectorized dataframe operation
  2. Set membership lookup
  3. Chunked iterator processing
  4. SQL predicate pushdown

Explanation

Correct Answer

D:

Predicate pushdown filters eligible records near the source and reduces data moved for ETL; in this scenario, push a supported region predicate into the source read, avoiding transfer and processing of rows that will be discarded.

Incorrect Answers

A:

Vectorized data operations process columns or batches without per-row interpreter overhead; the current need is for avoiding needless rows in a JDBC extraction, not reducing per-row Python transformation overhead.

B:

Hash-based set membership generally offers efficient repeated presence checks in memory; this can support accelerating millions of repeated key lookups, but would not address the need for avoiding needless rows in a JDBC extraction.

C:

Chunking processes large inputs in bounded pieces rather than loading an entire dataset into memory; this helps with reading multi-gigabyte files within tight memory limits, not avoiding needless rows in a JDBC extraction.

Question 212

A production data connector uses a database credential that security policy requires changing regularly. Which managed service can coordinate rotation?

  1. Lambda execution IAM role
  2. Glue job service role
  3. Secrets Manager scheduled rotation
  4. STS AssumeRole for cross-account processing

Explanation

Correct Answer

C:

Secrets Manager rotation workflows can update supported credentials and associated secret versions; in this scenario, configure supported rotation and validate the database-side update and application retrieval behavior before enforcing the schedule.

Incorrect Answers

A:

Lambda assumes its execution role to call permitted AWS APIs during function invocation; it would target granting Lambda controlled read access to one S3 prefix, while the question is about rotating a relational password without embedding updates in code.

B:

A Glue job runs with an IAM role that authorizes its data, catalog and logging operations; its benefit is enabling Glue to access controlled catalog and S3 resources; that is different from rotating a relational password without embedding updates in code.

D:

STS AssumeRole returns temporary credentials for an authorized role trust relationship; this can support allowing an ETL account to read a partner account's approved objects, but would not address the need for rotating a relational password without embedding updates in code.

Question 213

An existing Airflow DAG loads, validates, and publishes datasets each morning, honoring task dependencies. Where should the recurrence be defined?

  1. Step Functions with EventBridge rule
  2. Glue job trigger schedule
  3. Amazon MWAA DAG schedule
  4. EventBridge Scheduler

Explanation

Correct Answer

C:

An Airflow DAG schedule defines recurring execution of an orchestration graph in Amazon MWAA; in this scenario, set the DAG timetable in the managed Airflow environment so the whole task graph is scheduled together.

Incorrect Answers

A:

An EventBridge scheduled rule can initiate a Step Functions state machine execution; although useful for periodically invoking a multi-step serverless data workflow, it leaves the need for scheduling a dependency-aware Airflow workflow unmet.

B:

Glue scheduled triggers start designated Glue jobs according to a configured schedule; it would target running a single Glue ETL job on a fixed cadence, while the question is about scheduling a dependency-aware Airflow workflow.

D:

EventBridge Scheduler invokes supported targets on configured schedules with time-zone options; the current need is for scheduling a dependency-aware Airflow workflow, not launching a daily transform at a specified local time.

Question 214

A vector store ranks semantically related messages incorrectly after switching embedding models. What configuration must be checked?

  1. Text embedding creation
  2. Vector similarity metric
  3. Bedrock Knowledge Bases ingestion
  4. Embedding model version consistency

Explanation

Correct Answer

B:

Cosine similarity and other distance functions rank embeddings by geometric closeness under chosen semantics; in this scenario, match the distance metric and vector normalization behavior to the embedding model and index configuration.

Incorrect Answers

A:

Embedding models encode text into numeric vectors that represent semantic features for comparison; this helps with converting product descriptions to vectors for similarity retrieval, not selecting a compatible similarity function for embeddings.

C:

Bedrock Knowledge Bases can ingest supported sources, create embeddings and support retrieval workflows; it would target preparing a managed document corpus for retrieval-augmented generation, while the question is about selecting a compatible similarity function for embeddings.

D:

Mixing embeddings from incompatible model versions can make distance comparisons unreliable; its benefit is preserving comparability after an embedding-model upgrade; that is different from selecting a compatible similarity function for embeddings.

Question 215

A database conversion generates warnings about source functions that have no target-engine equivalents. Which migration output should engineers review?

  1. AWS DMS Schema Conversion
  2. Schema assessment report
  3. AWS DMS change data capture
  4. Dual-write migration validation

Explanation

Correct Answer

B:

A schema assessment highlights compatibility gaps and constructs requiring manual remediation during migration; in this scenario, use assessment and conversion reports to prioritize unsupported objects and avoid assuming all vendor SQL translates automatically.

Incorrect Answers

A:

AWS DMS Schema Conversion assesses and converts supported database schema objects between engines; its benefit is migrating proprietary database objects to a different engine; that is different from identifying unsupported conversion features early.

C:

DMS CDC transfers ongoing supported source changes after baseline replication to keep a target synchronized; this can support minimizing database migration cutover downtime, but would not address the need for identifying unsupported conversion features early.

D:

Validating row counts, checksums and business invariants detects differences between migrated and original data; this helps with proving a migrated target is consistent before traffic moves, not identifying unsupported conversion features early.

Question 216

A serverless workflow must issue a short warehouse SQL statement and check its result asynchronously. Which interface helps?

  1. Step Functions Glue run-job integration
  2. Glue job start API
  3. Athena StartQueryExecution
  4. Redshift Data API execution
  5. EMR step submission

Explanation

Correct Answer

D:

The Redshift Data API can submit SQL statements to compatible Redshift environments using authorized calls; in this scenario, submit a statement through the Redshift Data API and poll or use events for completion, with appropriate database authorization.

Incorrect Answers

A:

A Step Functions Glue service integration can start a job and wait for its run to finish; this helps with coordinating downstream steps after a Glue job completes, not invoking warehouse SQL without maintaining a persistent client connection.

B:

The Glue StartJobRun API launches a configured ETL job and returns a run identifier for tracking; although useful for starting Glue ETL from an application workflow, it leaves the need for invoking warehouse SQL without maintaining a persistent client connection unmet.

C:

Athena APIs can start SQL queries and return query execution IDs for polling results; it would target running a governed S3 SQL check from code, while the question is about invoking warehouse SQL without maintaining a persistent client connection.

E:

EMR steps run specified data-processing tasks such as Spark jobs on a compatible cluster; the current need is for invoking warehouse SQL without maintaining a persistent client connection, not launching Spark processing on an existing EMR cluster.

Question 217

A partner occasionally changes optional fields, and automatic crawler updates break downstream contracts. What configuration should be reviewed?

  1. Glue crawler schema inference
  2. Crawler exclusion pattern
  3. Crawler schema change policy
  4. Custom Glue classifier

Explanation

Correct Answer

C:

Crawler change policies control how discovered schema differences update catalog objects; in this scenario, set crawler update behavior conservatively and validate schema changes through an approval path before publishing them.

Incorrect Answers

A:

A Glue crawler inspects supported source data and infers table structures for the Data Catalog; although useful for discovering schemas from newly landed files, it leaves the need for preventing surprise schema rewrites from new vendor files unmet.

B:

Crawler exclusions prevent matching paths and files from being considered during discovery; it would target excluding temporary and rejected files from inferred tables, while the question is about preventing surprise schema rewrites from new vendor files.

D:

A custom classifier influences how Glue crawlers recognize certain input formats and extract schemas; the current need is for preventing surprise schema rewrites from new vendor files, not correctly recognizing a nonstandard delimited text format.

Question 218

A security review must determine when an S3 bucket's configuration drifted from its approved residency settings. Which AWS service helps?

  1. Amazon Macie S3 scan
  2. S3 replication Region restriction
  3. AWS Config configuration history
  4. Sovereignty-aware backup location

Explanation

Correct Answer

C:

AWS Config records supported resource configurations and changes to help evaluate resource-state compliance; in this scenario, review AWS Config history and evaluations for recorded resource changes; pair with CloudTrail when caller attribution is needed.

Incorrect Answers

A:

Macie sensitive-data discovery can identify candidate personal data and generate findings for supported S3 objects; its benefit is finding accidentally uploaded personal identifiers in an approved bucket; that is different from identifying when a bucket replication policy changed.

B:

Replication configuration determines which destination bucket and Region receive copies of source objects; the current need is for identifying when a bucket replication policy changed, not preventing regulated object copies from entering a prohibited Region.

D:

Backup and restore destinations must respect organization-specific data sovereignty and retention obligations; this helps with keeping disaster-recovery data inside approved jurisdictions, not identifying when a bucket replication policy changed.

Question 219

An international application needs a DynamoDB data set available for local writes in two permitted Regions. Which design fits?

  1. S3 same-Region replication
  2. S3 Replication Time Control
  3. RDS Multi-AZ deployment
  4. S3 cross-Region replication
  5. DynamoDB global tables

Explanation

Correct Answer

E:

Global tables replicate DynamoDB table items across selected AWS Regions for multi-Region application access; in this scenario, use appropriately configured global tables and understand asynchronous cross-Region conflict resolution and consistency behavior.

Incorrect Answers

A:

Same-Region Replication copies eligible objects between buckets within one Region for supported uses; the current need is for providing regional writes and resilient access to key-value data, not maintaining a second bucket copy without crossing residency boundaries.

B:

S3 Replication Time Control provides an SLA-backed replication-time target and metrics for eligible replication rules; this can support monitoring time-bounded cross-Region replication, but would not address the need for providing regional writes and resilient access to key-value data.

C:

An RDS Multi-AZ deployment can provide a synchronized standby or multi-node configuration for availability; this helps with maintaining database availability through a single-AZ outage, not providing regional writes and resilient access to key-value data.

D:

Cross-Region Replication asynchronously copies eligible objects between buckets in different AWS Regions; although useful for protecting approved datasets with a second-Region object copy, it leaves the need for providing regional writes and resilient access to key-value data unmet.

Question 220

A contractor should work with only the marketing analytics project, not every asset in the company domain. What membership scope fits?

  1. SageMaker Unified Studio project membership
  2. SageMaker domain unit hierarchy
  3. SageMaker Unified Studio domain
  4. Service-linked IAM role
  5. IAM managed versus inline policy
  6. IAM identity policy attachment

Explanation

Correct Answer

A:

Project membership controls collaboration and access within the project's governed workspace; in this scenario, add the contractor to the specific project with authorized membership and check the resulting data permissions.

Incorrect Answers

B:

Domain units group related teams and help structure delegated governance within a domain; this helps with separating business-unit stewardship responsibilities, not limiting an analyst's membership to one approved project.

C:

A Unified Studio domain defines an overarching environment for governed data and analytics workspaces; although useful for establishing a common organizational boundary for governed projects, it leaves the need for limiting an analyst's membership to one approved project unmet.

D:

Service-linked roles are IAM roles predefined for supported AWS services to act on an account's behalf; it would target allowing an AWS managed service to perform its own required operations, while the question is about limiting an analyst's membership to one approved project.

E:

Customer-managed IAM policies can be versioned and reused across roles, unlike role-specific inline policies; its benefit is reusing controlled permissions across multiple data pipeline roles; that is different from limiting an analyst's membership to one approved project.

F:

An identity-based IAM policy grants allowed API actions to a user, group or role subject to other policy checks; the current need is for limiting an analyst's membership to one approved project, not authorizing a data-processing role for a narrow AWS API action.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests