Data Operations and Support A free question from our original DEA-C01 practice exam. Try it, then open the answer to see why each option is right or wrong.
A logistics broker's ETL job writes shipment records to a curated table. The upstream system occasionally sends the same shipment twice, and it sometimes sends a status code that is not one of the three allowed values: PICKED_UP, IN_TRANSIT or DELIVERED.
The data team wants two Glue Data Quality rules that fail the run for either problem, using DQDL.
Which TWO rules meet these requirements? (Choose two.)
Choose two answers.
AA. Add the rule IsUnique "shipment_id" to the ruleset that the job evaluates before it writes to the curated table.
BB. Add the rule ColumnValues "status" in ["PICKED_UP", "IN_TRANSIT", "DELIVERED"] to the ruleset that the job evaluates before it writes to the curated table.
CC. Add the rule RowCount > 0 to the ruleset that the job evaluates before it writes to the curated table.
DD. Add the rule IsComplete "status" to the ruleset that the job evaluates before it writes to the curated table.
EE. Add the rule ColumnLength "status" <= 10 to the ruleset that the job evaluates before it writes to the curated table.
DQDL rules run inside the Glue job and fail the run on a bad batch. IsUnique catches duplicate shipment IDs, and ColumnValues with an allowed list catches status codes outside the three valid values. Row counts, null checks and length checks pass for those bad records, so they do not meet the requirement.
Want more on Data quality? The 5 full-length practice sets have 11 more Data quality questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets →