Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
In the context of Delta Lake, consider a scenario where you need to process a large dataset stored in a Delta table. The dataset contains customer information, including some records with incomplete or incorrect data. Your goal is to create a new, cleaned version of this dataset that only includes records with complete and correct information, and you want to ensure that the new table is optimized for fast query performance. Given these requirements, which of the following statements best describes the purpose and use of the CREATE TABLE AS SELECT (CTAS) statement in Delta Lake for this scenario? Choose the best option from the four provided.