Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

Deep dive into the quiz with AI chat providers.

We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database. They run the following command:

CREATE TABLE jdbc_customer360
USING __________
OPTIONS (
    url "jdbc:sqlite:/customers.db",
    dbtable "customer360"
)

CREATE TABLE jdbc_customer360
USING __________
OPTIONS (
    url "jdbc:sqlite:/customers.db",
    dbtable "customer360"
)

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

Real Exam

Community

KKeng

Last updated: January 13, 2026 at 09:15

org.apache.spark.sql.jdbc

autoloader

DELTA

sqlite

org.apache.spark.sql.sqlite

Explanation:

Explanation

The correct answer is A. org.apache.spark.sql.jdbc.

JDBC Data Source Format: When creating a table using JDBC connection in Spark SQL, you need to specify the JDBC data source format, which is org.apache.spark.sql.jdbc.
SQLite JDBC Driver: The URL jdbc:sqlite:/customers.db indicates a SQLite database connection using the SQLite JDBC driver.
Spark SQL Syntax: The USING clause in Spark SQL's CREATE TABLE statement requires the fully qualified name of the data source format.

B. autoloader: Auto Loader is for streaming file ingestion, not for JDBC database connections.
C. DELTA: Delta format is for creating Delta Lake tables, not for connecting to external JDBC databases.
D. sqlite: This is not a valid Spark SQL data source format.
E. org.apache.spark.sql.sqlite: This format doesn't exist in Spark SQL; the correct JDBC format is org.apache.spark.sql.jdbc.

The OPTIONS clause provides the JDBC connection parameters:

This approach allows Spark to read data from SQLite databases using JDBC drivers and create a table reference in Databricks.

Powered ByGPT-5.2

Loading comments...