Certified Data Engineer Associate Exam

Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam

Question 95

A data architect has determined that a table of the following format is necessary:

Which code block is used by SQL DDL command to create an empty Delta table in the above format regardless of whether a table already exists with this name?

CREATE OR REPLACE TABLE table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )

CREATE OR REPLACE TABLE table_name WITH COLUMNS ( employeeId STRING, startDate DATE, avgRating FLOAT ) USING DELTA

CREATE TABLE IF NOT EXISTS table_name ( employeeId STRING, startDate DATE, avgRating FLOAT )

CREATE TABLE table_name AS SELECT employeeId STRING, startDate DATE, avgRating FLOAT

Correct Answer: B

To create an empty Delta table with the specified format, the correct SQL DDL command is 'CREATE OR REPLACE TABLE table_name WITH COLUMNS ( employeeId STRING, startDate DATE, avgRating FLOAT ) USING DELTA'. This command ensures that the table is created using Delta Lake format and replaces any existing table with the same name. The other options either do not use the Delta format or do not ensure the table is created regardless of existing tables with the same name.

Discussion

MDWPartnersOption: A

Repeated, correct.