Answer-first summary for fast verification
Answer: Table properties can be accessed by both clones, but the comments added to the creators table will not be available.
The transfer of comments and table properties does not depend on the type of clone. In both deep and shallow clones, the table properties are passed to the clone, whereas the comments, being native to a table, are not passed on to the clones. This means that while both clones will have access to the table's properties, neither will have access to the original table's comments.
Author: LeetQuiz Editorial Team
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.
No comments yet.