Which SQL clause is used to create a table from JSON data?

The correct choice is to use the CREATE TABLE clause to create a table from JSON data. This command allows you to define a new table structure and specify the format of the data to be loaded into that table. When working with JSON data, you can leverage the CREATE TABLE syntax along with the appropriate data source options to define how the JSON data should be structured within the newly created table.

For instance, you can specify schema details that match the structure of the JSON documents. This makes it possible to efficiently retrieve and manipulate the nested and hierarchical data that is typical in JSON format.

In contrast, while INSERT INTO is utilized to add data to an existing table, UPDATE TABLE is meant for modifying existing records and DROP TABLE is used to remove a table from the database entirely. Each of these other clauses serves a distinct purpose in SQL and does not pertain to the process of creating a new table from JSON data.