Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
employees_per_department
A
CTAS commands require you to manually specify the schema details for the new table.
B
CTAS commands automatically infer the schema by scanning the data in the source table.
C
CTAS commands derive the schema from the query results, eliminating the need for explicit column specifications.
D
CTAS commands default all columns to the STRING data type unless specified otherwise.
STRING
E
CTAS commands do not support schemas, resulting in tables without defined columns.
