
Ultimate access to all questions.
As part of the project to create a comprehensive employee performance tracking system, a data architect has specified the need for a new table designed to store employee ratings over time. The required schema for this table is as follows: ( employeeId STRING, startDate DATE, avgRating FLOAT ).
Which code block, using a SQL Data Definition Language (DDL) command, would you utilize to create an empty Delta table with the aforementioned schema? The solution should ensure that the table is created even if a table with the same name already exists, without causing errors due to existing table conflicts.
A
CREATE OR REPLACE TABLE table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )_
B
CREATE OR REPLACE TABLE table_name WITH COLUMNS ( employeeId STRING, startDate DATE, avgRating FLOAT ) USING DELTA_
C
CREATE TABLE IF NOT EXISTS table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )_
D
CREATE TABLE table_name AS SELECT employeeId STRING, startDate DATE, avgRating FLOAT_