Databricks Certified Data Engineer - Associate
Get started today
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 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?
Explanation:
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.