Answer-first summary for fast verification
Answer: CREATE SCHEMA IF NOT EXISTS bronze LOCATION ‘/mnt/delta/bronze‘
The correct syntax to create a schema if it does not already exist is `CREATE SCHEMA IF NOT EXISTS schema_name [ LOCATION schema_directory ]`. This ensures the schema is only created if it doesn't already exist, preventing errors. For more details, refer to the [Databricks documentation](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-schema.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you create a schema named 'bronze' with the location '/mnt/delta/bronze' and ensure it doesn't already exist before creation?
A
CREATE SCHEMA bronze IF NOT EXISTS LOCATION ‘/mnt/delta/bronze‘
B
if IS_SCHEMA(‘bronze‘): CREATE SCHEMA bronze LOCATION ‘/mnt/delta/bronze‘
C
Schema creation is not available in metastore, it can only be done in Unity catalog UI
D
CREATE SCHEMA IF NOT EXISTS bronze LOCATION ‘/mnt/delta/bronze‘
E
Cannot create schema without a database
No comments yet.