DEA-C02 Question #137: Real Exam Question with Answer & Explanation

Question

A company has loaded the following JSON data into the table and needs assistance CAR_SALES loading the data into a dimension. VEHICLE_DIM Which query will load the data into a VEHICLE_DIM? A. B. C. D.

Options

• AINSERT INTO VEHICLE_DIM SELECT value:make::string AS MAKE, value:model::string AS MODEL, value:price::number(18,2) AS PRICE FROM car_sales ,lateral flatten(input => src:vehicle);
• BINSERT INTO VEHICLE_DIM SELECT value:make::string AS MAKE, value:model::string AS MODEL, value:price::number(18,2) AS PRICE ve.value::string as "Extras Purchased" FROM car_sales ve;
• CINSERT INTO VEHICLE_DIM SELECT value:make::string AS MAKE, value:model::string AS MODEL, value:price::number(18,2) AS PRICE FROM car_sales ,lateral flatten(input => src:vehicle) vm , lateral flatten(input => vm.value:extras) ve;
• DINSERT INTO VEHICLE_DIM SELECT VM.value:make::string AS MAKE, VM.value:model::string AS MODEL, VM.value:price::number(18,2) AS PRICE, ve.value::string as "Extras Purchased" FROM car_sales , lateral flatten (input => src:vehicle) vm , lateral flatten (input => vm.value:extras) ve;