A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?
The correct command to create an empty Delta table in the specified format, regardless of whether a table with the same name already exists, is: CREATE OR REPLACE TABLE table_name (employeeId STRING, startDate DATE, avgRating FLOAT). This command ensures the table is created with the specified columns and data types, and it will replace any existing table with the same name.
E is correct you dont need to specify Delta as its the default storage format for tables.
E. correct
E is correct option
A and E have both correct syntax, but the question mentioned "regardless of whether a table already exists with this name". Hence the correct answer is E
E is correct