A data engineer is using an AWS Glue ETL job to remove outdated customer records...

Amazon Web Services Data-Engineer-Associate Question Answer

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:

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?

All customer records that exist in both the customer accounts table and the monthly_accounts_update table will be deleted from the accounts table.

Only customer records that are present in both tables will be retained in the customer accounts table.

The monthly_accounts_update table will be deleted.

No records will be deleted because the command syntax is not valid in AWS Glue.

Amazon Web Services Data-Engineer-Associate View All Questions

Amazon Web Services Data-Engineer-Associate Summary

Vendor: Amazon Web Services
Product: Data-Engineer-Associate
Update on: Dec 15, 2025
Questions: 218

Price: $52.5 ~~$149.99~~

Buy Now Data-Engineer-Associate PDF + Testing Engine Pack

A data engineer develops an AWS Glue Apache Spark ETL job to perform transformations on...

A transportation company wants to track vehicle movements by capturing geolocation records.

New Year Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

A data engineer is using an AWS Glue ETL job to remove outdated customer records...

The Answer Is:

Explanation:

Amazon Web Services Data-Engineer-Associate Summary

Payments We Accept

Contact Us