Exam Certified Data Engineer Associate topic 1 question 55 discussion

E is correct you dont need to specify Delta as its the default storage format for tables.

E is correct because you dont need to specify Delta as its the default storage format for tables and the question states "regardless of whether the table already exists". As a result A is wrong as it will NOT recreate the table if it exists.

The closest correct option could be C but it shouldn't have with column clause To create an empty Delta table with the specified schema in SQL, you can use the CREATE TABLE statement with the USING DELTA clause. The IF NOT EXISTS option ensures that the table is created only if it does not already exist. Here’s the SQL code block that accomplishes this: CREATE TABLE IF NOT EXISTS your_table_name ( employeeld STRING, startDate DATE, avgRating DOUBLE ) USING DELTA;

A is the correct answer. create table if not exists will check if the table already exists in database. if not it will create the new table.

E is correct

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 option

E. correct