AWS Lake Formation FindMatches for Record Matching
Short answer
D Train and use the AWS Lake Formation FindMatches transform in the ETL job to identify matching records without common unique identifiers.
Question
Key Takeaways
The exam tests knowledge of specific AWS Lake Formation capabilities, specifically the 'FindMatches' transform, which is designed for record linkage and deduplication without exact key matches.
This question addresses using AWS Lake Formation's built-in ML transform to identify matching records without unique identifiers in an ETL pipeline. The correct solution leverages automated machine learning rather than manual pattern matching or filtering.
Common mistake: Candidates often choose Amazon Macie (Option A) because it involves data discovery and patterns, but Macie is focused on security and PII detection, not general record matching for business logic.
Expert Analysis
Why the Answer Is Correct
AWS Lake Formation provides a native ML transform called FindMatches within its Glue ETL integration. This transform uses machine learning models trained on sample data to identify duplicate or matching records across datasets, even when there is no common unique identifier (like a primary key) and fields do not match exactly. It automates the complex task of record linkage, which fits the scenario perfectly.
Why the Other Options Are Wrong
Amazon Macie (A) is a security service that uses machine learning to discover sensitive data (PII) and enforce policies; it does not perform general-purpose record matching for business data integration. AWS Glue PySpark Filter class (B) requires predefined logical conditions and cannot intelligently infer matches between non-identical fields without extensive custom coding and heuristics. Partitioning tables (C) organizes data for query performance but does not solve the problem of identifying which rows are duplicates or matches.
Community Comment Notes
Community consensus strongly supports D. As Shanmahi noted, "The FindMatches transform enables you to identify duplicate or matching records... even when the records do not have a common unique identifier." Another user confirmed simply that "Correct answer is D," reflecting the straightforward nature of this specific feature knowledge point.
Exam Strategy
Memorize the specific ML transforms available in AWS Lake Formation, particularly FindMatches for deduplication and MatchLabels for classification. When a question mentions 'matching records without unique IDs,' think immediately of Lake Formation's ML capabilities rather than standard Glue transformations or security tools.
Frequently Asked Questions
Can I use Amazon Macie for record matching?
Is FindMatches part of standard AWS Glue?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 2 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 2
-
Shanmahi 👍 6 Answered DAWS Lake Formation provides machine learning capabilities to create custom transforms to cleanse your data. There is currently one available transform named FindMatches. The FindMatches transform enables you to identify duplicate or matching records in your dataset, even when the records do not have a common unique identifier and no fields match exactly. This will not require writing any code or knowing how machine learning works.
-
RockyLeon 👍 1 Answered DCorrect answer is D
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DEA-C01 Questions
Access 100 questions with complete answers and detailed explanations.
View Full DEA-C01 Practice Test →