Explanation:
A CREATE TABLE AS SELECT (CTAS) statement takes the result set of the SELECT query and uses it to populate the newly created table. During this process, the engine automatically infers both the column names and their corresponding data types from the projection of the query, eliminating the need for manual schema declaration.
Ultimate access to all questions.
A
The new table automatically infers column names and types from the SELECT query.
B
All columns in a CTAS table default to the STRING type.
C
Schemas are strictly optional in Databricks.
D
The system prompts the user to define the schema during runtime.
No comments yet.