Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineering team has created a Delta Lake table using the following query: CREATE TABLE target AS SELECT * FROM source. If a data engineer attempts to drop the source table with the command DROP TABLE source, what will be the outcome?
CREATE TABLE target AS SELECT * FROM source
DROP TABLE source
A
An error message will appear, indicating that other tables depend on this source table.
B
Both the target and source tables will be removed from the database.
C
The source table will not be dropped unless the CASCADE keyword is included in the command.
CASCADE
D
The source table will be dropped, but the target table will become unqueryable.
E
The source table will be dropped, and the target table will remain unaffected.
