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

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

Question #: 220
Topic #: 1

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

A data engineer is using an AWS Glue ETL job to remove outdated customer records from a table that contains customer account information. The data engineer is using the following SQL command to remove customers that exist in a table named monthly_accounts_update table from the customer accounts table:

MERGE INTO accounts t USING monthly_accounts_update s

ON t.customer = s.customer -

WHEN MATCHED -

THEN DELETE -

What will happen when the data engineer runs the SQL command?

A. All customer records that exist in both the customer accounts table and the monthly_accounts_update table will be deleted from the accounts table.
B. Only customer records that are present in both tables will be retained in the customer accounts table.
C. The monthly_accounts_update table will be deleted.
D. No records will be deleted because the command syntax is not valid in AWS Glue.

Show Suggested Answer

Suggested Answer: A 🗳️

by XP_2600 at June 18, 2025, 4:01 p.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 ago

Selected Answer: A

Seems i was mistaken or there is some typos in post, i think its A

upvoted 1 times

...

XP_2600

1 month, 2 weeks ago

Selected Answer: D

Syntax is not valid glue syntax

upvoted 1 times

...