Question

While working on the project, you realize that the delta table is not correct. One of your friends suggests deleting the whole directory of the table and creating a new table on the same path. Would you follow the suggested solution?

A. Yes

B. No

Answer 1

Correct Answer: B

Reason:-

Deleting the whole directory of a Delta table and creating a new table on the same path is not a recommended solution as:

A directory may consist of very large files and deleting the directory can consume days or even hours. Therefore, it is not an efficient solution.

All the content of the deleted files is lost and if by mistake you delete a wrong file, it is very hard to recover it.

Deleting the directory is not atomic. While table deletion is in progress, a concurrent query reading the table can view a partial table or even fail.