Question 210
An EventBridge rule intermittently fails to invoke a restricted endpoint and losing these failed events is unacceptable. What safeguard helps?
- SNS subscription filtering
- CloudWatch alarm evaluation periods
- CloudWatch alarm composite
- 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?
- Vectorized dataframe operation
- Set membership lookup
- Chunked iterator processing
- 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?
- Lambda execution IAM role
- Glue job service role
- Secrets Manager scheduled rotation
- 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?
- Step Functions with EventBridge rule
- Glue job trigger schedule
- Amazon MWAA DAG schedule
- 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?
- Text embedding creation
- Vector similarity metric
- Bedrock Knowledge Bases ingestion
- 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?
- AWS DMS Schema Conversion
- Schema assessment report
- AWS DMS change data capture
- 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?
- Step Functions Glue run-job integration
- Glue job start API
- Athena StartQueryExecution
- Redshift Data API execution
- 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?
- Glue crawler schema inference
- Crawler exclusion pattern
- Crawler schema change policy
- 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?
- Amazon Macie S3 scan
- S3 replication Region restriction
- AWS Config configuration history
- 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?
- S3 same-Region replication
- S3 Replication Time Control
- RDS Multi-AZ deployment
- S3 cross-Region replication
- 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?
- SageMaker Unified Studio project membership
- SageMaker domain unit hierarchy
- SageMaker Unified Studio domain
- Service-linked IAM role
- IAM managed versus inline policy
- 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.