How would you define an external SQL table by connecting to a local instance of an SQLite database using JDBC in Databricks?

Real Exam

CREATE TABLE users_jdbc USING SQLITE OPTIONS (url = “jdbc:/sqmple_db“, dbtable = “users“)

9.8%

CREATE TABLE users_jdbc USING org.apache.spark.sql.jdbc OPTIONS (url = “jdbc:sqlite:/sqmple_db“, dbtable = “users“)

64.1%

CREATE TABLE users_jdbc USING SQLURL = {server:“jdbc:/sqmple_db“,dbtable: “users”}

5.0%

CREATE TABLE users_jdbc USING org.apache.spark.sql.jdbc.sqlite OPTIONS (url = “jdbc:/sqmple_db“, dbtable = “users“)

11.9%

CREATE TABLE users_jdbc USING SQL OPTIONS (url = “jdbc:sqlite:/sqmple_db“, dbtable = “users“)

9.2%

Databricks Certified Data Engineer - Associate