Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which SQL command correctly attempts to create a new table in Databricks using a JDBC connection and throws an error if the table already exists?
A
INSERT INTO new_table SELECT * FROM jdbc(‘jdbc:mysql://database.example.com:3306/mydb‘, ‘existing_table‘, ‘username‘, ‘password‘)
B
CREATE TABLE new_table AS SELECT * FROM jdbc(‘jdbc:mysql://database.example.com:3306/mydb‘, ‘table_name‘, ‘username‘, ‘password‘)
C
CREATE TABLE new_table USING jdbc OPTIONS ( url ‘jdbc:mysql://database.example.com:3306/mydb‘, dbtable ‘new_table‘, user ‘username‘, password ‘password‘)
D
CREATE TABLE IF NOT EXISTS new_table USING jdbc OPTIONS ( url ‘jdbc:mysql://database.example.com:3306/mydb‘, dbtable ‘existing_table‘, user ‘username‘, password ‘password‘)
