Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Imagine you are working on a project that requires the implementation of Slowly Changing Dimension (SCD) tables using Delta Lake. Describe the steps you would take to implement SCD Type 2 tables for a customer database, including how you would handle historical data and updates using Delta Lake features.
Simulated
A
Use a combination of Spark SQL and Delta Lake to track changes and maintain historical data.
B
Manually update the customer database to handle historical data and changes.
C
Use a third-party tool to manage SCD Type 2 tables without using Delta Lake features.
D
Implement SCD Type 2 tables using only Spark SQL without leveraging Delta Lake features.
Comments
Loading comments...