Databricks Certified Data Engineer - Professional
Comments
Loading comments...
Ultimate access to all questions.
A SQL notebook scheduled for daily execution contains a cell with the following statements aimed at dropping a table named billing if it exists, before creating and inserting values into the table. The statements are: DROP TABLE billing;, CREATE TABLE billing (item string, quantity int, price float);, and INSERT INTO billing VALUES (‘DP‘, 5, 500.00);. What modifications, if any, are needed to ensure the DROP TABLE statement does not throw an error?
A
Reverse the order of the DROP and CREATE statements.
B
Use DROP TABLE IF TABLE EXISTS instead of DROP TABLE.
C
Replace DROP TABLE with DROP IF TABLE EXISTS.
D
No changes are necessary; the statements will execute without errors.
E
Use DROP TABLE IF EXISTS in place of DROP TABLE.