Answer-first summary for fast verification
Answer: In Databricks, DATABASE and SCHEMA are interchangeable keywords that both create a schema (namespace) containing tables, views, functions, and volumes.
In Databricks, the DATABASE and SCHEMA keywords are interchangeable — both create the same type of object: a schema (namespace) that contains tables, views, functions, and volumes. In Unity Catalog, schemas are the second level in the three-level namespace: catalog.schema.table A schema is not a collection of databases — this is a misconception from some traditional RDBMS systems. A Delta log (_delta_log) is created only when you create a Delta table, not when creating a database/schema. Therefore, option B is incorrect, and E is also incorrect. Reference: Databricks Documentation – Schemas: https://docs.databricks.com/aws/en/schemas/
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What accurately describes the difference between the SCHEMA and DATABASE keywords in Databricks?
A
The DATABASE keyword is supported in Databricks whereas the SCHEMA keyword is not.
B
Using the DATABASE keyword will enable a Delta log for the database, whereas using the SCHEMA keyword will not.
C
In Databricks, DATABASE and SCHEMA are interchangeable keywords that both create a schema (namespace) containing tables, views, functions, and volumes.
D
A schema is a collection of databases.
E
Both B and D.