Question 120

An ETL process already lives in AWS Glue and simply needs to run every six hours. Which native scheduling feature can initiate it?

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

Explanation

Correct Answer

D:

Glue scheduled triggers start designated Glue jobs according to a configured schedule; in this scenario, use a scheduled Glue trigger for the job; it is adequate when no complex cross-service dependencies are required.

Incorrect Answers

A:

An EventBridge scheduled rule can initiate a Step Functions state machine execution; the current need is for running a single Glue ETL job on a fixed cadence, not periodically invoking a multi-step serverless data workflow.

B:

An Airflow DAG schedule defines recurring execution of an orchestration graph in Amazon MWAA; this can support scheduling a dependency-aware Airflow workflow, but would not address the need for running a single Glue ETL job on a fixed cadence.

C:

EventBridge Scheduler invokes supported targets on configured schedules with time-zone options; this helps with launching a daily transform at a specified local time, not running a single Glue ETL job on a fixed cadence.

Question 121

A support assistant needs governed semantic retrieval over approved S3 manuals without building an embedding pipeline from scratch. What feature helps?

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

Explanation

Correct Answer

C:

Bedrock Knowledge Bases can ingest supported sources, create embeddings and support retrieval workflows; in this scenario, configure a knowledge base with a supported data source and vector store, then synchronize documents for retrieval.

Incorrect Answers

A:

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 preparing a managed document corpus for retrieval-augmented generation.

B:

Cosine similarity and other distance functions rank embeddings by geometric closeness under chosen semantics; the current need is for preparing a managed document corpus for retrieval-augmented generation, not selecting a compatible similarity function for embeddings.

D:

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 preparing a managed document corpus for retrieval-augmented generation.

Question 122

An initial copy of a high-traffic database takes days, but target rows must catch up before switchover. Which DMS feature helps?

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

Explanation

Correct Answer

A:

DMS CDC transfers ongoing supported source changes after baseline replication to keep a target synchronized; in this scenario, capture and apply transaction changes from an appropriate log position, monitoring replication latency before cutover.

Incorrect Answers

B:

AWS DMS Schema Conversion assesses and converts supported database schema objects between engines; although useful for migrating proprietary database objects to a different engine, it leaves the need for minimizing database migration cutover downtime unmet.

C:

A schema assessment highlights compatibility gaps and constructs requiring manual remediation during migration; it would target identifying unsupported conversion features early, while the question is about minimizing database migration cutover downtime.

D:

Validating row counts, checksums and business invariants detects differences between migrated and original data; its benefit is proving a migrated target is consistent before traffic moves; that is different from minimizing database migration cutover downtime.

Question 123

A publish task must run only when a Glue transformation succeeds, not merely when its start request is accepted. Which integration helps?

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

Explanation

Correct Answer

C:

A Step Functions Glue service integration can start a job and wait for its run to finish; in this scenario, use the supported synchronous Glue task pattern so the state machine advances based on job completion.

Incorrect Answers

A:

EMR steps run specified data-processing tasks such as Spark jobs on a compatible cluster; its benefit is launching Spark processing on an existing EMR cluster; that is different from coordinating downstream steps after a Glue job completes.

B:

Athena APIs can start SQL queries and return query execution IDs for polling results; the current need is for coordinating downstream steps after a Glue job completes, not running a governed S3 SQL check from code.

D:

The Redshift Data API can submit SQL statements to compatible Redshift environments using authorized calls; this helps with invoking warehouse SQL without maintaining a persistent client connection, not coordinating downstream steps after a Glue job completes.

E:

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 coordinating downstream steps after a Glue job completes unmet.

Question 124

A crawler treats a vendor's custom pipe-delimited records as one column instead of structured fields. What crawler enhancement helps?

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

Explanation

Correct Answer

B:

A custom classifier influences how Glue crawlers recognize certain input formats and extract schemas; in this scenario, configure an appropriate classifier for the file structure rather than altering query code to accept a malformed table.

Incorrect Answers

A:

Crawler exclusions prevent matching paths and files from being considered during discovery; the current need is for correctly recognizing a nonstandard delimited text format, not excluding temporary and rejected files from inferred tables.

C:

A Glue crawler inspects supported source data and infers table structures for the Data Catalog; this helps with discovering schemas from newly landed files, not correctly recognizing a nonstandard delimited text format.

D:

Crawler change policies control how discovered schema differences update catalog objects; although useful for preventing surprise schema rewrites from new vendor files, it leaves the need for correctly recognizing a nonstandard delimited text format unmet.

Question 125

A data residency policy permits storage only in two named Regions, but an S3 replication rule points to a third. What should be corrected?

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

Explanation

Correct Answer

C:

Replication configuration determines which destination bucket and Region receive copies of source objects; in this scenario, remove or change the disallowed replication destination and verify other backups, exports and access paths follow residency policy.

Incorrect Answers

A:

Macie sensitive-data discovery can identify candidate personal data and generate findings for supported S3 objects; this helps with finding accidentally uploaded personal identifiers in an approved bucket, not preventing regulated object copies from entering a prohibited Region.

B:

Backup and restore destinations must respect organization-specific data sovereignty and retention obligations; although useful for keeping disaster-recovery data inside approved jurisdictions, it leaves the need for preventing regulated object copies from entering a prohibited Region unmet.

D:

AWS Config records supported resource configurations and changes to help evaluate resource-state compliance; its benefit is identifying when a bucket replication policy changed; that is different from preventing regulated object copies from entering a prohibited Region.

Question 126

Policy requires all copies to remain in one Region, but separate departmental buckets must receive approved objects. Which replication arrangement fits?

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

Explanation

Correct Answer

A:

Same-Region Replication copies eligible objects between buckets within one Region for supported uses; in this scenario, use SRR with explicit replication rules and permissions while ensuring destinations and logs remain inside the allowed Region.

Incorrect Answers

B:

S3 Replication Time Control provides an SLA-backed replication-time target and metrics for eligible replication rules; it would target monitoring time-bounded cross-Region replication, while the question is about maintaining a second bucket copy without crossing residency boundaries.

C:

Global tables replicate DynamoDB table items across selected AWS Regions for multi-Region application access; its benefit is providing regional writes and resilient access to key-value data; that is different from maintaining a second bucket copy without crossing residency boundaries.

D:

An RDS Multi-AZ deployment can provide a synchronized standby or multi-node configuration for availability; the current need is for maintaining a second bucket copy without crossing residency boundaries, not maintaining database availability through a single-AZ outage.

E:

Cross-Region Replication asynchronously copies eligible objects between buckets in different AWS Regions; this can support protecting approved datasets with a second-Region object copy, but would not address the need for maintaining a second bucket copy without crossing residency boundaries.

Question 127

Finance and supply-chain teams require distinct delegated catalog administrators but use the same Unified Studio domain. What construct helps?

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

Explanation

Correct Answer

A:

Domain units group related teams and help structure delegated governance within a domain; in this scenario, create domain units and assign suitable ownership to keep stewardship responsibilities organized.

Incorrect Answers

B:

Project membership controls collaboration and access within the project's governed workspace; its benefit is limiting an analyst's membership to one approved project; that is different from separating business-unit stewardship responsibilities.

C:

Customer-managed IAM policies can be versioned and reused across roles, unlike role-specific inline policies; the current need is for separating business-unit stewardship responsibilities, not reusing controlled permissions across multiple data pipeline roles.

D:

Service-linked roles are IAM roles predefined for supported AWS services to act on an account's behalf; this can support allowing an AWS managed service to perform its own required operations, but would not address the need for separating business-unit stewardship responsibilities.

E:

A Unified Studio domain defines an overarching environment for governed data and analytics workspaces; this helps with establishing a common organizational boundary for governed projects, not separating business-unit stewardship responsibilities.

F:

An identity-based IAM policy grants allowed API actions to a user, group or role subject to other policy checks; although useful for authorizing a data-processing role for a narrow AWS API action, it leaves the need for separating business-unit stewardship responsibilities unmet.

Question 128

A Redshift fact table is commonly filtered on event date and repeatedly scans irrelevant blocks. Which physical design can help?

  1. DynamoDB composite key
  2. DynamoDB global secondary index
  3. Redshift sort key selection
  4. RDS secondary B-tree index

Explanation

Correct Answer

C:

Redshift sort keys can improve block elimination for queries filtering on correlated column values; in this scenario, choose a sort strategy aligned with selective date filters and examine query plans and maintenance trade-offs.

Incorrect Answers

A:

DynamoDB partition and sort keys efficiently organize related items for a known query access pattern; this can support retrieving the latest orders for one account, but would not address the need for reducing scanned blocks for frequent time-range queries.

B:

A GSI supports queries using an alternate partition/sort key without changing the table's primary key; this helps with querying DynamoDB items by a second business identifier, not reducing scanned blocks for frequent time-range queries.

D:

A relational secondary index can accelerate selective predicates when its maintenance cost is justified; it would target accelerating indexed equality lookups on a relational table, while the question is about reducing scanned blocks for frequent time-range queries.

Question 129

An application retrieves a shopping-cart record by customer ID thousands of times per second with minimal operations. Which data store fits?

  1. Amazon S3 data lake
  2. Amazon RDS relational database
  3. Amazon DynamoDB table
  4. Amazon Redshift warehouse

Explanation

Correct Answer

C:

DynamoDB provides managed key-value and document access at low latency using partition keys and indexes; in this scenario, design keys around item access patterns and use DynamoDB's managed scaling instead of analytical scan-oriented storage.

Incorrect Answers

A:

S3 stores durable objects of varying formats economically without requiring an operational database schema; this can support retaining raw petabyte-scale historical source files, but would not address the need for serving predictable millisecond item lookups at high request volume.

B:

Amazon RDS manages supported relational engines for transactional workloads using SQL and constraints; this helps with supporting ACID transactions across related business records, not serving predictable millisecond item lookups at high request volume.

D:

Redshift offers columnar analytic processing for large SQL aggregations over warehouse datasets; it would target executing repeated analytical joins over large fact tables, while the question is about serving predictable millisecond item lookups at high request volume.

Question 130

A workload needs a custom Spark distribution configuration and side libraries not available in the managed Glue runtime. Which environment fits?

  1. Lambda per-record enrichment
  2. Redshift SQL transformations
  3. Amazon EMR customized frameworks
  4. AWS Glue Spark ETL

Explanation

Correct Answer

C:

Amazon EMR provides controlled Hadoop and Spark clusters with configurable frameworks and libraries; in this scenario, use EMR to select appropriate cluster software and instance resources, accepting greater configuration and operations responsibility.

Incorrect Answers

A:

Lambda is suited to short event-driven transformations within its runtime and resource limits; although useful for enriching individual small records after an event, it leaves the need for running specialized large-scale distributed transformations unmet.

B:

Redshift SQL operations can transform warehouse-resident data without exporting it to a separate engine; it would target reshaping existing warehouse tables in place, while the question is about running specialized large-scale distributed transformations.

D:

AWS Glue provides managed Spark-based ETL jobs and integration with the Data Catalog; the current need is for running specialized large-scale distributed transformations, not running recurring serverless-style Spark transformations.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests