A team of data engineers started a project databricks video
data-engineer-professional video for a team of data engineers started a project seven years ago. Two tables were created with the following SQL statements:
Full Certification Question
A team of data engineers started a project seven years ago. Two tables were created with the following SQL statements: CREATE TABLE flights ( flight_number STRING , source STRING , destination STRING ) using DELTA ; CREATE TABLE airports ( airport_id STRING , city STRING , country STRING ) USING PARQUET LOCATION 'dbfs:/airports/data/' ; The DBFS location dbfs:/airports/data/ contains static data for the airports while the data in the flights table is updated on a daily basis. After the creation of the tables, the definition of the tables was not altered. A junior data engineer joins the team and runs the following SQL statements. DROP TABLE flights ; DROP TABLE airports ; Which of the following statements is true about the data present in the tables? Assume that the UNDROP command, recently launched by Databricks, cannot be used.