Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 212 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 212
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is named reference, and the other dataset is named primary.

The data engineer needs a solution to determine whether a specific set of values in the city and state columns of the primary dataset exactly match the same specific values in the reference dataset. The data engineer wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job.

Which rule will meet these requirements?

A. DatasetMatch "reference” “city->ref_city, state->ref_state” = 1.0
B. Referentiallntegrity “city,state” “reference.{ref_city,ref_state}” = 1.0
C. DatasetMatch “reference” “city->ref_city, state->ref_state” = 100
D. Referentialintegrity “city,state” "reference.{ref_city,ref_state}” = 100

Show Suggested Answer

Suggested Answer: B 🗳️

by habros at June 17, 2025, 5:04 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

XP_2600

1 month, 2 weeks ago

Selected Answer: A

Seems A to me

upvoted 1 times

...

habros

2 months ago

Selected Answer: B

exact match = checking referential integrity. can only be between 0 and 1 (decimal notation). 1 meaning strict compliance (must match or fail) https://aws.amazon.com/blogs/big-data/set-up-advanced-rules-to-validate-quality-of-multiple-datasets-with-aws-glue-data-quality/

upvoted 1 times

...