A data engineer is tasked with creating a database named 'retail' at the location 'dbfs:/mnt/datalake/databases/retail'. They are uncertain if the database already exists. Which command should they use to ensure the database is created without errors if it already exists?

Real Exam

CREATE DATABASE retail USING LOCATION ‘dbfs:/mnt/datalake/databases/retail‘;

1.9%

CREATE DATABASE IF NOT EXISTS retail LOCATION ‘dbfs:/mnt/datalake/databases/retail‘;

89.0%

CREATE DATABASE retail LOCATION ‘dbfs:/mnt/datalake/databases/retail‘;

3.9%

CREATE DATABASE IF NOT EXISTS retail;

2.6%

CREATE DATABASE retail DELTA LOCATION ‘dbfs:/mnt/datalake/databases/retail‘;

2.6%

Databricks Certified Data Engineer - Associate