A data engineer wants to summarize a dataset by calculating the average order value and the number of orders. Which pair of SQL aggregate functions should be used?

COUNT(order_value) and SUM(order_id)

AVG(order_value) and COUNT(order_id)

MIN(order_value) and AVG(order_id)

SUM(order_value) and MAX(order_id)

A data engineer is using an Athena notebook with Apache Spark to explore a dataset of customer transactions. The engineer needs to identify and clean rows where the 'transaction_amount' column is negative, as these are considered invalid. The engineer wants to perform this cleaning as part of the interactive exploration. Which PySpark code should the engineer use?

df_clean = df.select('transaction_amount')

df_clean = df.dropna(subset=['transaction_amount'])

df_clean = df.groupBy('transaction_amount').count()

df_clean = df.filter(df['transaction_amount'] >= 0)

A data engineer is calculating a 7-day rolling average of daily sales. For the data point on January 10th, which values are included in the calculation?

Sales from January 4th through January 10th

Sales from January 1st through January 10th

Sales from January 10th through January 16th

AWSCertified Data Engineer - Associate

Domain 3Objective 2

Task 3.2: Analyze Data by Using AWS Services DEA-C01 Practice Questions (Page 4)

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 16–20

16foundation · easy
A data engineer wants to summarize a dataset by calculating the average order value and the number of orders. Which pair of SQL aggregate functions should be used?
Select an answer first
17application · medium
A data engineer is using an Athena notebook with Apache Spark to explore a dataset of customer transactions. The engineer needs to identify and clean rows where the 'transaction_amount' column is negative, as these are considered invalid. The engineer wants to perform this cleaning as part of the interactive exploration. Which PySpark code should the engineer use?
Select an answer first
18foundation · easy
A data engineer needs to verify that a dataset contains no duplicate records and that all required fields are populated. The engineer wants to perform this check using a serverless SQL query directly on data stored in Amazon S3. Which AWS service is most appropriate for this task?
Select an answer first
19foundation · easy
A data engineer needs to query data stored in Amazon S3 using standard SQL without provisioning any servers. The data is in CSV format and has a table definition in the AWS Glue Data Catalog. Which AWS service should the engineer use?
Select an answer first
20foundation · easy
A data engineer is calculating a 7-day rolling average of daily sales. For the data point on January 10th, which values are included in the calculation?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DEA-C01

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.

Task 3.2: Analyze Data by Using AWS Services DEA-C01 Practice Questions (Page 4)

Questions 16–20

A data engineer wants to summarize a dataset by calculating the average order value and the number of orders. Which pair of SQL aggregate functions should be used?

A data engineer needs to verify that a dataset contains no duplicate records and that all required fields are populated. The engineer wants to perform this check using a serverless SQL query directly on data stored in Amazon S3. Which AWS service is most appropriate for this task?

A data engineer needs to query data stored in Amazon S3 using standard SQL without provisioning any servers. The data is in CSV format and has a table definition in the AWS Glue Data Catalog. Which AWS service should the engineer use?

A data engineer is calculating a 7-day rolling average of daily sales. For the data point on January 10th, which values are included in the calculation?

Keep studying — Content Domain 3: Data Operations and Support