AWSCertified Data Engineer - Associate
Domain 3Objective 2
Task 3.2: Analyze Data by Using AWS Services DEA-C01 Practice Questions (Page 2)
Part of the Content Domain 3: Data Operations and Support domain, which accounts for 22% of the DEA-C01 exam. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~11–19 in this domain), expect 3–5 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)
23questions here
5free pages
10concepts
22%of the exam
Questions 6–10
- 6
A data engineer needs to run unpredictable, ad-hoc SQL queries on data in Amazon S3 and wants to avoid paying for idle infrastructure. Which service model is most appropriate for this workload?
Select an answer first - 7
A data engineer is using an Athena notebook with Apache Spark to explore a large dataset of IoT sensor readings. The engineer needs to calculate a 7-day rolling average of temperature readings for each sensor and identify any readings that deviate by more than 3 standard deviations from the rolling average. The engineer wants to perform this analysis interactively and iteratively. Which approach should the engineer take?
Select an answer first - 8
A data engineer needs to calculate the total sales for each product category in a sales table. Which SQL clause should be used to group the data by product category?
Select an answer first - 9
A data engineer needs to create a reusable, logical representation of a subset of data in Amazon Redshift so that analysts can query it without writing complex joins each time. Which SQL statement should the engineer use?
Select an answer first - 10
A data engineer needs to clean a dataset by removing rows with invalid values and standardizing date formats. The engineer prefers a visual, code-free approach and the data is stored in Amazon S3. Which AWS service is best suited for this task?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “DEA-C01” is a trademark of its owner, used for identification only.