Answer-first summary for fast verification
Answer: A stored view on the existing table
Creating a view on the table allows for renaming the required columns and filtering out sensitive data using the WHERE clause. This approach is efficient and meets the specified requirements without the need for duplicating data. Reference: [Databricks Documentation](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-view.html)
Author: LeetQuiz Editorial Team
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
No comments yet.