Databricks Certified Data Engineer Associate · Free Practice Question Medium
Question 15
Which of the following statements is Not true about CTAS statements ?
-
A
CTAS statements support manual schema declaration
-
B
With CTAS statements, data will be inserted during the table creation
-
C
CTAS statements stand for CREATE TABLE _ AS SELECT statement
-
D
CTAS statements automatically infer schema information from query results
Reveal correct answer
Correct answer: A
Explanation
CREATE TABLE AS SELECT statements, or CTAS statements create and populate Delta tables using the output of a SELECT query. CTAS statements automatically infer schema information from query results and do not support manual schema declaration.
Study materials from our exam preparation course on Udemy:
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
