
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?
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?
Real Exam