Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Question 12
A data engineer needs to create a database called customer360 at the location /customer/customer360. The data engineer is unsure if one of their colleagues has already created the database.
Which of the following commands should the data engineer run to complete this task?
Real Exam
Community
LLeetQuiz
A
CREATE DATABASE customer360 LOCATION '/customer/customer360';
B
CREATE DATABASE IF NOT EXISTS customer360;
C
CREATE DATABASE IF NOT EXISTS customer360 LOCATION '/customer/customer360';
D
CREATE DATABASE IF NOT EXISTS customer360 DELTA LOCATION '/customer/customer360';
E
CREATE DATABASE customer360 DELTA LOCATION '/customer/customer360';
Explanation:
Explanation
The correct answer is C because:
- The
IF NOT EXISTSclause ensures that the database is only created if it doesn't already exist, which addresses the engineer's uncertainty about whether a colleague has already created it - The
LOCATION '/customer/customer360'clause specifies the exact location where the database should be created - Option A would fail if the database already exists
- Option B doesn't specify the location, so it would use the default location
- Options D and E are incorrect because
DELTAis not a valid keyword in theCREATE DATABASEsyntax - Delta is a table format, not a database type
This command follows the proper Spark SQL syntax for creating a database with conditional existence checking and custom location specification.
Comments
Loading comments...