Answer-first summary for fast verification
Answer: To create a database
The `CREATE SCHEMA` command is an alias for the `CREATE DATABASE` statement. Although SCHEMA and DATABASE can be used interchangeably, SCHEMA is the preferred term. For more details, refer to the [Databricks documentation](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-database.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the primary purpose of the CREATE SCHEMA command in Databricks?
A
To create a table schema (columns names and datatype)
B
To merge the schema when writing data into a target table
C
To create a database
D
To infer and store schema in “cloudFiles.schemaLocation”
E
To create a Hive catalog