Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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‘)