Explanation:
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.
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.
No comments yet.