Databricks Certified Data Engineer - Associate
Comments
Loading comments...
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.
A
The CTAS statement is used to create a new table by copying all data from an existing table without any transformation, ensuring data integrity but not addressing storage or performance optimization.
B
The CTAS statement is used to create a new table by merging data from multiple tables, which increases storage costs and does not necessarily optimize query performance for the reporting feature.
C
The CTAS statement is used to create a new table by partitioning the data from an existing table, which improves query performance but does not allow for data transformation or filtering.
D
The CTAS statement is used to create a new table based on the result of a SELECT query, allowing for data transformation and filtering, which can help in minimizing storage costs and optimizing query performance for the reporting feature.