
Ultimate access to all questions.
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?
A
org.apache.spark.sql.jdbc
B
autoloader
C
DELTA
D
sqlite
E
org.apache.spark.sql.sqlite
Explanation:
The correct answer is A. org.apache.spark.sql.jdbc.
jdbc:sqlite:/customers.db - this indicates a JDBC connection to a SQLite database.org.apache.spark.sql.jdbc or simply jdbc.USING org.apache.spark.sql.jdbc or USING jdbc.USING org.apache.spark.sql.jdbc
OPTIONS (
url "jdbc:sqlite:/customers.db",
dbtable "customer360"
)
USING org.apache.spark.sql.jdbc
OPTIONS (
url "jdbc:sqlite:/customers.db",
dbtable "customer360"
)
Or the simplified version:
USING jdbc
OPTIONS (
url "jdbc:sqlite:/customers.db",
dbtable "customer360"
)
USING jdbc
OPTIONS (
url "jdbc:sqlite:/customers.db",
dbtable "customer360"
)
This code would create a DataFrame by reading from a SQLite database using JDBC driver.