Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To create a table named users in Databricks by extracting data from an external SQLite database named ecommerce, which of the following queries should you use?
users
ecommerce
A
CREATE TABLE users USING SQLite OPTIONS (url = "jdbc:sqlite:/${da.username}_ecommerce.db", dbtable = "users")
B
CREATE TABLE users USING DATABASE OPTIONS (url = "jdbc:sqlite:/${da.username}_ecommerce.db", dbtable = "users")
C
CREATE TABLE users USING SQL OPTIONS (url = "jdbc:sqlite:/${da.username}_ecommerce.db", dbtable = "users")
D
CREATE TABLE users USING JDBC OPTIONS (url = "jdbc:sqlite:/${da.username}_ecommerce.db", dbtable = "users")
E
CREATE TABLE users USING ODBC OPTIONS (url = "jdbc:sqlite:/${da.username}_ecommerce.db", dbtable = "users")
