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?
- Step Functions with EventBridge rule
- Amazon MWAA DAG schedule
- EventBridge Scheduler
- 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?
- Embedding model version consistency
- Vector similarity metric
- Bedrock Knowledge Bases ingestion
- 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?
- AWS DMS change data capture
- AWS DMS Schema Conversion
- Schema assessment report
- 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?
- EMR step submission
- Athena StartQueryExecution
- Step Functions Glue run-job integration
- Redshift Data API execution
- 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?
- Crawler exclusion pattern
- Custom Glue classifier
- Glue crawler schema inference
- 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?
- Amazon Macie S3 scan
- Sovereignty-aware backup location
- S3 replication Region restriction
- 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?
- S3 same-Region replication
- S3 Replication Time Control
- DynamoDB global tables
- RDS Multi-AZ deployment
- 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?
- SageMaker domain unit hierarchy
- SageMaker Unified Studio project membership
- IAM managed versus inline policy
- Service-linked IAM role
- SageMaker Unified Studio domain
- 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?
- DynamoDB composite key
- DynamoDB global secondary index
- Redshift sort key selection
- 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?
- Amazon S3 data lake
- Amazon RDS relational database
- Amazon DynamoDB table
- 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?
- Lambda per-record enrichment
- Redshift SQL transformations
- Amazon EMR customized frameworks
- 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.