AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 220

Question

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option 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. Amazon RDS is a managed relational database that handles patching, backups and failover.

AWS Certified Data Engineer - Associate DEA-C01 — Question 220