Ultimate access to all questions.
In a scenario where you are working with Delta Lake on Azure Databricks and need to create a new table that includes only specific columns and rows from an existing table, after applying some transformations and filters to meet the requirements of a new reporting feature. The solution must ensure data integrity, minimize storage costs, and optimize query performance. Which of the following statements accurately describes the purpose and benefits of using the CREATE TABLE AS SELECT
(CTAS) statement in this context? Choose the best option.