Answer-first summary for fast verification
Answer: Data in the `flights` table is lost, but the `airports` table's data can still be accessed at its DBFS location.
The `flights` table, created with Delta, supports Time Travel for data recovery. However, dropping the table removes both metadata and data, and without using the `UNDROP` command or Time Travel (with a specific version or timestamp), the data is irrecoverable. Conversely, the `airports` table's data, stored as Parquet files at a static DBFS location, remains unaffected by the `DROP TABLE` command, allowing direct access to the data via its DBFS path.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.