CLOUDPUZ
AWS Certified
Data Engineer - Associate
DEA-C01
150 Practice Questions
Answers & Detailed Explanations
2 practice tests • 75 questions per test • English
Independent study material for certification preparation. This publication is not affiliated with or endorsed by Amazon Web
Services. AWS and related names are trademarks of their respective owners.
Practice questions for learning and revision; no claim is made that these are live certification exam questions.
CLOUDPUZ | DEA-C01 | Practice questions & answers 1
, How to use this question bank
Complete each practice test before consulting its answer key. Select one answer unless the
question specifies multiple answers. Review the explanations for every option, then revisit the
topics you missed.
Each test has three sections: Questions, Quick answer key, and Answers with explanations.
Question numbering restarts at 1 for Test 2.
The questions and explanations retain the content of the Cloudpuz source question banks. Official reference links supplied
in those banks are preserved for further study. Service capabilities and exam objectives may evolve.
CLOUDPUZ | DEA-C01 | Practice questions & answers 2
, Practice Test 1
Questions 1-75
Question 1 | Data Operations and Support
A multi-tenant dataset needs quality checks that reflect both large and small tenants. Which
sampling approach should be considered?
A. Sample only rows with no missing values
B. Stratified sampling by tenant or relevant population groups
C. Sample only the largest tenant
D. Choose the newest file regardless of its population
Select 1 answer.
Question 2 | Data Operations and Support
An Athena query scans an entire date-partitioned dataset although it needs one day. What should
be checked?
A. The number of notification subscribers
B. Only the font size of the SQL editor
C. Whether the query applies a usable predicate to the partition column
D. Whether the bucket name includes the date
Select 1 answer.
Question 3 | Data Operations and Support
A Glue job suddenly takes much longer after input files become heavily skewed. Increasing
workers provides little benefit. What is the likely next optimization?
A. Rename the output database
B. Redistribute skewed work or change the transformation strategy
C. Increase worker count indefinitely without investigating tasks
D. Disable every data quality rule permanently
Select 1 answer.
CLOUDPUZ | DEA-C01 | Practice questions & answers 3
, Question 4 | Data Ingestion and Transformation
A team must recreate the same pipeline infrastructure in development and production with
reviewable changes. What should it use?
A. Version-controlled infrastructure as code with environment parameters
B. One shared administrator password
C. Manual console changes documented only in screenshots
D. Separate untracked scripts edited in each account
Select 1 answer.
Question 5 | Data Security and Governance
A team encrypts S3 data at rest but sends source records to an API over plaintext HTTP. What gap
remains?
A. At-rest encryption automatically encrypts every external network connection
B. The object names are too long
C. No gap exists because encryption was enabled somewhere
D. Data in transit is not protected by the at-rest encryption setting
Select 1 answer.
Question 6 | Data Ingestion and Transformation
A data job has two independent source loads that can run concurrently, followed by one join step.
How should the workflow be modeled?
A. Repeat the slower load until the faster one times out
B. Run all three steps independently with no dependencies
C. Run the loads in parallel and join only after both succeed
D. Run the join before either load finishes
Select 1 answer.
Question 7 | Data Operations and Support
A customer reference in an orders dataset must exist in the customer master. Which quality
check addresses this?
A. Counting total columns in the orders table
B. Compression-ratio validation only
C. Referential integrity validation against the master keys
D. Testing whether order IDs are alphabetically sorted
Select 1 answer.
CLOUDPUZ | DEA-C01 | Practice questions & answers 4
AWS Certified
Data Engineer - Associate
DEA-C01
150 Practice Questions
Answers & Detailed Explanations
2 practice tests • 75 questions per test • English
Independent study material for certification preparation. This publication is not affiliated with or endorsed by Amazon Web
Services. AWS and related names are trademarks of their respective owners.
Practice questions for learning and revision; no claim is made that these are live certification exam questions.
CLOUDPUZ | DEA-C01 | Practice questions & answers 1
, How to use this question bank
Complete each practice test before consulting its answer key. Select one answer unless the
question specifies multiple answers. Review the explanations for every option, then revisit the
topics you missed.
Each test has three sections: Questions, Quick answer key, and Answers with explanations.
Question numbering restarts at 1 for Test 2.
The questions and explanations retain the content of the Cloudpuz source question banks. Official reference links supplied
in those banks are preserved for further study. Service capabilities and exam objectives may evolve.
CLOUDPUZ | DEA-C01 | Practice questions & answers 2
, Practice Test 1
Questions 1-75
Question 1 | Data Operations and Support
A multi-tenant dataset needs quality checks that reflect both large and small tenants. Which
sampling approach should be considered?
A. Sample only rows with no missing values
B. Stratified sampling by tenant or relevant population groups
C. Sample only the largest tenant
D. Choose the newest file regardless of its population
Select 1 answer.
Question 2 | Data Operations and Support
An Athena query scans an entire date-partitioned dataset although it needs one day. What should
be checked?
A. The number of notification subscribers
B. Only the font size of the SQL editor
C. Whether the query applies a usable predicate to the partition column
D. Whether the bucket name includes the date
Select 1 answer.
Question 3 | Data Operations and Support
A Glue job suddenly takes much longer after input files become heavily skewed. Increasing
workers provides little benefit. What is the likely next optimization?
A. Rename the output database
B. Redistribute skewed work or change the transformation strategy
C. Increase worker count indefinitely without investigating tasks
D. Disable every data quality rule permanently
Select 1 answer.
CLOUDPUZ | DEA-C01 | Practice questions & answers 3
, Question 4 | Data Ingestion and Transformation
A team must recreate the same pipeline infrastructure in development and production with
reviewable changes. What should it use?
A. Version-controlled infrastructure as code with environment parameters
B. One shared administrator password
C. Manual console changes documented only in screenshots
D. Separate untracked scripts edited in each account
Select 1 answer.
Question 5 | Data Security and Governance
A team encrypts S3 data at rest but sends source records to an API over plaintext HTTP. What gap
remains?
A. At-rest encryption automatically encrypts every external network connection
B. The object names are too long
C. No gap exists because encryption was enabled somewhere
D. Data in transit is not protected by the at-rest encryption setting
Select 1 answer.
Question 6 | Data Ingestion and Transformation
A data job has two independent source loads that can run concurrently, followed by one join step.
How should the workflow be modeled?
A. Repeat the slower load until the faster one times out
B. Run all three steps independently with no dependencies
C. Run the loads in parallel and join only after both succeed
D. Run the join before either load finishes
Select 1 answer.
Question 7 | Data Operations and Support
A customer reference in an orders dataset must exist in the customer master. Which quality
check addresses this?
A. Counting total columns in the orders table
B. Compression-ratio validation only
C. Referential integrity validation against the master keys
D. Testing whether order IDs are alphabetically sorted
Select 1 answer.
CLOUDPUZ | DEA-C01 | Practice questions & answers 4
