Question 240
A compliance archive is almost never read and a retrieval wait of several hours is acceptable. Which storage class fits?
- S3 Glacier Deep Archive
- S3 Standard-IA
- S3 Intelligent-Tiering
- S3 Glacier Flexible Retrieval
Explanation
Correct Answer
D:Glacier Flexible Retrieval offers archive storage with asynchronous retrieval options for infrequently needed objects; in this scenario, transition data to archive storage under a lifecycle policy, documenting restoration times and minimum retention costs.
Incorrect Answers
A:Glacier Deep Archive targets very rarely accessed data with long retrieval expectations; the current need is for archiving files when retrieval can take hours, not storing long-term archives at low storage cost.
B:Standard-IA provides lower storage pricing for infrequently accessed objects with retrieval charges and minimum-duration constraints; this can support storing infrequent but quickly retrievable lake archives, but would not address the need for archiving files when retrieval can take hours.
C:Intelligent-Tiering monitors eligible object access and can move objects between access tiers automatically; this helps with handling unpredictable access frequency for retained objects, not archiving files when retrieval can take hours.
Question 241
An object arrival must notify separate indexing and governance workflows using distinct filtering rules. Which publication path is appropriate?
- Amazon EventBridge event pattern
- S3 Event Notifications
- S3 EventBridge integration
- DynamoDB Streams Lambda trigger
Explanation
Correct Answer
C:S3 can send supported bucket events to EventBridge for routing across multiple targets; in this scenario, enable S3 events to EventBridge, then create rules for each consumer and its independent destination.
Incorrect Answers
A:EventBridge rules match event fields and route matching events to target services; this helps with routing only events that satisfy structured filters, not distributing new-object events through an event bus.
B:S3 event notifications publish supported object events to configured destinations such as SQS; although useful for notifying a worker when a new object lands, it leaves the need for distributing new-object events through an event bus unmet.
D:A Lambda event source mapping polls DynamoDB Streams and sends batches to the function; its benefit is processing database changes as they occur; that is different from distributing new-object events through an event bus.
Question 242
A development team has unpredictable Athena scans and needs configurable query usage controls apart from production users. What resource helps?
- Athena workgroup controls
- Spark dataframe transformations
- Athena SQL editor
- Athena notebook Spark session
- Athena query-result S3 location
Explanation
Correct Answer
A:Athena workgroups provide query settings, usage controls and separation for groups of users; in this scenario, place development queries in a workgroup with appropriate configuration, permissions and bytes-scanned limits.
Incorrect Answers
B:Spark DataFrames provide distributed operations such as filters, joins and aggregations within supported notebook sessions; it would target exploring joins on a distributed lake dataset, while the question is about limiting scanned query cost for exploratory users.
C:Athena SQL editor runs interactive SQL queries over configured catalogs and workgroups; its benefit is running ad-hoc SQL against Glue catalog tables; that is different from limiting scanned query cost for exploratory users.
D:Athena notebooks can provide an interactive Apache Spark environment for data exploration; the current need is for limiting scanned query cost for exploratory users, not exploring large datasets with Spark in an Athena-integrated notebook.
E:Athena SQL query results are written to an S3 output location subject to workgroup and permission settings; this can support troubleshooting a query that fails before returning rows, but would not address the need for limiting scanned query cost for exploratory users.
Question 243
A session table needs automatic eventual deletion of items after their expiration timestamps. Which table capability fits?
- DynamoDB point-in-time recovery
- S3 bucket versioning
- S3 MFA Delete
- S3 delete-marker recovery
- DynamoDB TTL attribute
Explanation
Correct Answer
E:DynamoDB TTL uses a specified numeric epoch-seconds attribute to expire items asynchronously; in this scenario, configure TTL on a numeric epoch-seconds field; expired items may remain visible temporarily before background deletion.
Incorrect Answers
A:PITR supports continuous backups of a DynamoDB table within its supported recovery window; its benefit is restoring a table after accidental bulk writes; that is different from removing stale session records from DynamoDB.
B:Versioning preserves separate revisions of an object key to aid recovery from overwrites and deletes; the current need is for removing stale session records from DynamoDB, not recovering a previously overwritten object revision.
C:MFA Delete adds an MFA requirement to certain versioning-related delete operations when configured by the root account; this can support adding strong protection to permanent deletion of object versions, but would not address the need for removing stale session records from DynamoDB.
D:Deleting the current delete marker can reveal an older object version in a versioned bucket; this helps with restoring a logically deleted current object, not removing stale session records from DynamoDB.
Question 244
Finance analysts can find a raw table path but cannot tell its owner, meaning or usage terms. Which catalog experience addresses this?
- SageMaker Unified Studio project
- SageMaker Catalog business asset
- SageMaker domain unit
- Glue JDBC connection definition
- Glue secret reference
Explanation
Correct Answer
B:SageMaker Catalog can provide business-oriented discovery and descriptions of governed data assets; in this scenario, publish assets with descriptive business metadata and access workflows so users discover appropriate datasets by purpose.
Incorrect Answers
A:A Unified Studio project provides a collaborative workspace and governed resources for data and analytics activities; this helps with 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; it would target delegating catalog administration to a business unit, while the question is about helping analysts discover an approved business dataset.
D:A Glue connection saves reusable endpoint, authentication and networking information for supported sources; its benefit is reusing database connectivity settings across Glue jobs; that is different from helping analysts discover an approved business dataset.
E:A Glue connection can use a secret for database credentials when configured and permitted; the current need is for helping analysts discover an approved business dataset, not rotating shared source credentials without editing multiple jobs.
Question 245
A pipeline consists exclusively of a schema crawler followed by two dependent Glue jobs. Which native orchestration construct is appropriate?
- Glue workflow
- Amazon MWAA DAG
- AWS Step Functions state machine
- EventBridge rule
- Lambda direct invocation
Explanation
Correct Answer
A:A Glue workflow links Glue triggers, crawlers and jobs into a managed ETL dependency sequence; in this scenario, a Glue workflow can track job and crawler dependencies without introducing a separate general-purpose orchestration service.
Incorrect Answers
B:Amazon MWAA provides managed Apache Airflow for dependency graphs expressed as DAGs; the current need is for sequencing a Glue-only crawl and transform chain, not running an established Airflow-based cross-platform DAG.
C:Step Functions coordinates service tasks with explicit states, branching, errors and retries; this can support orchestrating a serverless ETL with conditional paths, but would not address the need for sequencing a Glue-only crawl and transform chain.
D:EventBridge matches emitted events and routes them to targets without tracking a multi-step workflow state; this helps with routing a completed-upload event to the next service, not sequencing a Glue-only crawl and transform chain.
E:One Lambda function can synchronously or asynchronously invoke another for small, bounded tasks; although useful for initiating a single short helper action from code, it leaves the need for sequencing a Glue-only crawl and transform chain unmet.
Question 246
A private ETL subnet must call Secrets Manager without using NAT or traversing a public gateway. Which networking feature fits?
- Security group inbound rule
- S3 gateway endpoint
- NAT gateway stable egress IP
- VPC interface endpoint
Explanation
Correct Answer
D:An interface VPC endpoint offers private connectivity to supported AWS service APIs using endpoint ENIs; in this scenario, add the Secrets Manager interface endpoint, private DNS as appropriate and suitable security-group rules for the HTTPS connection.
Incorrect Answers
A:A security group rule allows specified inbound protocols, ports and sources to a resource interface; although useful for allowing a Glue job to reach a private JDBC database, it leaves the need for avoiding public internet transit for a supported AWS API unmet.
B:An S3 gateway endpoint adds a VPC route to S3 through the AWS private network path; it would target reading S3 objects from a private subnet without a NAT gateway, while the question is about avoiding public internet transit for a supported AWS API.
C:A NAT gateway in a public subnet can provide predictable public egress through its Elastic IP; its benefit is providing fixed outbound addresses for a private-subnet API poller; that is different from avoiding public internet transit for a supported AWS API.
Question 247
An Athena dashboard's data scanned triples after a query change although row counts barely change. Which metric pinpoints the issue?
- Glue Spark stage metrics
- Redshift EXPLAIN plan
- Kinesis shard throughput metrics
- Athena scanned-data metrics
Explanation
Correct Answer
D:Athena query execution statistics report the volume of data scanned and runtime behavior; in this scenario, compare bytes scanned and query plans, then assess partition filtering and column projection to limit irrelevant files.
Incorrect Answers
A:Spark task and stage metrics reveal shuffle size, skew, spill and slow executors; this can support identifying why one Spark stage dominates the run, but would not address the need for explaining a sudden rise in query cost.
B:EXPLAIN shows a planned Redshift query strategy, including joins, scans and potential data movement; this helps with identifying costly redistribution in warehouse SQL, not explaining a sudden rise in query cost.
C:Stream shard metrics reveal write or read throughput saturation and throttling within shard limits; although useful for diagnosing write throttling on a hot partition key, it leaves the need for explaining a sudden rise in query cost unmet.
Question 248
An external API changes its access token periodically, and deployed ingestion code must not contain the secret. Which service is appropriate?
- API Gateway with Lambda
- Checkpointed API pagination
- Lambda scheduled API poller
- Secrets Manager for API tokens
Explanation
Correct Answer
D:Secrets Manager stores API credentials and can support rotation workflows for supported secrets; in this scenario, retrieve a secret at runtime using scoped permissions, and implement the provider-specific refresh or rotation workflow.
Incorrect Answers
A:API Gateway accepts HTTPS requests and can invoke Lambda for backend request processing; this can support exposing a managed HTTPS entry point for ingested events, but would not address the need for managing third-party API credentials without embedding them in code.
B:A durable cursor or page token enables an ingestion process to resume an API listing incrementally; this helps with resuming paginated ingestion after partial failures, not managing third-party API credentials without embedding them in code.
C:Lambda code can invoke third-party REST APIs on a schedule when network access is available; although useful for polling a vendor API at bounded intervals, it leaves the need for managing third-party API credentials without embedding them in code unmet.
Question 249
An analytics API repeatedly reads seldom-changing dimension values from RDS and can tolerate cache misses. Which layer helps?
- Aurora PostgreSQL pgvector HNSW index
- Amazon OpenSearch Service search index
- Amazon ElastiCache cache
- Amazon MemoryDB for Redis
Explanation
Correct Answer
C:ElastiCache provides managed in-memory caching to accelerate access to data stored durably elsewhere; in this scenario, cache hot lookup results in ElastiCache while retaining the relational database as authoritative on a miss or invalidation.
Incorrect Answers
A:Aurora PostgreSQL with supported pgvector functionality can index embeddings for approximate similarity search; although useful for finding similar embeddings within relational application data, it leaves the need for caching read-heavy reference values without changing the source of truth unmet.
B:OpenSearch Service supports full-text search and search-oriented indexing of documents; it would target enabling relevance-ranked keyword search over ingested articles, while the question is about caching read-heavy reference values without changing the source of truth.
D:MemoryDB offers a durable Redis-compatible in-memory database for low-latency key-value access; the current need is for caching read-heavy reference values without changing the source of truth, not combining Redis-compatible operations with a durable primary database.
Question 250
Before activating change capture, analysts need all existing rows from a supported transactional database copied to the destination. Which DMS task mode fits?
- Amazon AppFlow
- S3 object batch processing with Glue
- AWS DMS full load
- AWS Glue JDBC connection
Explanation
Correct Answer
C:AWS DMS can copy existing database tables as an initial migration or replication phase; in this scenario, full load initializes target tables from source contents; later CDC can handle subsequent modifications separately.
Incorrect Answers
A:AppFlow transfers data between supported SaaS applications and AWS destinations with managed connectors; this can support importing CRM objects from a supported SaaS application, but would not address the need for taking a one-time baseline of source tables.
B:Glue batch ETL processes stored S3 objects when a scheduled job runs against their paths; this helps with reprocessing a monthly collection of stored flat files, not taking a one-time baseline of source tables.
D:Glue can read JDBC-backed sources through a connection with network and credential settings; it would target extracting scheduled rows from a private relational database, while the question is about taking a one-time baseline of source tables.