A data engineer tries to execute the databricks video

 ·  PT1H46M27S  ·  EN

data-engineer-professional video for a data engineer tries to execute the following set of statements to test the data for radio and TV channels with valid

Full Certification Question

A data engineer tries to execute the following set of statements to test the data for radio and TV channels with valid frequencies: 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 ; Which of the following describes the output of the above set of statements, assuming that the /channels location was empty before executing the above set of statements?