You have a column containing JSON strings that you wish to convert into structs. Which SQL command would you use to create a new table for storing these structs, ensuring no null fields are present, based on a schema derived from an example JSON string?

Real Exam

CREATE TABLE parsed_data AS SELECT FROM_JSON(json_column) AS struct_column FROM original_table;_

12.0%

CREATE TABLE parsed_data AS SELECT TO_STRUCT(json_column) FROM original_table;

14.3%

CREATE OR REPLACE TABLE parsed_events AS SELECT FROM_JSON(json_column, schema_of_json('')) AS struct_column FROM original_table;_

64.0%

CREATE TABLE parsed_data AS SELECT CAST(json_column AS STRUCT) FROM original_table;_

9.7%

Databricks Certified Data Engineer - Associate