Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

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?

Real Exam

CREATE TABLE IF NOT EXISTS students( id STRING, name STRING, dateOfBirth DATE, email STRING)

3.1%

CREATE OR REPLACE TABLE students( id STRING, name STRING, dateOfBirth DATE, email STRING)

74.6%

Loading comments...

CREATE OR REPLACE TABLE IF EXISTS students( id STRING, name STRING, dateOfBirth DATE, email STRING)

10.4%

CREATE OR REPLACE TABLE students AS SELECT id STRING, name STRING, dateOfBirth DATE, email STRING USING DELTA

8.8%