Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
In a data engineering project, you are tasked with implementing Slowly Changing Dimension (SCD) tables in Delta Lake to handle both streaming and batch data workloads. The project requires tracking historical changes for compliance and reporting purposes, while also ensuring the solution is cost-effective and scalable. Considering these requirements, which of the following statements accurately describes the correct approach to implement an SCD Type 1 table in Delta Lake? Choose one option.