Databricks Certified Data Engineer - Professional

Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.


A data engineer is testing data for radio and TV channels with valid frequencies using the following SQL statements:

CREATE TABLE channels (name string, frequency float) LOCATION '/channels';
INSERT INTO channels VALUES ('DB', 101.2);
CREATE TABLE tv_channels (name string, frequency float) LOCATION '/channels';
INSERT INTO tv_channels VALUES ('FS', 10045.7);
DROP TABLE channels;
SELECT * FROM tv_channels;

Assuming the /channels location was initially empty, what will be the outcome of executing these statements?