A data engineer writes a DataFrame to a new table on Databricks with default settings and never names a storage format. What kind of table results?
Choose an answer to check it. Afterward, select any option to review its explanation.
Delta Lake is the default format on Databricks: Parquet data files plus a file-based transaction log, so each write becomes a new table version with ACID guarantees.
CSV is not the default format, and Databricks describes storing data in DBFS root as a deprecated pattern rather than the default for new tables.
Tables written with default settings are Delta Lake tables, not Hive SerDe tables, so there is nothing to upgrade.
Delta does store data in Parquet files, which makes this tempting, but by default Databricks adds the transaction log on top, so no conversion step is needed.
id qa627101220