Which of the following lines of code fills in the above blank to successfully complete the task?

A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database.

They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?
A . org.apache.spark.sql.jdbc
B . autoloader
C . DELTA
D . sqlite
E . org.apache.spark.sql.sqlite

View Answer

Answer: D

Explanation:

: In the given command, a data engineer is trying to create a table in Databricks using data from an SQLite database. The correct option to fill in the blank is “sqlite” because it specifies the type of database being connected to in a JDBC connection string. The USING clause should be followed by the format of the data, and since we are connecting to an SQLite database, “sqlite” would be appropriate here.

Reference: Create a table using JDBC JDBC connection string SQLite JDBC driver