About the Exam

Validates skills in core AWS data services, including ingesting and transforming data, orchestrating pipelines, designing data models, managing data lifecycles, and ensuring data quality. It is aimed at candidates with roughly 2 to 3 years of data engineering or data architecture experience and 1 to 2 years of hands-on AWS experience. Passing demonstrates the ability to implement data pipelines and to monitor, troubleshoot, and optimize cost and performance according to AWS best practices.

Exam Topics

  • Data Ingestion and Transformation34%
  • Data Store Management26%
  • Data Operations and Support22%
  • Data Security and Governance18%

How to Use This Practice Exam

  1. Browse — Read each question, select your answer, and reveal the explanation.
  2. Exam Mode — Simulate real exam conditions with a timed session and score report.
  3. Learn Mode — Spaced repetition schedules questions you struggle with for long-term retention.

Download the Full Exam PDF

Get every question and answer in a clean, printable PDF built for offline study. Purchase once, keep permanent access, and re-download the latest version anytime.

Last updated July 8, 2026 at 10:36 PM

Topic filter
Question status
Question sort
Questions per page

QuestionQ1

VerifiedData Operations and Support

A company uses an Amazon S3 bucket to integrate multiple data sources into a centralized data lake. The company must perform multiple transformations and data-cleaning processes on the data so that the data is accessible to business partners.

The company requires a solution that enables multiple business partners to run SQL queries on the centralized data lake during normal business hours.

Which solution meets these requirements MOST cost-effectively?

Explanation

AWS Glue Flex is appropriate for non-urgent batch transformations, such as processing the previous day’s data after business hours, and reduces ETL cost through flexible execution. Amazon Redshift Serverless automatically provides and scales query capacity, charging for the capacity used when queries run; this is more cost-effective than maintaining a provisioned Redshift cluster for a workload limited to business hours.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ2

VerifiedData Store Management

An ecommerce company gathers daily customer transaction logs in CSV format and stores those logs in Amazon S3. The company uses Amazon Athena to scan a subset of attributes from the logs on the same day that it receives each log.

Query times are growing because transaction volume is increasing. The company wants to improve query performance.

Which solution will satisfy these requirements with the SHORTEST query times?

Explanation

ORC is a columnar format, so Athena can read only the requested attributes and use predicate pushdown to skip unnecessary data blocks. Date partitioning reduces the data scanned for daily queries, and storing the data in multiple ORC files lets Athena distribute reads among multiple readers for greater parallelism. A single file per day limits that parallelism; JSON and Avro do not provide columnar column-pruning benefits.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ3

VerifiedData Operations and Support

A company operates a data-processing pipeline with several dozen steps. The pipeline must send real-time alerts whenever a step succeeds or fails. It uses a combination of Amazon S3 buckets, AWS Lambda functions, and AWS Step Functions state machines.

A data engineer needs to create a solution that monitors the entire pipeline.

Which solution meets these requirements?

Explanation

AWS Step Functions automatically sends execution-status-change events to Amazon EventBridge. An EventBridge rule can match successful and failed execution statuses and publish each matching event to an Amazon SNS topic, enabling real-time notifications without adding S3-based notification logic or relying on CloudTrail API events.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ4

VerifiedData Operations and Support

A data engineer must run a data-transformation job whenever a user adds a file to an Amazon S3 bucket. The job will run for under 1 minute. It must send its output to the data engineer in an email message. The data engineer expects users to add one file every hour of the day.

Which solution meets these requirements in the MOST operationally efficient way?

Explanation

Amazon S3 can invoke an AWS Lambda function when an object is created, enabling the transformation to run only when a file arrives. AWS Lambda is well suited to a sub-minute job and eliminates infrastructure polling and cluster management. The function can publish the transformed output to an Amazon SNS topic, and an email subscription to that topic delivers the output to the data engineer.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ5

VerifiedData Store Management

A data engineer uses an AWS Glue crawler to catalog data stored in an Amazon S3 bucket. The S3 bucket contains both .csv and .json files. The data engineer configured the crawler to omit the .json files from the catalog.

When the data engineer runs Amazon Athena queries, the queries also process the omitted .json files. The data engineer wants to resolve this issue and needs a solution that will not change the access requirements for the .csv files in the source S3 bucket.

Which solution meets this requirement with the SHORTEST query times?

Explanation

Amazon Athena does not honor AWS Glue crawler exclude patterns; it reads the files in the table's S3 location. Placing the .json files in a separate S3 path prevents Athena from scanning them while leaving access to the .csv files unchanged. AWS documents this exact CSV/JSON scenario and recommends placing files to be excluded in a different location.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!
Know a question that should be here? Contribute to this exam
Back home