
Ultimate access to all questions.
A Delta table named 'creators' was created with specific properties and a comment. A data engineer then creates both a shallow clone ('creators_old') and a deep clone ('creators_new') of this table. Which statement accurately describes the accessibility of the original table's comments and properties in these clones?
A
Table properties specified by TBLPROPERTIES will be accessible in creators_new table but not in the creators_old table, whereas neither clone can access the comment added to the creators table.
B
The comments added to the creators table can be accessed by both clones, but the table properties cannot be accessed.
C
Neither the comments nor the table properties can be accessed by the creators_old and creators_new tables.
D
Table properties can be accessed by both clones, but the comments added to the creators table will not be available.
E
Comments added to the creators table will be accessible in creators_new table but not in creators_old table, whereas neither clone can access the table properties.