Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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 0 tables for a customer database, including how you would handle static attributes using Delta Lake features.
A
Use a combination of Spark SQL and Delta Lake to track static attributes and maintain data integrity.
B
Manually update the customer database to handle static attributes.
C
Use a third-party tool to manage SCD Type 0 tables without using Delta Lake features.
D
Implement SCD Type 0 tables using only Spark SQL without leveraging Delta Lake features.