Databricks Certified Data Engineer Associate - 340 Questions

1. A data engineer is explaining the Lakehouse architecture to a new team member. Which statement best describes the core value proposition of a Lakehouse compared to using a separate data lake and data warehouse?

2. A data engineering team stores customer transaction data in a Delta table registered in Unity Catalog. When a team member runs DROP TABLE on this managed table, what happens to the underlying data files?

3. A company stores its data in Amazon S3 using plain Parquet files. A data engineer proposes migrating to Delta Lake. Which feature of Delta Lake would most directly address the concern about partial write failures corrupting the dataset?

4. A company uses external Delta tables that point to data stored in their own Azure Data Lake Storage Gen2 account. A data engineer runs DROP TABLE on one of these external tables. What is the expected outcome?

5. A data engineering team wants to use the same data for both machine learning experiments and SQL-based business intelligence dashboards without duplicating data. Which characteristic of the Databricks Lakehouse Platform makes this possible?