
Ultimate access to all questions.
A team of data engineers initiated a project seven years ago, creating two tables with specific SQL statements. The flights table was created using DELTA, and the airports table was created using PARQUET, stored at a static DBFS location. A junior data engineer accidentally drops both tables. Given that the UNDROP command cannot be used, what happens to the data in these tables?
A
Both tables' data can be retrieved using the Time Travel feature of Delta tables.
B
Tables cannot be dropped without deleting all records.
C
Data in the flights table can be recovered using Time Travel, but the airports table's data cannot.
D
Data in the airports table remains accessible at its DBFS location, and the flights table's data can be recovered via Time Travel.
E
Data in the flights table is lost, but the airports table's data can still be accessed at its DBFS location.