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?

Real Exam

CREATE TABLE users USING SQLite OPTIONS (url = "jdbc:sqlite:/${da.username}ecommerce.db", dbtable = "users")

8.2%

CREATE TABLE users USING DATABASE OPTIONS (url = "jdbc:sqlite:/${da.username}ecommerce.db", dbtable = "users")

8.2%

CREATE TABLE users USING SQL OPTIONS (url = "jdbc:sqlite:/${da.username}ecommerce.db", dbtable = "users")

6.8%

CREATE TABLE users USING JDBC OPTIONS (url = "jdbc:sqlite:/${da.username}ecommerce.db", dbtable = "users")

74.1%

CREATE TABLE users USING ODBC OPTIONS (url = "jdbc:sqlite:/${da.username}ecommerce.db", dbtable = "users")

2.7%

Databricks Certified Data Engineer - Associate