When a data engineer uses the CTAS (CREATE TABLE AS SELECT) command to create a new table called `employees_per_department` based on a query, which of the following statements accurately describes the schema handling?

Real Exam

CTAS commands require you to manually specify the schema details for the new table.

7.2%

CTAS commands automatically infer the schema by scanning the data in the source table.

29.4%

CTAS commands derive the schema from the query results, eliminating the need for explicit column specifications.

55.6%

CTAS commands default all columns to the STRING data type unless specified otherwise.

5.6%

CTAS commands do not support schemas, resulting in tables without defined columns.

2.2%

Databricks Certified Data Engineer - Associate