
Ultimate access to all questions.
The data engineering team seeks a straightforward method to share a portion of a large Delta Lake table with the data science team, involving only department-specific columns (with renamed columns) and excluding sensitive data. Which object creation meets these requirements?
A
A stored view on the existing table
B
A new Delta Table created using CTAS statement on the existing table
C
A new Delta Table created using SHALLOW CLONE from the existing table
D
An ad-hoc query on the existing table
E
A new Delta Table created using DEEP CLONE from the existing table