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?
Certified Data Engineer Associate Exam QuestionsBrowse all questions from this exam
Certified Data Engineer Associate Exam - Question 95
Show AnswerHide Answer
Correct Answer: AB
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
1 commentMDWPartnersOption: A
May 25, 2024Repeated, correct.