Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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
