Question 30

An application must initiate an existing AWS Glue ETL job from code and obtain its run identifier. Which direct AWS API operation fits?

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

Explanation

Correct Answer

E:

The Glue StartJobRun API launches a configured ETL job and returns a run identifier for tracking; in this scenario, start the Glue job through its supported service integration and track the run status before releasing dependent results.

Incorrect Answers

A:

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 starting Glue ETL from an application workflow.

B:

A Step Functions Glue service integration can start a job and wait for its run to finish; although useful for coordinating downstream steps after a Glue job completes, it leaves the need for starting Glue ETL from an application workflow unmet.

C:

EMR steps run specified data-processing tasks such as Spark jobs on a compatible cluster; it would target launching Spark processing on an existing EMR cluster, while the question is about starting Glue ETL from an application workflow.

D:

Athena APIs can start SQL queries and return query execution IDs for polling results; its benefit is running a governed S3 SQL check from code; that is different from starting Glue ETL from an application workflow.

Question 31

A new partner delivers semistructured S3 files daily and manual table creation is error-prone. Which tool can discover metadata?

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

Explanation

Correct Answer

A:

A Glue crawler inspects supported source data and infers table structures for the Data Catalog; in this scenario, configure a crawler with the appropriate source path and classifier behavior, then review inferred types and partitions.

Incorrect Answers

B:

Crawler change policies control how discovered schema differences update catalog objects; it would target preventing surprise schema rewrites from new vendor files, while the question is about discovering schemas from newly landed files.

C:

Crawler exclusions prevent matching paths and files from being considered during discovery; its benefit is excluding temporary and rejected files from inferred tables; that is different from discovering schemas from newly landed files.

D:

A custom classifier influences how Glue crawlers recognize certain input formats and extract schemas; the current need is for discovering schemas from newly landed files, not correctly recognizing a nonstandard delimited text format.

Question 32

A regulated ingestion zone may contain national ID values mixed into CSV files after a new vendor integration. What detection tool helps?

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

Explanation

Correct Answer

C:

Macie sensitive-data discovery can identify candidate personal data and generate findings for supported S3 objects; in this scenario, run scoped sensitive-data discovery and use findings to triage quarantine, masking or access-policy remediation.

Incorrect Answers

A:

Backup and restore destinations must respect organization-specific data sovereignty and retention obligations; its benefit is keeping disaster-recovery data inside approved jurisdictions; that is different from finding accidentally uploaded personal identifiers in an approved bucket.

B:

Replication configuration determines which destination bucket and Region receive copies of source objects; the current need is for finding accidentally uploaded personal identifiers in an approved bucket, not preventing regulated object copies from entering a prohibited Region.

D:

AWS Config records supported resource configurations and changes to help evaluate resource-state compliance; this helps with identifying when a bucket replication policy changed, not finding accidentally uploaded personal identifiers in an approved bucket.

Question 33

An analytics lake must maintain a recoverable S3 copy in a second permitted AWS Region for disaster recovery. Which replication configuration meets the geographic requirement?

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

Explanation

Correct Answer

D:

Cross-Region Replication asynchronously copies eligible objects between buckets in different AWS Regions; in this scenario, configure replication with the necessary IAM role and destination settings, then assess handling of existing objects and replication lag.

Incorrect Answers

A:

An RDS Multi-AZ deployment can provide a synchronized standby or multi-node configuration for availability; the current need is for protecting approved datasets with a second-Region object copy, not maintaining database availability through a single-AZ outage.

B:

Global tables replicate DynamoDB table items across selected AWS Regions for multi-Region application access; this can support providing regional writes and resilient access to key-value data, but would not address the need for protecting approved datasets with a second-Region object copy.

C:

Same-Region Replication copies eligible objects between buckets within one Region for supported uses; this helps with maintaining a second bucket copy without crossing residency boundaries, not protecting approved datasets with a second-Region object copy.

E:

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 protecting approved datasets with a second-Region object copy.

Question 34

A company wants a managed analytics environment in which separate teams create controlled projects under shared governance. Which container fits?

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

Explanation

Correct Answer

D:

A Unified Studio domain defines an overarching environment for governed data and analytics workspaces; in this scenario, define an appropriately governed domain before allocating its organizational units and collaborative projects.

Incorrect Answers

A:

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 establishing a common organizational boundary for governed projects.

B:

Domain units group related teams and help structure delegated governance within a domain; this helps with separating business-unit stewardship responsibilities, not establishing a common organizational boundary for governed projects.

C:

Project membership controls collaboration and access within the project's governed workspace; although useful for limiting an analyst's membership to one approved project, it leaves the need for establishing a common organizational boundary for governed projects unmet.

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 establishing a common organizational boundary for governed projects.

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 establishing a common organizational boundary for governed projects, not authorizing a data-processing role for a narrow AWS API action.

Question 35

A service repeatedly lists a customer's purchases ordered by creation time without scanning unrelated customers. What key design helps?

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

Explanation

Correct Answer

B:

DynamoDB partition and sort keys efficiently organize related items for a known query access pattern; in this scenario, use customer ID as partition key and timestamp or order ID as sort key, with expected hot-key demand assessed.

Incorrect Answers

A:

A GSI supports queries using an alternate partition/sort key without changing the table's primary key; it would target querying DynamoDB items by a second business identifier, while the question is about retrieving the latest orders for one account.

C:

A relational secondary index can accelerate selective predicates when its maintenance cost is justified; the current need is for retrieving the latest orders for one account, not accelerating indexed equality lookups on a relational table.

D:

Redshift sort keys can improve block elimination for queries filtering on correlated column values; this can support reducing scanned blocks for frequent time-range queries, but would not address the need for retrieving the latest orders for one account.

Question 36

A business-intelligence team runs complex joins and grouped reports across billions of sales rows, not low-latency single-row updates. Which datastore fits?

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

Explanation

Correct Answer

D:

Redshift offers columnar analytic processing for large SQL aggregations over warehouse datasets; in this scenario, model data for analytic SQL in Redshift; columnar processing and warehouse optimizations favor scans and aggregations.

Incorrect Answers

A:

S3 stores durable objects of varying formats economically without requiring an operational database schema; it would target retaining raw petabyte-scale historical source files, while the question is about executing repeated analytical joins over large fact tables.

B:

DynamoDB provides managed key-value and document access at low latency using partition keys and indexes; its benefit is serving predictable millisecond item lookups at high request volume; that is different from executing repeated analytical joins over large fact tables.

C:

Amazon RDS manages supported relational engines for transactional workloads using SQL and constraints; the current need is for executing repeated analytical joins over large fact tables, not supporting ACID transactions across related business records.

Question 37

A data team wants to join and reshape large S3 files using Spark without maintaining EC2 clusters. Which service is the natural fit?

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

Explanation

Correct Answer

A:

AWS Glue provides managed Spark-based ETL jobs and integration with the Data Catalog; in this scenario, develop a Glue Spark job and use the catalog for dataset metadata; AWS operates the underlying job infrastructure.

Incorrect Answers

B:

Amazon EMR provides controlled Hadoop and Spark clusters with configurable frameworks and libraries; this can support running specialized large-scale distributed transformations, but would not address the need for running recurring serverless-style Spark transformations.

C:

Lambda is suited to short event-driven transformations within its runtime and resource limits; this helps with enriching individual small records after an event, not running recurring serverless-style Spark transformations.

D:

Redshift SQL operations can transform warehouse-resident data without exporting it to a separate engine; although useful for reshaping existing warehouse tables in place, it leaves the need for running recurring serverless-style Spark transformations unmet.

Question 38

Finance wants interactive revenue-by-region charts with controlled reader access and scheduled refreshes. Which AWS analytics interface fits?

  1. Athena result visualization downstream
  2. QuickSight SPICE dataset
  3. DataBrew visual profiling
  4. Amazon QuickSight dashboard

Explanation

Correct Answer

D:

QuickSight builds governed analytic dashboards and visualizations from configured data sources; in this scenario, model datasets and analyses in QuickSight and publish dashboards to authorized readers without distributing raw SQL credentials.

Incorrect Answers

A:

Athena produces query result datasets that can be connected to separate reporting and visualization tools; the current need is for publishing metrics to business users through dashboards, not preparing lake queries for a dashboard dataset.

B:

SPICE provides in-memory accelerated storage for supported QuickSight analytic datasets; this can support speeding repeated dashboard interactions on imported results, but would not address the need for publishing metrics to business users through dashboards.

C:

DataBrew's visual interface can inspect column distributions and transformations before publishing cleaned output; this helps with exploring raw field problems interactively, not publishing metrics to business users through dashboards.

Question 39

An Airflow DAG is visible but its expected schedule creates no runs after an environment change. Which log source is relevant?

  1. MWAA worker task log
  2. Step Functions failed state details
  3. MWAA scheduler log
  4. Glue job run metrics

Explanation

Correct Answer

C:

Scheduler logs show why Apache Airflow DAG runs may not be getting scheduled; in this scenario, inspect MWAA scheduler logs, DAG parsing and timetable settings before troubleshooting task-specific execution code.

Incorrect Answers

A:

Worker task logs record errors raised while an Airflow operator executes; although useful for diagnosing a failed task with running schedulers, it leaves the need for diagnosing DAG runs that never enter the queue unmet.

B:

Execution details identify state-level errors and task transitions in a Step Functions workflow; it would target locating which branch and integration caused a state-machine failure, while the question is about diagnosing DAG runs that never enter the queue.

D:

Glue job run data includes execution duration, failures and relevant service metrics for job diagnosis; the current need is for diagnosing DAG runs that never enter the queue, not determining whether an ETL problem is resource-related.

Question 40

Several engineers edit a shared Glue script and unreviewed changes frequently break production jobs. Which development workflow helps?

  1. Git pull request review
  2. Unit tests with fixture data
  3. Immutable deployment artifact
  4. CI pipeline integration tests

Explanation

Correct Answer

A:

Git branches and pull requests support code review before changes merge into a shared baseline; in this scenario, use branches with peer review and required tests before merging, making intended changes and reviewers auditable.

Incorrect Answers

B:

Unit tests validate transformation functions against representative inputs and expected results; the current need is for reviewing ETL changes before production release, not catching mapping regressions before deployment.

C:

Versioned packages and immutable images let a pipeline redeploy the exact artifact tested previously; this can support preventing drift between staging and production ETL code, but would not address the need for reviewing ETL changes before production release.

D:

Integration tests exercise real interfaces between components in an isolated environment; this helps with validating source-to-target contracts before release, not reviewing ETL changes before production release.

AWS Certified Data Engineer - Associate DEA-C01 Practice Tests