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

Question

A Data Engineer has created table t1 with one column c1 with datatype VARIANT: create or replace table t1 (c1 variant); The Engineer has loaded the following JSON data set, which has information about 4 laptop models, into the table. The Engineer now wants to query that data set so that results are shown as normal structured data. The result should be 4 rows and 4 columns, without the double quotes surrounding the data elements in the JSON data. The result should be similar to the use case where the data was selected from a normal relational table t2, where t2 has string data type columns model_id, model, manufacturer, and model_name, and is queried with the SQL clause select * from t2; Which select command will produce the correct results? A. B. C. D.

Options

• ASelect value:model_id::string , value:model::string , value:manufacturer::string , value:model_name::string from t1 , lateral flatten(input => c1);
• BSelect value:model_id::string , value:model::string , value:manufacturer::string , value:model_name::string from t1 , lateral flatten(input => c1:device_model);
• Cselect model_id::string , model::string , manufacturer::string , model_name::string from t1 , lateral flatten(input => c1:device_model);
• Dselect value:model_id , value:model , value:manufacturer , value:model_name from t1 , lateral flatten(input => c1:device_model);