A media company processes clickstream data in near real-time using Amazon Kinesis Data Analytics. The data quality team wants to ensure that records with missing user IDs are not written to the output stream. They also want to track the number of dropped records for monitoring. Which approach should they use?

Post-process the output stream with a Lambda function to delete records with missing user IDs.

Add a SQL query that filters out records with null user_id and uses a separate stream to count dropped records.

Configure the Kinesis stream to reject records with missing user IDs automatically.

Use AWS Glue DataBrew to clean the data after it is stored in S3.

A marketing team has customer data from two sources: a CRM export and a web analytics export. They notice that some customers appear in both sources with different email addresses. They need to identify and resolve these inconsistencies to create a single customer view. Which tool is best suited for this task?

AWS Database Migration Service (DMS)

AWSCertified Data Engineer - Associate

Domain 3Objective 4

Task 3.4: Ensure Data Quality DEA-C01 Practice Questions (Page 3)

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 18 practice questions to prepare you well beyond it. (estimate)

18questions here

4free pages

5concepts

22%of the exam

Questions 11–15

11foundation · easy
In a distributed data processing job, a few keys have significantly more records than others, causing some partitions to take much longer to process. What is this phenomenon called?
Select an answer first
12application · medium
A media company processes clickstream data in near real-time using Amazon Kinesis Data Analytics. The data quality team wants to ensure that records with missing user IDs are not written to the output stream. They also want to track the number of dropped records for monitoring. Which approach should they use?
Select an answer first
13application · medium
A marketing team has customer data from two sources: a CRM export and a web analytics export. They notice that some customers appear in both sources with different email addresses. They need to identify and resolve these inconsistencies to create a single customer view. Which tool is best suited for this task?
Select an answer first
14application · medium
A healthcare company receives patient records in CSV format from multiple clinics. The data quality team wants to define rules to ensure that patient IDs are unique, dates are in the correct format, and required fields are not empty. They need a visual, no-code solution to create and apply these rules. Which AWS service should they use?
Select an answer first
15foundation · easy
A data engineer needs to define a rule that flags any row in a dataset where the 'age' column is not between 0 and 120. Which AWS Glue DataBrew feature should be used to create and apply this validation rule?
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.4: Ensure Data Quality DEA-C01 Practice Questions (Page 3)

Questions 11–15

In a distributed data processing job, a few keys have significantly more records than others, causing some partitions to take much longer to process. What is this phenomenon called?

A data engineer needs to define a rule that flags any row in a dataset where the 'age' column is not between 0 and 120. Which AWS Glue DataBrew feature should be used to create and apply this validation rule?

Keep studying — Content Domain 3: Data Operations and Support