Question 1mediummulti select
Read the full Data Transformation explanation →DEA-C02 Data Transformation • Complete Question Bank
Complete DEA-C02 Data Transformation question bank — all 0 questions with answers and detailed explanations.
{
"customer_id": 101,
"orders": [
{"id": "A1", "items": [{"prod": "widget", "qty": 2}, {"prod": "bolt", "qty": 5}]},
{"id": "A2", "items": [{"prod": "gear", "qty": 1}]}
]
}MERGE INTO target_table t USING staging_table s ON t.id = s.id WHEN MATCHED AND s.status = 'DELETED' THEN DELETE WHEN MATCHED THEN UPDATE SET t.val = s.val WHEN NOT MATCHED THEN INSERT (id, val) VALUES (s.id, s.val);
ALTER TABLE sales_data ADD SEARCH OPTIMIZATION ON EQUALITY(customer_email);