
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 1 tables for a product database, including how you would handle updates using Delta Lake features.
A
Use a combination of Spark SQL and Delta Lake to track changes and update product data.
B
Manually update the product database to handle changes.
C
Use a third-party tool to manage SCD Type 1 tables without using Delta Lake features.
D
Implement SCD Type 1 tables using only Spark SQL without leveraging Delta Lake features.