data-engineer-professional video for an e-commerce company maintains its product information in a delta table named inventory with the following columns -
An e-commerce company maintains its product information in a delta table named inventory with the following columns - product_id , product_name , quantity , price and is_active . At the end of each month, they receive a new delta table named updated_inventory with the same schema as the inventory table. Which of the following MERGE INTO statements should be used to update the inventory table based on the end-of-month updates given that if the product_id is missing from the updated_inventory table, the is_active column in the inventory table should be turned to false?