Answer-first summary for fast verification
Answer: org.apache.spark.sql.jdbc
The correct way to specify the data source for creating a table in Databricks that connects to an external database via JDBC is to use the fully qualified JDBC class name. In this scenario, `org.apache.spark.sql.jdbc` is the appropriate format for specifying the JDBC source for Spark SQL commands. This option enables Spark to utilize the JDBC connector to interact with external databases, such as SQLite, by providing the JDBC URL and other necessary connection options. The `USING` clause in the `CREATE TABLE` command must be followed by the data source format recognized by Spark for establishing the connection, making `org.apache.spark.sql.jdbc` the correct choice for integrating with an SQLite database via JDBC.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is working on creating a table in Databricks by sourcing data from an existing SQLite database. The following command is executed: CREATE TABLE jdbc_customer360 USING _____________ OPTIONS (url “jdbc:sqlite:/customers.db“, datatable “customer360“). Which option correctly completes the command to achieve this task?
A
autoloader
B
DELTA
C
org.apache.spark.sql.sqlite
D
sqlite
E
org.apache.spark.sql.jdbc
No comments yet.