
Answer-first summary for fast verification
Answer: org.apache.spark.sql.jdbc
To create a table in Databricks from an existing SQLite database, the appropriate connector for JDBC must be specified. The correct line to fill in the blank is 'org.apache.spark.sql.jdbc', which allows Databricks to read from JDBC-compliant databases. Therefore, the answer is A.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer has to create a table named new_employees_table in Databricks, utilizing data from their organization’s existing SQLite database. The following command is executed:
CREATE TABLE new_employees_table USING _____ OPTIONS ( url '<jdbc_url>', dbtable '<table_name>', user '<username>', password '<password>' ) AS SELECT * FROM employees_table_vw.
Which line of code correctly fills in the blank to allow the successful creation of the table?
A
org.apache.spark.sql.jdbc
B
autoloader
C
DELTA
D
sqlite
E
org.apache.spark.sql.sqlite
No comments yet.