A data engineer has registered an external table named `sales` in CSV format, using data from CSV files in a specific directory. New files are added to this directory daily. However, when querying the table the next day, the data count remains unchanged from the previous day. What is the most efficient solution to ensure the table reflects the latest data?

Real Exam

Manually check the directory for new files, create a temporary view for them, and then load the data into the actual table.

6.0%

Drop and recreate the table daily to include new data.

6.5%

Convert the table to the Delta format to automatically recognize new files.

30.0%

Store the table in a cloud-based external system for automatic updates.

13.0%

Refresh the table to invalidate the cache before running the next query.

44.5%

Databricks Certified Data Engineer - Associate