Question 50
An analyst can connect to Redshift but receives permission denied when querying a finance table. Which authorization layer should change?
- Redshift dynamic data masking
- Redshift database role
- Redshift GRANT on schema objects
- Redshift row-level security policy
Explanation
Correct Answer
C:Redshift SQL grants determine which database principals can access schemas, tables and other objects; in this scenario, grant the necessary schema usage and table SELECT privileges to the database role rather than expanding AWS control-plane permissions.
Incorrect Answers
A:Redshift dynamic data masking can change the presentation of sensitive columns according to database policy; this helps with hiding customer email values from ordinary warehouse readers, not giving a reporting role SELECT on one curated table.
B:A Redshift database role groups database privileges that can be granted to multiple database users; although useful for administering common warehouse table permissions centrally, it leaves the need for giving a reporting role SELECT on one curated table unmet.
D:Redshift row-level security can restrict table rows returned for principals under applied policies; its benefit is limiting warehouse query results to a user's assigned tenant; that is different from giving a reporting role SELECT on one curated table.
Question 51
A daily Glue job scans the same S3 prefix and keeps loading yesterday's input again. Which capability can reduce duplicate batch ingestion?
- DMS table mapping rules
- Glue JDBC partition predicates
- S3 prefix-based ingestion
- Glue job bookmarks
Explanation
Correct Answer
D:Glue job bookmarks can track previously processed source data between supported job runs; in this scenario, enable and commit bookmarks in a supported ingestion path so later runs track processed input state.
Incorrect Answers
A:DMS table mappings select source schemas and tables and can apply supported transformations; this can support selecting only permitted source tables for replication, but would not address the need for avoiding the routine reread of already processed batches.
B:JDBC partitioning lets Glue spread relational reads over partitions instead of one serial scan; this helps with accelerating a large batch read of a numeric-keyed table, not avoiding the routine reread of already processed batches.
C:Explicit S3 prefixes narrow the object keys examined by a batch ETL input; although useful for scoping a daily batch to the intended landing folder, it leaves the need for avoiding the routine reread of already processed batches unmet.
Question 52
An analyst already belongs to a SageMaker Unified Studio project and discovers a catalog table that the project cannot query. The data owner must formally approve its use before access is granted. Which governed workflow fits?
- SageMaker Catalog asset subscription approval
- Purpose-based data minimization
- Data governance stewardship roles
- Retention schedule governance
Explanation
Correct Answer
A:SageMaker Unified Studio uses project-level data-asset subscription requests and approval workflows to grant governed Lake Formation table access; in this scenario, request the table subscription on behalf of the project and let its owner approve it, which then grants the required Lake Formation permissions to the project execution role.
Incorrect Answers
B:Data minimization limits collected and shared fields to those needed for the approved use case; although useful for reducing unnecessary exposure in downstream analytics, it leaves the need for approving a project subscription to a restricted catalog table unmet.
C:A governance framework assigns ownership and stewardship for datasets, definitions and access decisions; it would target establishing accountability for shared business datasets, while the question is about approving a project subscription to a restricted catalog table.
D:A retention schedule documents how long classes of data may be stored and when deletion or archiving is required; its benefit is aligning lake cleanup with legal data retention obligations; that is different from approving a project subscription to a restricted catalog table.
Question 53
An ETL job must upload objects encrypted with a customer-managed KMS key, and its role must be authorized to use that key. Which TWO configurations address both requirements? Choose TWO.
- S3 Bucket Key with SSE-KMS
- EBS volume encryption
- KMS key policy permissions
- RDS storage encryption
- SSE-KMS on S3 objects
Explanation
Correct Answers
C:Key policies define key-level permission foundations for KMS operations, alongside other applicable access policies; for the additional requirement of allowing authorized ETL roles to decrypt with an existing customer-managed key, check key policy and any permitted IAM grants for Decrypt, including key state, Region and relevant encryption context.
E:SSE-KMS uses an AWS KMS key for server-side encryption of objects stored in S3; in this scenario, configure SSE-KMS with an approved key and ensure producer and reader permissions cover required key operations.
Incorrect Answers
A:S3 Bucket Keys can reduce the number of KMS requests made for eligible SSE-KMS object operations; although useful for reducing KMS request costs for many encrypted objects, it leaves the need for enforcing controlled key usage for stored sensitive lake objects unmet.
B:EBS encryption protects supported block volumes at rest and in transit between instance and volume; it would target protecting EC2-attached processing scratch volumes, while the question is about enforcing controlled key usage for stored sensitive lake objects.
D:RDS storage encryption uses KMS integration to protect underlying database storage and supported related backups; the current need is for enforcing controlled key usage for stored sensitive lake objects, not encrypting a managed relational source's stored data.
Question 54
A three-month-old dataset is read twice a year yet must be retrievable with low latency when needed. Which S3 tier is appropriate?
- S3 Standard-IA
- S3 Glacier Flexible Retrieval
- S3 Glacier Deep Archive
- S3 Intelligent-Tiering
Explanation
Correct Answer
A:Standard-IA provides lower storage pricing for infrequently accessed objects with retrieval charges and minimum-duration constraints; in this scenario, choose an infrequent-access tier after comparing minimum-duration and retrieval costs against the expected access pattern.
Incorrect Answers
B:Glacier Flexible Retrieval offers archive storage with asynchronous retrieval options for infrequently needed objects; this can support archiving files when retrieval can take hours, but would not address the need for storing infrequent but quickly retrievable lake archives.
C:Glacier Deep Archive targets very rarely accessed data with long retrieval expectations; this helps with storing long-term archives at low storage cost, not storing infrequent but quickly retrievable lake archives.
D:Intelligent-Tiering monitors eligible object access and can move objects between access tiers automatically; although useful for handling unpredictable access frequency for retained objects, it leaves the need for storing infrequent but quickly retrievable lake archives unmet.
Question 55
A file landing in S3 must immediately send an object-created message directly to an existing SQS queue, without routing through a central event bus. Which S3 integration fits?
- Amazon EventBridge event pattern
- DynamoDB Streams Lambda trigger
- S3 EventBridge integration
- S3 Event Notifications
Explanation
Correct Answer
D:S3 event notifications publish supported object events to configured destinations such as SQS; in this scenario, configure object-created notifications, with an optional prefix filter, to the SQS destination and make consumers idempotent.
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 notifying a worker when a new object lands.
B:A Lambda event source mapping polls DynamoDB Streams and sends batches to the function; although useful for processing database changes as they occur, it leaves the need for notifying a worker when a new object lands unmet.
C:S3 can send supported bucket events to EventBridge for routing across multiple targets; it would target distributing new-object events through an event bus, while the question is about notifying a worker when a new object lands.
Question 56
An analyst needs to sample, transform, and inspect large lake datasets using Apache Spark interactively without provisioning an EC2 cluster. Which Athena feature fits?
- Athena SQL editor
- Athena workgroup controls
- Spark dataframe transformations
- Athena notebook Spark session
- Athena query-result S3 location
Explanation
Correct Answer
D:Athena notebooks can provide an interactive Apache Spark environment for data exploration; in this scenario, use a Spark-enabled Athena notebook and manage session capacity and output persistence for exploratory work.
Incorrect Answers
A:Athena SQL editor runs interactive SQL queries over configured catalogs and workgroups; although useful for running ad-hoc SQL against Glue catalog tables, it leaves the need for exploring large datasets with Spark in an Athena-integrated notebook unmet.
B:Athena workgroups provide query settings, usage controls and separation for groups of users; it would target limiting scanned query cost for exploratory users, while the question is about exploring large datasets with Spark in an Athena-integrated notebook.
C:Spark DataFrames provide distributed operations such as filters, joins and aggregations within supported notebook sessions; its benefit is exploring joins on a distributed lake dataset; that is different from 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 exploring large datasets with Spark in an Athena-integrated notebook.
Question 57
A data producer overwrites its daily S3 manifest with incorrect data, and operators need to recover the earlier revision. What protective bucket feature must have been enabled beforehand?
- S3 MFA Delete
- DynamoDB TTL attribute
- S3 delete-marker recovery
- S3 bucket versioning
- DynamoDB point-in-time recovery
Explanation
Correct Answer
D:Versioning preserves separate revisions of an object key to aid recovery from overwrites and deletes; in this scenario, enable versioning before the overwrite and retain noncurrent versions; prior versions cannot be invented after they were not recorded.
Incorrect Answers
A:MFA Delete adds an MFA requirement to certain versioning-related delete operations when configured by the root account; its benefit is adding strong protection to permanent deletion of object versions; that is different from recovering a previously overwritten object revision.
B:DynamoDB TTL uses a specified numeric epoch-seconds attribute to expire items asynchronously; the current need is for recovering a previously overwritten object revision, not removing stale session records from DynamoDB.
C:Deleting the current delete marker can reveal an older object version in a versioned bucket; this can support restoring a logically deleted current object, but would not address the need for recovering a previously overwritten object revision.
E:PITR supports continuous backups of a DynamoDB table within its supported recovery window; although useful for restoring a table after accidental bulk writes, it leaves the need for recovering a previously overwritten object revision unmet.
Question 58
Three Glue jobs need a shared private PostgreSQL connection definition and a database password that can rotate without editing the jobs. Which TWO components address these needs? Choose TWO.
- Glue JDBC connection definition
- Glue secret reference
- SageMaker domain unit
- SageMaker Catalog business asset
- SageMaker Unified Studio project
Explanation
Correct Answers
A:A Glue connection saves reusable endpoint, authentication and networking information for supported sources; in this scenario, create a suitable connection and reference it from jobs, ensuring the role and network path allow the configured access.
B:A Glue connection can use a secret for database credentials when configured and permitted; for the additional requirement of rotating shared source credentials without editing multiple jobs, reference credentials through a managed secret with controlled rotation rather than embedding passwords in job arguments.
Incorrect Answers
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 reusing database connectivity settings across Glue jobs.
D:SageMaker Catalog can provide business-oriented discovery and descriptions of governed data assets; its benefit is helping analysts discover an approved business dataset; that is different from reusing database connectivity settings across Glue jobs.
E:A Unified Studio project provides a collaborative workspace and governed resources for data and analytics activities; the current need is for reusing database connectivity settings across Glue jobs, not organizing a data team's approved work context.
Question 59
An ingest workflow must validate a file, choose one of two transformations, and retry recoverable failures using native AWS service steps. Which orchestration service is the most direct fit?
- EventBridge rule
- Lambda direct invocation
- AWS Step Functions state machine
- Glue workflow
- Amazon MWAA DAG
Explanation
Correct Answer
C:Step Functions coordinates service tasks with explicit states, branching, errors and retries; in this scenario, a state machine represents the branches and transitions in durable execution history, rather than embedding a fragile workflow inside one function.
Incorrect Answers
A:EventBridge matches emitted events and routes them to targets without tracking a multi-step workflow state; its benefit is routing a completed-upload event to the next service; that is different from orchestrating a serverless ETL with conditional paths.
B:One Lambda function can synchronously or asynchronously invoke another for small, bounded tasks; the current need is for orchestrating a serverless ETL with conditional paths, not initiating a single short helper action from code.
D:A Glue workflow links Glue triggers, crawlers and jobs into a managed ETL dependency sequence; this helps with sequencing a Glue-only crawl and transform chain, not orchestrating a serverless ETL with conditional paths.
E:Amazon MWAA provides managed Apache Airflow for dependency graphs expressed as DAGs; although useful for running an established Airflow-based cross-platform DAG, it leaves the need for orchestrating a serverless ETL with conditional paths unmet.
Question 60
A vendor allows only approved public source IPs; Glue connections originate from private subnets and access its public API. Which egress design helps?
- Security group inbound rule
- S3 gateway endpoint
- NAT gateway stable egress IP
- VPC interface endpoint
Explanation
Correct Answer
C:A NAT gateway in a public subnet can provide predictable public egress through its Elastic IP; in this scenario, route outbound traffic through the NAT gateway and register its Elastic IP with the vendor; retain private IP space for workers.
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 providing fixed outbound addresses for a private-subnet API poller 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 providing fixed outbound addresses for a private-subnet API poller.
D:An interface VPC endpoint offers private connectivity to supported AWS service APIs using endpoint ENIs; the current need is for providing fixed outbound addresses for a private-subnet API poller, not avoiding public internet transit for a supported AWS API.