Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineer needs to create an empty Delta table named students with specific columns, regardless of whether a table with this name already exists. Which SQL DDL command should they use?
students
A
CREATE TABLE IF NOT EXISTS students( id STRING, name STRING, dateOfBirth DATE, email STRING)
B
CREATE OR REPLACE TABLE students( id STRING, name STRING, dateOfBirth DATE, email STRING)
C
CREATE TABLE students( id STRING, name STRING, dateOfBirth DATE, email STRING)
D
CREATE OR REPLACE TABLE IF EXISTS students( id STRING, name STRING, dateOfBirth DATE, email STRING)
E
CREATE OR REPLACE TABLE students AS SELECT id STRING, name STRING, dateOfBirth DATE, email STRING USING DELTA
